Boasting about Oracle's In-Memory Database

Oracle is trying to halt some of the migrations from Oracle to SAP HANA with their new Oracle 12c In Memory technology.  Basically it allows you to "Pin" tables in memory in a columnstore cache.

Some speed boasts:

• Database queries and analytics running between 100 and 1,000 times faster than in the past.

• With in-memory technology, Oracle 12c database allows each CPU core to scan 2.5 billion rows per second.

• The time it takes for the 12c database to process 10 million invoice lines has been shrunk from 244 minutes to 4 seconds.

• The time it takes to run a financial analysis program is cut from about four hours to roughly 12 seconds

• A system for keeping track of a company’s transportation network featuring 16,000 drivers and 60 million shipment data records, is slashed to under a second from 16 minutes.

• A process that had previously taken 58 hours now needs only 13 minutes.

Welcome to a world where disks are a thing of the past.  Pretty soon I predict that physical disks will go the way of tape drives, and we'll all be running with 2-4 terabytes of RAM.

http://diginomica.com/2014/06/11/larry-ellison-database-fast-customers-broken/?utm_source=dlvr.it&utm_medium=twitter&utm_campaign=Feed%3A+diginomica2+%28diginomica%29