Big Data. Big Decisions
InformationWeek
Special Coverage Series

Commentary

Doug Henschen

Doug Henschen

Executive Editor, InformationWeek

Oracle Spotlights Its Database Memory Gap

Oracle takes Microsoft to task for its SQL Server Project Hekaton announcement, but in doing so it underscores what's missing from Oracle DB and Exadata.

If you attended this year's Oracle Open World event (and perhaps even if you didn't), you may have formed the impression that the combination of Oracle Database and the latest Exadata database machine, the X3, offers a formidable combo for companies looking to exploit the speed of in-memory database processing. But in a blog post published on a Forbes satellite site on Wednesday, Oracle made it clear that it has yet to deliver in-memory performance with Oracle Database.

The post by Oracle senior communications VP Bob Evans, "Oracle Calls Out Microsoft over Vaporware Fantasy," challenges Microsoft's Nov. 7 announcement of Project Hekaton. Evans, who was formerly editorial director here at InformationWeek, singled out my coverage in the article "Microsoft In-Memory Move Challenges SAP, Oracle", calling my headline "dubious" given that Hekaton won't arrive, as analysts guess, until 2014 or 2015. (Before joining Oracle, Evans held a similar corporate communications role at SAP.)

More Insights

Webcasts

More >>

White Papers

More >>

Reports

More >>

Evans' blog goes after Microsoft's claims about Hekaton and comparisons that Doug Leland, Microsoft's general manager of SQL Server marketing, made to the Oracle in-memory strategy. In doing so, however, Evans underscores the fact that Oracle, too, has yet to deliver an in-memory strategy tied to its flagship database.

Quoting Oracle database executive Andy Mendelsohn, the piece points out that Oracle's in-memory database is TimesTen, which runs inside the Exalytics appliance (along with an in-memory version of the Essbase database). That box is a sort of analytics turbocharger, and it's plugged into yet another box, Exadata, which runs on Oracle Database. But here was Evans, protesting that Microsoft was disingenuous in suggesting that Oracle is "forcing customers to buy, learn, and manage a separate solution."

