Software // Information Management
News
6/10/2014
04:12 PM
Connect Directly
Google+
LinkedIn
Twitter
RSS
E-Mail
50%
50%

Oracle In-Memory 12c Arrives In July

Oracle CEO Larry Ellison says in-memory option will bring faster analytical and transactional performance without changes to Oracle database.

6 Models Of The Modern Data Center
6 Models Of The Modern Data Center
(Click image for larger view and slideshow.)

In-memory performance without compromises -- that's what Oracle CEO Larry Ellison promised Tuesday in a Webcast in which he announced that the long-awaited Oracle 12c In-Memory Option will be generally available in July.

Oracle is delivering in-memory database capabilities years behind SAP's Hana platform and months behind Microsoft's In-Memory OLTP option for SQL Server 2014, but Ellison insisted "other in-memory databases came out sooner because we had a different set of goals."

The three goals were, he said, speeding up analytical applications, speeding up transactional performance, and doing both without requiring changes in applications.

[Want more on SAP's in-memory option? Read 6 SAP Hana Customers Share Early Lessons. ]

Most in-memory databases "begin and end" with speeding analytical queries, Ellison said, without naming names. "We wanted to do that, but not compromise transaction processing."

Describing Oracle's architectural approach at length, Ellison said the in-memory option sticks with Oracle Database's longstanding row data approach to ensure support for "all" existing applications without changes. The in-memory option adds a columnar analytical store cached in RAM and duplicated on at least two nodes for redundancy. Ellison said the columnar store typically speeds analytical queries by 100 times and as much as 1,000 times.

Oracle CEO Larry Ellison discusses the 12c in-memory option expected to be released in July.
Oracle CEO Larry Ellison discusses the 12c in-memory option expected to be released in July.

How can the database store data two different ways and still be faster, Ellison asked rhetorically. "We speed everything by dropping analytical indexes," he explained. "The transactions run faster because there are fewer indexes to update, and the column store does not have to be logged."

There are many nuances to be explored in just how indexes can be dropped without changing existing applications, but those questions did not come up during a brief question and answer session. Ellison also explained at one point that customers "simply choose the tables and partitions they want held in memory," to which a Twitter tweet asked, "What happens if a query joins tables in-memory and tables on disk?"

Stressing transactional performance, Ellison also highlighted availability and recovery features and asserted that other in-memory systems "just stop" when systems run out of memory -- another example of a non-specific accusation designed to sow seeds of fear, uncertainty, and doubt in the minds of customers considering other in-memory options.

Oracle 12c in-memory is not designed to handle all data in-memory, only active data, Ellison said, so it will be much more efficient and affordable than systems designed to run entirely in memory. On this score, Ellison was clearly leveling the charge at SAP Hana, though again he didn't name names.

Oracle is delivering 12c sooner than expected, and it's promising a lot without the pain of changing applications or migrating data, says Ellison. More than a dozen testimonials from customers including Yahoo, Land O Lakes, Thales Raytheon Systems, Mitsubishi, NetSuite, and others backed up the performance claims.

Our follow-up coverage will dig into the details to explore whether there are compromises Ellison didn't discuss.

IBM, Microsoft, Oracle, and SAP are fighting to become your in-memory technology provider. Do you really need the speed? Get the digital In-Memory Databases issue of InformationWeek today.

Doug Henschen is Executive Editor of InformationWeek, where he covers the intersection of enterprise applications with information management, business intelligence, big data and analytics. He previously served as editor in chief of Intelligent Enterprise, editor in chief of ... View Full Bio

Comment  | 
Print  | 
More Insights
The Agile Archive
The Agile Archive
When it comes to managing data, donít look at backup and archiving systems as burdens and cost centers. A well-designed archive can enhance data protection and restores, ease search and e-discovery efforts, and save money by intelligently moving data from expensive primary storage systems.
Register for InformationWeek Newsletters
White Papers
Current Issue
InformationWeek Tech Digest - August 20, 2014
CIOs need people who know the ins and outs of cloud software stacks and security, and, most of all, can break through cultural resistance.
Flash Poll
Video
Slideshows
Twitter Feed
InformationWeek Radio
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.