Oracle 12C Breakthrough
Oracle 12C breakthrough dual format in-memory database stores data in Row and Column format simultaneously. This is giving 100x faster analytics and reporting from the column format and 2x faster on line transaction processing (OLTP) from the row format. At Oracle OpenWorld this was in Larry’s keynote speech, which can be viewed at http://medianetwork.oracle.com/video/player/2685494045001
Most indexes in OLTP databases (eg ERP databases) are only used for analytic queries and slow down transactions. Inserting one row into a table can require many indexes to be updated. The new column store replaces the analytic indexes thus making insert and updates to the OLTP tables quicker and making the queries much faster by using the Column store. Larry says this is easy to use and requires no application change.
A reference was given from Yahoo as follows
“While testing Oracle Database In-Memory I measured query speeds 100x faster than the same queries in-memory today.”
Looking forward to more announcements from oracle OpenWorld 2013
Further information from Oracle can be found here