In-Memory Feature Supercharges Oracle 12c
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


Choosing A Computer Language
09/08/2015

If you are new to programming there is a bewildering array of possibilities. Which is the best language to start with is a question that will get many different answers - but knowing which one is righ [ ... ]



COBOL for Node.js
19/08/2015

If you had to come up with unlikely language pairings, COBOL and Node.js would score pretty highly as a “least likely to be used together” choice. However, if for some reason you decide your legac [ ... ]


More News

 

blog comments powered by Disqus

 

Last Updated ( Friday, 13 June 2014 )
 
 
Banner

   
RSS feed of news items only
I Programmer News
Copyright © 2015 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.