In-Memory Feature Supercharges Oracle 12c
Written by Kay Ewbank   
Friday, 13 June 2014

Oracle has released an in-memory feature for Oracle 12c that makes it up to 1,000 times faster for some tasks.

 

The database is “orders-of-magnitude faster—like the difference between walking and flying in a plane,” according to Juan Loaiza, Oracle SVP Systems Technology, speaking at the launch event where the new module was presented by CEO Larry Ellison. Oracle says the performance improvement is 100 to 1,000 times faster for enterprise application modules and that the In-Memory feature can be deployed with “virtually any existing Oracle Database-compatible application”. The process is claimed to be as easy as flipping a switch--no application changes are required.

The dual-format in-memory architecture is described as combining the best of row format and column format to simultaneously deliver fast analytics and efficient OLTP. In other words, the In-Memory feature lets your apps take advantage of columnar in-memory processing without additional programming or application changes. It is not limited in the size of the database on which it is used because it does not require that all data fit into memory.

Loaiza says Oracle customers “don’t have to put all the data in expensive DRAM. They can easily distribute it to where it makes most sense.”

Other data is stored in less-expensive Flash or on disk, and Oracle Database In-Memory works seamlessly with them all.

Oracle Database In-Memory demonstrated from 100x to more than 1000x speedup for enterprise application modules in performance tests, including Oracle E-Business Suite, Oracle’s JD Edwards, Oracle’s PeopleSoft, Oracle’s Siebel, and Oracle Fusion Applications. In-Memory fault tolerance on Oracle Engineered Systems optionally duplicates in-memory data across nodes, so you could have queries that instantly use a copy of in-memory data if a server fails. In-Memory inherits the environment of Oracle 12C, and has full data type support: relational, objects, XML, text, spatial, and new integrated JSON support.

Other in-memory database solutions include SAP HANA, and IBM BLU Accelerator for DB2. Oracle Database In-Memory is scheduled for general availability in July. Pricing hasn’t been announced yet.

 

 

 

 

More Information

Oracle Database In-Memory

Related Articles

100 x Faster Queries Promises Oracle

 

To be informed about new articles on I Programmer, install the I Programmer Toolbar, subscribe to the RSS feed, follow us on, Twitter, Facebook, Google+ or Linkedin,  or sign up for our weekly newsletter.

 

Banner


Master Large Language Model Ops
20/03/2024

New technology brings with it more career opportunities. You may never have imagined becoming an LLMOps consultant,  but there's now a Coursera Specialization which provides preparation for this  [ ... ]



Crazy Clocks
10/03/2024

It's that time again when the clocks change and  time is of the essence and I indulge my interest in crazy clocks. I am always surprised that there are still new ideas for how to display the time [ ... ]


More News

 

raspberry pi books

 

Comments




or email your comment to: comments@i-programmer.info

 

Last Updated ( Friday, 13 June 2014 )