Essential Guide

Guide to Oracle engineered systems and server appliances

A comprehensive collection of articles, videos and more, hand-picked by our editors

Faceoff: Oracle Exalytics, a true appliance, surpasses SAP HANA

Oracle Exalytics has backwards compatibility, innovative in-memory database features and is a true appliance, making it better than SAP HANA.

Oracle SAP FaceoffThis is one part of a faceoff between two in-memory database appliances, Oracle Exalytics and SAP HANA. In a separate column, an SAP consultant argues that SAP HANA is the better product.

So what's so good about Oracle Exalytics In-Memory Machine, compared to other vendors' in-memory analytic solutions? As an Oracle Partner and author of a book on the product that's due out shortly, of course I'm probably biased, but from my work with the product I think it's got a few key advantages over competitor products such as SAP HANA.

At this point I'll assume that most readers are familiar with the functionality provided by Oracle Exalytics, such as in-memory analytics provided by Oracle TimesTen for Exalytics and Oracle Essbase, and dashboards and analyses provided by Oracle Business Intelligence. Exalytics is an appliance that combines software with a Sun server containing 1 TB of RAM and 40 CPU cores and with hardware and software sold together in what Oracle terms an "engineered system."  If you're new to the platform and want to read a few background details, check the Rittman Mead section on Exalytics for articles and blog posts on its features and product history.

In this article, though, I'm going to talk about what makes Exalytics special and why I think Oracle's in-memory solution is better than the competition's. Note that these are my views. They are not endorsed by Oracle; they're based on my experiences since obtaining an Exalytics server at the start of 2012.

Backwards compatibility and support

Those of you with long memories may remember Oracle OLAP, the company's long-term replacement for the venerable Oracle Express multidimensional OLAP server. Oracle took a Java-centric approach with Oracle OLAP and thereby broke API compatibility with applications that worked with Oracle Express. It then took many years to come up with suitable Java-based analysis tool for Oracle OLAP. Over the intervening years, most Oracle Express customers ended up moving to competitor products such as Microsoft Analysis Services and IBM Cognos PowerPlay. They just couldn't wait for Oracle to come up with a fully-functional OLAP client that matched the functionality of their old Express-based tools.

The lesson learned for Oracle was to ensure that its new in-memory platform was compatible with all of the BI, EPM and data warehousing tools customers currently use, rather than gamble on them waiting around while it put together a completely new set of tools. Customers who adopt Exalytics can move their existing Oracle Business Intelligence and Oracle Essbase applications straight onto the Exalytics platform, including the pre-packaged Oracle BI Applications, with only a simple metadata upgrade typically being required.

A further benefit of this support for existing tools is that the full range of Oracle's BI, EPM and data discovery tools can be used on the platform, with their extensive support for Oracle and non-Oracle data sources. With BI, one size doesn't fit all, and Exalytics' support for the full range of Oracle's BI tools ensures you'll be able to use the right tool for the job, rather than the limited range supported by competitors' products. The most recent v1.1 patchset even extends Exalytics support to Oracle's new Endeca Information Discovery tool, allowing you to run analysis of unstructured data in the type of high-end analysis environment that suits it best.

Handling the in-memory scalability problem

More on Oracle Exalytics:

Read about the initial Oracle Exalytics announcement

Will in-memory database technology become a commodity?

Exalytics hardware pricing: Starts in six figures

Clearly, analyzing BI data sets in-memory is a superior approach compared to retrieving data from disk, but sooner or later you're going to hit memory limits on your workstation or server. Different vendors deal with this problem in different ways, with some requiring you to hold the entire data set for analysis in-memory, effectively limiting you to analyzing just subsets of your overall data.

Exalytics addresses this problem by storing just commonly used data in-memory, referring back to the wider data set typically held in an Oracle Exadata-based data warehouse using a low-latency InfiniBand connection. Oracle calls this in-memory data set its "in-memory adaptive data mart," with a feature called the Summary Advisor analyzing the query workload and automatically copying hotspots of data into this in-memory cache. This ages out data no longer used by queries. Taking this approach, users can query data sets much larger than the available memory on their server with a fully automated solution that requires little administration effort once it's up and running.

