(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
( 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)
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)
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 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.