[ Here's the article that sparked the discussion. Read Microsoft In-Memory Move Challenges SAP, Oracle. ]

If Oracle Database had in-memory capabilities, you wouldn't need a separate Exalytics box. But Mendelsohn acknowledges that Oracle Database is limited to "some in-memory database features." He doesn't say how or when, but Mendelsohn promises that Oracle "plans to continue to enhance Oracle Database in-memory capabilities."

So on Microsoft's side it's true we have only a beta product and fuzzy delivery date, but on Oracle's side we have a "yeah, we're going to do that, too" promise by one executive. Will the in-memory capabilities planned for Oracle Database handle transactional apps (as Hekaton promises) while Exalytics continues to handle the analytic needs? Mendelsohn didn't say. If the Oracle DB ends up handling both tasks (as SAP Hana can), will the time Exalytics buyers have invested in learning TimesTen and the in-memory version of Essbase have been unnecessary? That's unknown at this point.

The thing is, all these particulars about Oracle's in-memory plans only undermine the gauzy impression Larry Ellison tried to create at Oracle Open World around Exadata X3 as a memory powerhouse. Having finally admitted that the world is turning to memory and away from disks -- something SAP has been saying for three years -- Ellison had all the zeal of a reformed smoker, talking up the "26 terabytes of memory" available in X3. But don't mistake memory for "in-memory." In fact, the vast majority of that capacity (22 TB) is flash, not RAM, and there is a big difference.

"Flash is not memory, and I disagree with Larry Ellison on that totally," Gartner analyst Don Feinberg told InformationWeek last week. "Exadata doesn't give you an in-memory database, it gives you a disk block cache."

The practical difference is that Exadata cache is not as fast as Hana or what Hekaton promises. Until Oracle delivers full in-memory capability as part of Oracle Database, you give up the potential for real-time performance. Nevertheless, as I quoted Feinberg saying last week, "cache is still fast, and for most clients of Exadata, it's going to be fast enough."

So where does that leave Oracle customers? If you want in-memory analytical performance, you'll have to buy the separate Exalytics appliance. If you want in-memory transactional performance, you're out of luck, but Exadata might do.

As for the competition, SAP just announced SAP CRM running on Hana, and Microsoft just announced Hekaton, its plan for in-memory transactional processing. Microsoft previously delivered in-memory data exploration with Microsoft PowerPivot, introduced in 2010, and in-memory data visualization with Power View, introduced in April.

Hekaton will run transactional applications, so you will be able to take a Microsoft SQL Server application and run it in memory without changes. "That's not something you can do with an Oracle application today," said Feinberg.

Oracle has confirmed, by way of Evans' blog, that the company plans to do more with in-memory capabilities within Oracle Database. But we don't know what it will do or when it will do it. With Microsoft we don't have a release date, but at least we have a roadmap.



Related Reading




Currently we allow the following HTML tags in comments:

Single tags

These tags can be used alone and don't need an ending tag.

<br> Defines a single line break

<hr> Defines a horizontal line

Matching tags

These require an ending tag - e.g. <i>italic text</i>

<a> Defines an anchor

<b> Defines bold text

<big> Defines big text

<blockquote> Defines a long quotation

<caption> Defines a table caption

<cite> Defines a citation

<code> Defines computer code text

<em> Defines emphasized text

<fieldset> Defines a border around elements in a form

<h1> This is heading 1

<h2> This is heading 2

<h3> This is heading 3

<h4> This is heading 4

<h5> This is heading 5

<h6> This is heading 6

<i> Defines italic text

<p> Defines a paragraph

<pre> Defines preformatted text

<q> Defines a short quotation

<samp> Defines sample computer code text

<small> Defines small text

<span> Defines a section in a document

<s> Defines strikethrough text

<strike> Defines strikethrough text

<strong> Defines strong text

<sub> Defines subscripted text

<sup> Defines superscripted text

<u> Defines underlined text

BYTE encourages readers to engage in spirited, healthy debate, including taking us to task. However, BYTE moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing/SPAM. BYTE further reserves the right to disable the profile of any commenter participating in said activities.

Disqus Tips To upload an avatar photo, first complete your Disqus profile. | View the list of supported HTML tags you can use to style comments. | Please read our commenting policy.

Follow InformationWeek

By The Numbers

What Are Your Primary Concerns About Using Big Data Software?

Base: 417 respondents at organizations using or planning to deploy data analytics, BI or statistical analysis software
Data: InformationWeek 2013 Analytics, Business Intelligence and Information Management Survey of 541 business technology professionals, October 2012

What Do You Think?

What's your attitude about SQL analysis on top of Hadoop?
We want fast, standard SQL analysis capabilities on Hadoop ASAP
Hadoop is for unstructured data; SQL is for relational databases
We'll give SQL on Hadoop a try, but relational DBs will remain the mainstay
Given strong SQL support on Hadoop, we'd nix the data warehouse
We're not interested in Hadoop
No opinion



Related Content

From Our Sponsor

Five Big Data Challenges and How to Overcome Them with Visual Analytics

Five Big Data Challenges and How to Overcome Them with Visual Analytics

Business leaders often need a visual snapshot of data to quickly grasp and use it. This paper identifies five challenges in presenting data and how visual analytics can resolve them. Solutions are suggested to overcome the challenges of: speed, data clarity, data quality, displaying meaningful results, and dealing with outliers.

Game-Changing Analytics: How IT Executives Can Use Analytics to Create Innovation and Business Success

Game-Changing Analytics: How IT Executives Can Use Analytics to Create Innovation and Business Success

Today's competitive advantage requires a deeper understanding of your business, your market and your customers. As an IT executive, you can drive that knowledge transformation. In this white paper, learn how to make decisions as a strategic business leader and three steps to begin an analytics initiative within your enterprise.

Data Visualization Techniques: From Basics to Big Data with SAS Visual Analytics

Data Visualization Techniques: From Basics to Big Data with SAS Visual Analytics

High-performance data visualization turns sophisticated analyses into meaningful graphics, leading to faster and smarter decision making. In this white paper, learn how visual analytics can transform big data, with additional features such as real-time functionality, mobile compatibility, robust applications for technical groups and accessibility for nontechnical users.

Big Data: Lessons from the Leaders

Big Data: Lessons from the Leaders

Financial performance, competitive advantage, operational efficiency, strategic decision making - every business goal can extract value from big data, and the time for doubt or inaction has long passed. In this Economist Intelligence Unit report, in-depth interviews with data pioneers reveal the link between the effective use of big data and the bottom line among other results.

Decision-Driven Data Management: A Strategy for Better Decisions with Better Data

Decision-Driven Data Management: A Strategy for Better Decisions with Better Data

Which came first, the data or the decision? This white paper makes the case for having a decision in mind, then tailoring big data's volume, variety and velocity to achieve business results such as overcoming customer dissatisfaction or creating well-informed strategies in real time.

Informationweek Reports

Research: The Big Data Management Challenge

Research: The Big Data Management Challenge

The challenge of big data is real, but most organizations don't differentiate 'big data' from traditional data, and nearly 90% of respondents to our survey use conventional databases as the primary means of handling data. We'll help you understand what constitutes big data (it's not just size) and the numerous management challenges it poses.