Oracle In-Memory 12c Arrives In July - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Software // Information Management
04:12 PM
Connect Directly

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

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
InformationWeek Is Getting an Upgrade!

Find out more about our plans to improve the look, functionality, and performance of the InformationWeek site in the coming months.

IT Leadership: 10 Ways to Unleash Enterprise Innovation
Lisa Morgan, Freelance Writer,  6/8/2021
Preparing for the Upcoming Quantum Computing Revolution
John Edwards, Technology Journalist & Author,  6/3/2021
How SolarWinds Changed Cybersecurity Leadership's Priorities
Jessica Davis, Senior Editor, Enterprise Apps,  5/26/2021
White Papers
Register for InformationWeek Newsletters
Current Issue
Planning Your Digital Transformation Roadmap
Download this report to learn about the latest technologies and best practices or ensuring a successful transition from outdated business transformation tactics.
Flash Poll