A true 'appliance' solution from a single vendor

Organizations that want to reduce the total cost of ownership for their IT systems are increasingly looking for "Apple iPod-style" solutions that combine hardware and software into a single, easy-to-administer package.

Oracle Exalytics is an integrated package of Sun hardware and Oracle software that's installed, patched and configured as a single system. It reduces the cost of installing and maintaining your BI platform and ensures that all of your components are guaranteed to work together even through upgrades. Exalytics even "phones home" if any part of the hardware requires servicing or replacement, and an Oracle service engineer arrives shortly afterwards who's aware of the software that's running on your server as well as the hardware. And the engineer doesn't then just leave you with a repaired server whose new hardware components aren't supported by the software that's running on it.

The other advantage to a single vendor such as Oracle providing the complete product stack from hardware through operating system and application server all the way to BI tooling is the opportunity this provides to optimize the software for a particular hardware configuration. For example, initial releases of the Oracle Business Intelligence part of the Exalytics software stack come with performance optimizations predicated on having 1 TB of RAM and 40 CPU cores. Over time, you can expect Oracle to add more "Exalytics-exclusive" features to its BI tools designed to take advantage of the high-end hardware available for Exalytics systems.

In-memory analysis is an exciting development for business intelligence users, but it's tricky to get right. Often, compromises must be made in terms of handling large data sets, reusing existing tools or creating entirely new ones. Plus, you have open platforms versus standardizing on a known hardware configuration and you have to optimize for that.

In my opinion, Oracle has taken the best approach to providing in-memory analytics for its customers by simplifying deployment and standardizing on a single, appliance-type solution. In addition, it combines in-memory with disk-based analysis to support very large data sets, and it maintains backwards compatibility with its existing BI tools so that customers can quickly gain value with this new platform.

For more details on Oracle Exalytics In-Memory Machine, check out our website, or take a look at the product on Oracle's website.

Mark Rittman, co-founder, Rittman Mead

Mark Rittman, 
Co-founder, 
Rittman Mead

ABOUT THE AUTHOR
Mark Rittman is co-founder of Rittman Mead, an Oracle Gold Partner based in the U.K. with offices in the U.S., India and Australia. Mark is an Oracle ACE director and author of the forthcoming Oracle Press books, Oracle Business Intelligence Developers Guide and Oracle Exalytics Revealed.

This was last published in September 2012

PRO+

Content

Find more PRO+ content and other member only offers, here.

Essential Guide

Guide to Oracle engineered systems and server appliances

Join the conversation

50 comments

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

