Big Data Consultant

Ranko Mosic

Subscribe to Ranko Mosic: eMailAlertsEmail Alerts
Get Ranko Mosic via: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn

Top Stories by Ranko Mosic

(Please refer to the following article: Oracle 12c In-Memory Database is Out - Hardly Anybody Notices for update on Oracle 12c databases) Contemporary large servers are routinely configured with 2TB of RAM. It is thus possible to fit an entire average size OLTP database in memory directly accessible by CPU. There is a long history of academic research on how to best utilize relatively abundant computer memory. This research is becoming increasingly relevant as databases serving business applications are heading towards memory centric design and implementation. If you simply place Oracle RDBMS's files on Solid State Disk, or configure buffer cache (SGA) large enough to contain the whole database, Oracle will not magically become an IMDB database, nor it will perform much faster.  In order to properly utilize memory, IMDB databases require purposely architected, confi... (more)

Big Data, Machine Learning and Innovation

Big Data and its most prominent technical ingredient, Machine Learning, are all the rage these days, as IT industry is trying to convince companies technology revolution is underway. ( "If you are not doing it, your competitors sure are, and by the time you realize it, it will be too late" ). Data fracking, i.e. Big Data, is 21 century new oil of that will power and grease stalled industries and reignite growth, or so the story goes. While advanced analytics (it comes under various names - predictive analytics, data mining, and data science, more recently) is great and in use fo... (more)

Column Store, In-Memory, MPP Databases and Oracle

( For latest information on Oracle 12c database update please refer to the following article: Oracle 12c Database and How It Relates to SAP Hana ) RDBMSs are stable and mature products. While there is nothing radically new on horizon that would challenge Codd's relational theory and related advances in data processing there are some developments that force established vendors like Oracle to come up with new features and products. Column Stores and Oracle Column store concept has been around for quite a while. Vendors like HP Vertica grabbed some market share in data warehousing seg... (more)

The Oracle Database Cloud Service vs Oracle on Amazon RDS, EC2

The Oracle Database Cloud is Platform as a Service ( PaaS ) so it only makes sense to compare it to Oracle on Amazon RDS.  Oracle on Amazon EC2, on the other hand, is an IaaS ( Infrastructure as a Service ) offering, which gives you full control over the installation, features and actions around your database. Oracle Public Cloud will consist of a number of major services, the Oracle Database Cloud being one of them. Please refer here for a complete list  of services. One of the most interesting characteristics of the Oracle Database Cloud is that there is no need to  purchase d... (more)

Overcoming Large Oracle Database Performance Problems

Typical Oracle VLDB is multi terabyte megalith running on big, expensive hardware. It is hard or impossible to back up, adding or modifying columns can take days and query optimization is very difficult. Database sharding is a well known method of breaking up a large database into smaller, manageable pieces ( database shards ). It is data warehouses i.e. VLDBs that can best take advantage of AWS database sharding capabilities. Basic premise is: manage huge volume of data by splitting it into multiple databases instead of creating table partitions. Database sharding provides a me... (more)