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


BusyBeaver(5) Is 47,176,870
03/07/2024

The thing about the BusyBeaver function is that it is very easy to understand, but very difficult to compute. We now know its value up to 5, which isn't much progress for more than 50 years work.



Access LLMs From IntelliJ With Devoxx Genie
02/07/2024

Devoxx Genie is a fully Java-based LLM Code Assistant plugin for IntelliJ IDEA, designed to integrate with local and cloud LLM providers.


More News

 

kotlin book

 

Comments




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

 

Last Updated ( Friday, 13 June 2014 )