Which in-memory database appliance do you think is best?
Cancel
I am an Infrastructure Administrator, and I love to study solutions to increase the performance of the administrated environment. I have worked with SAP/ORACLE since the SAP 4 and Oracle 8,9,10. I had a good contact with Oracle Business Suite too and some Olap/Cube Data Base too. I CAN say that the concepts of SAP HANA is based on a simple and easy idea: Disk Less ou Entire Memory Solution while the ExasSolutions are continuing exploring the complex technology of Disk Storages with a limited experts...
Cancel
In despite of I had written before, I need say something more: I don´t know the future of SAP Hana and I believe that this solution will increase the predective capacities of a Company or Enterprise and it will be very well to reach some business targets, but I have worked with SAP/ORACLE and I really trust in the COMBINATION of these two products specially when you think in Disaster & Recovery Solutions using Oracle Data Guard Engine to guarantee SAP ERP environments. I think that we do not have to compare SAP HANA with EXA-ORACLE Solutions because they have your own space to be implemented. I think that we must, first of all, to se the Business or where we could apply the best solutions before doing any comparisons! That´s all for now!
Cancel
For me it's clear - Exalytics is a nice toy to speed up an existing Oracle analytics database. SAP HANA revolutionises both analytics and any other business function.
Cancel
Exalytics simply doesn't stack up to the completeness of SAP HANA. Exalytics is only 'part' in memory and doesn't have the robustness of SAP HANA.
Cancel
Microsoft Access beats the sh1t out of all of you.
Cancel
Exalytics is just a database cache, it doesn't provide full suite of database functionality. HANA is a better engineered database.
Cancel
Hardware and Software dependency on one vendor is not always pleasant. Execute when needed at one place is better than moving data here and there and then execute. Turbo-charge existing database is the goal.
Cancel
HANA is far more than what Exalytics purports to cover
Cancel
Oracle's in-memory database appliance is an hardware plus software engineered and guaranteed to work together.
Cancel
work for a customer who tested HANA against Oracle 11.2 database (no in-memory). A big investment in HANA was not justified by the small gain in performance. Now it's planed to use SSDs with the Oracle DB.
Cancel
HANA is much more coherent in comparison to Exalytics
Cancel
It is adaptive unlike SAP HANA which shoves everything in memory.
Cancel
Thank you for the "unbiased" article here. As an oracle gold partner, you clearly have no incentive to favor exalytics. Your exhaustive experience with Hana also shows.
Cancel
SAP HANA
Cancel
HANA is an enabler of flexibility of deployment
Cancel
Very technical in nature and informative. Thanks to the author, but it fials to highlight strengths that would make a difference over SAP Hana.
Cancel
good article
Cancel
HANA storage layer is based flash + (SAN or NFS). Data ingestion can be an issue. Where as combination of Exalytics + Exadata can provide a seem less layers of distributed memory cache on (using 40Gbps infiniband) 22TB of flash cache and under lying storage server disks. (again using infi)
Cancel
SAP HANA supports more variety of applications such as Predictive, Planning and SAP BusinessObjects Explorer(which have search capabiltiy).
Cancel
HANA is true in-memory DB.
Cancel
Oracle Exalytics is nothing but a BI platform. On the other hand, SAP HANA is going to cover both OLTP and OLAP by in-memory DB style.
Cancel
I think Exalytics is not a in-memory database application.
Cancel
HANA must be
Cancel
SAP HANA is the best in-memory database I have ever met with!
Cancel
SAP HANA is excellent
Cancel
Exalytics is out-of-date.
Cancel
HANA is real in-memory machine
Cancel
HANA is awesome!
Cancel
HANA is real in-memory database appliance!!
Cancel
In my opinion SAP HANA is the best In Memory Machine
Cancel
Exalytics
Cancel
it is for OLAP and OLTP
Cancel
SAP HANA doesn't work. It's a dream that didn't come true. At least for SAP.
Cancel
Same
Cancel
I can't read much comparison in this article that would justifie the "surpasses" word in the title. Having a better look to Hana side would have been fair.
Cancel
hana works difference than other products
Cancel
SAP innovates, Oracle not!
Cancel
Exalytics is built on industry strength enterprise class proven software and hardware. HANA is very new, you can't downlaod it, touch it, demo it. You need an army of SAP consultants to keep it up and running,
Cancel
GOOD REVIEW
Cancel
Exalytics is not DBMS.
SAP HANA is.
Cancel
Competing Oracle Exalytics n SAP HANA will result in amazing research ....
Better outputs for the Business World of tomorrow ...
LOL n Laughter to both appliances !!
Cancel
The author forgets that multiple databases are inside the hardware which is like managing multiple elephants in EDW at one place. He seems to be only looking at benefit of software and hardware and service from one vendor. He forgets that the cost of these service is exorbitant from Oracle and this is where Oracle squeezes out its customers
Cancel
Better ROI
Cancel
SAP HANA will replace Oracle DBMS like a tidal wave
Cancel
SAP Hana is a platform for applications whereas Exalytics just helps for faster reporting. Especially since SAP's launch of Suite on Hana in January, it is clear that HANA is the foundation for running in-memory applications
Cancel
just couple of years into HANA and SAP is making you guys and CEO of Oracle over talking about it...ha..thats speed..
Cancel
Oracle should innovate further or be buried under the new tidal wave of in memory technology. SAP HANA the new definition of speed
Cancel
1 TB of RAM & 40 cores of CPU what for whilst HANA can accellerate ur scenario with just 64 GB of RAM and 8 cores thats speed
Cancel
The software and hardware are packagedand provided by a single vendor.
Cancel

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close