(Please refer to the following article: Oracle 12c In-Memory, Columnar
Database & How It Relates to SAP Hana 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
Data processing power is likely to continue growing. Are contemporary IT
development methods, processes and procurement practices properly positioned
to take advantage of increasing capabilities?
CPU/Memory/Storage can today be provisioned in a few clicks. Limitations
presented by processing power and physical infrastructure will continue to be
of less importance, as was the case in the past.
We are gradually coming close to a situation where constraints determining
present corporate IT standards are not an issue any more. For example, it is
current practice that OLTP and analyti... (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.