Ranko Mosic

(Please refer to the following article: Real-time Intelligence, Hybrid OLTP/OLAP Now Possible with Columnar for update on IMDB/Columnar 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 architect... (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)

Oracle 12c In-Memory, Columnar Database & How It Relates to SAP Hana

All major relational database vendors are developing or already shipping  in-memory, columnar databases. The next release of Oracle 12c - an in-memory, columnar database, will be available next year. It will feature simultaneous transaction-level updates to both  row and column stores i.e. data will be stored in both formats at the same time, in the same transaction. This is quite an improvement over SAP Hana's awfully clumsy delta merge process ( data changes in SAP Hana are first accumulated in delta store, then periodically merged into column store - process which locks targe... (more)

Real-time, Hybrid OLTP/OLAP Now Possible with Columnar, In-memory Databases

Latest database related announcements from major vendors like Oracle and IBM enable radical shifts in the way we design OLTP/OLAP databases and applications. It is now possible to serve both OLTP and analytical needs from the same database. Traditional database and application design processes  should be modernized to fully utilize new capabilities. Contemporary corporate databases are roughly classified as either OLTP or OLAP - analytical ( Data Marts, Data Warehouses ). OLTP physical database design implies tables tied together via relationships to describe business process.  H... (more)

Oracle 12c Database and How It Relates to SAP Hana

Oracle 12c database and related suite of products are just released. Columnar, compressed, high-speed, in-memory database to directly compete with SAP Hana is what is promised in the next release of Oracle 12c database. What we got so far is the familiar giant hairball that grew bigger. In order to currently achieve  Oracle's version of the  holy grail of cloud, in-memory, columnar, compressed, clustered services you must purchase, integrate and manage a variety of Oracle products: 12c database, Exadata software and hardware, TimesTen database, Oracle Clusterware, ASM etc. Oracle... (more)