Which is Faster HANA or Oracle 12C?

What This Article Covers

  • Does SAP Have the Advantage it Says it Does Against All Other Databases?
  • A Recipe for Confusion: The Commingling of Hardware Speed and Database Design
  • The Real Opportunity with SAP HANA vs Oracle?
  • The Fastest Database in the West?
  • The Greate Speed Debate Between SAP HANA vs Oracle
  • The Issue of Transparency on Database Speed Testing
  • Is Oracle Monkeying with S/4 Certification?
  • SAP’s Conflicts of Interest in Certifying Oracle 12c
  • Mode Switching in Oracle 12c
  • How the Capabilities of Oracle 12c Change the Conversation on SAP HANA
  • How Much Do You Know About HANA?
  • Our Work on HANA

Oracle or HANA?

Introduction

SAP has promoted HANA has run far faster than any alternative database and this principally means HANA vs Oracle. This has been the logic that it has used for why SAP would not port new applications, like S/4 (SAP’s new ERP system) to Oracle. This contention has few independent parties even investigating this issue.

A Recipe for Confusion on HANA vs Oracle: The Commingling of Hardware Speed and Database Design

One of the confusing aspects of HANA vs Oracle is that two different topics are commingled and communicated as if they are one topic.

  • One is the hardware issue, as SAP HANA requires moving the active database into memory.
  • A second aspect is the database design, which is the column based database.

SAP discusses these two topics as if they are the same subject.

One could say that SAP has done a poor job of explaining the distinction. I don’t think SAP is trying to be clear in this area and is primarily hoping customers are confused.

  • The less clear SAP’s customers are on where the potential benefits are coming from, the more the advantage swings to SAP when it comes to negotiating.
  • The more ability it has to market SAP HANA vs Oracle as a differentiated offering.
  • The more it can position SAP HANA as worthy of a serious price premium.

Something which goes undiscussed by SAP is how SAP HANA is both a technology strategy and a targeted strategy to push Oracle out of SAP accounts. Broken an extension of a strategy that SAP has used to great effect for decades, but with a slight twist. SAP kept other applications out of its customers by using the ERP system as a queen on the chessboard.

Queen

By declaring that all other SAP applications would integrate better with the queen, SAP’s customers could have lower risk implementations.

This strategy has been enormously successful, even after most vendors have come very close to SAP’s integration with their adapters.

One-Time horizontal competition — i.e. competition at the application layer. HANA is a twist on this block out strategy but takes it The software, or to the database layer. This is why SAP is so strongly positioning HANA vs Oracle. It is essentially preventing Oracle from competing with S/4 by not certifying Oracle’s database.

Hasso has stated that customers must use HANA for S/4. A primary reason for this is that SAP has migrated application logic into the database, hence breaking database portability in exchange for better performance.

The Real Opportunity with HANA?

It has been proposed to me that the real chance with HANA is for the company to place ERP, and all other SAP applications on HANA. Then the analytics engine can sit right on the same hardware. And now no integration or transformation is necessary, and now analytics reports right off of the application tables.

Cognitive

However, wait one second. I know that is feeling mighty big in its britches after over five years of breathless conferences about the brave new world of analytics, and the new Big Data obsession. However, are we now going to transform all of the hardware to be optimized for analytics?

  • Also, what about non-SAP applications? They won’t sit on HANA, so they do have to be integrated and transformed.
  • Will SAP now make the argument that those applications are legacy because they don’t sit on the “strategic platform” for the company?

Secondly, using HANA is expensive. Hasso has routinely argued that SAP HANA is not expensive. Typically Hasso will use the example of compression that is available in column based databases to reduce the footprint. If you talk to SAP account executives, they will tell you that SAP HANA is expensive. Furthermore, they will inform you that HANA is very hard to position for this reason, once the price tag comes back, the customer balks.

It is a simple thing for Hasso to propose in interviews how SAP HANA could in some hypothetical sense be not too expensive. But all other sources point to HANA being quite expensive. And you will not be buying HANA from Hasso but a SAP account executive. Hasso’s accuracy lately has been off, and I don’t see analysts or the traditional IT media outlets recording this inaccuracy or commenting upon it. I have performed a detailed analysis of Hasso’s statements on HANA.

For example, Hasso proposed that companies are needed to move to S/4 Simple Finance (now just S/4 Finance). As I outlined in the article Getting Clear on S/4 HANA Terminology, SAP has missed its release date on the rest of the ERP suite, and its actual release date is unknown. Purchasing S/4 Finance, what is now a stranded application would have been a bad move.

After years of S/4 hype, S/4 can’t be realistically purchased (unless you count an immature stand alone S/4 Finance as “realistic”) even if companies wanted to. 

The Fastest Database in the West?

There is evidence building that HANA is not the speed champion that SAP says that it is. One of the primary performance weaknesses of HANA is very rarely addressed. HANA as a column based database is not the correct database design for non-analytic applications. SAP has said that it is, but this is from the computer science perspective, not true. Although SAP obscures the fact that HANA cannot be 100% column oriented in design.

As I pointed out in the article Where HANA Gets it’s Speed, for inserts, deletes or updates — which what a transactions processing system does all the time, the column based table is slower than the row based.

Row-oriented databases are what is known as the relational database, but which is a row based database.

The Great Speed Debate

John Soat is a writer that works for Oracle, and like Hasso is not an independent source on this topic. However, John’s article in Forbes makes some good points on the topic of HANA vs Oracle. One that stuck out was SAP’s demurring on releasing HANA performance benchmarks for transaction processing.

“..SAP has not published a single benchmark result for any of its transaction processing applications running on HANA. Why Not?”

And I would say it is quite obvious why not. And that is for transaction processing systems like ERP systems these benchmarks won’t be particularly fast.

Vinnie Mirchandani, who is an independent source of the SAP HANA/Oracle 12C debate, in his book SAP Nation 2.0 reinforces John Soat’s point on benchmarks.

“It has not helped matters that SAP has been opaque about HANA benchmarks. For two decades, its SD benchmark, which measures SAP customer order lines processed in its Sales and Distribution (SD) module, has been the gold standard for measuring new hardware and software infrastructure. It has not released those metrics using a HANA database.”

Is it possible that SAP performed the benchmarking but it was poor, so it simply stopped reporting the result?

John Appleby, the Global Head of HANA at Bluefin Consulting and a well known HANA advocate has this to say about the topic — which is also documented in SAP Nation 2.0.

“The answer for the SAP Business Suite is simple right now: you have to scale-up. This advice might change in the future, but even an 8-socket 6TB system will fit 95% of SAP customers, and the biggest Business Suite installations in the world can fit in a SGI 32-socket with 24TB — and that is before considering Simple Finance or Data Aging, both of which decrease memory footprint dramatically.”

I can’t tell if this is in direct response to the lack of transparency on transaction benchmarks, but if it is, it is an inadequate response. In fact, it looks to me that John Appleby is changing the topic in his answer.

The question is related to a performance of a transaction processing system on HANA vs Oracle, and John Appleby quickly moves to a discussion of how much companies should only buy more hardware and not worry about it. What is John Appleby talking about here? He states that “for the SAP Business Suite.” and then goes on to declare the answer for this suite. Well, the only part of the SAP Business Suite that is ready for HANA is S/4 Finance. There is lots of debate as to how implementable S/4 Finance is. Secondly, the rest of the suite, now called SAP HANA Enterprise Management, as I stated, is not available for purchase. John Appleby is phrasing his response in what should be the future tense as if it is the present tense.

Is it, in fact, critical to scale up for something that does not yet exist?

Is Oracle Monkeying with the S/4 Certification?

John Soat also points out that while Oracle performed very well on one particular benchmark, but SAP will not certify the result as SAP states that Oracle manipulated the test.

Now I was not at the trial, so I am in no position to say what Oracle did or did not do. Oracle has their story, and SAP has theirs. John Soat has a good explanation of each side’s position in his article.

Also Stephan Kholer, an Oracle performance database consultant had the following to say on this topic.

SAP already answered why they do not accept the benchmark results (you also find this in the mentioned article – Copy & Pase: “Oracle manipulated its BW-EML benchmark by using a custom setup involving database functions known as triggers and materialized views that can lead to hard-to-spot data inconsistencies and aren’t supported in real-world production environments.”). The reason was the use of triggers and materialized views, which are supposed to be not supported. However if SAP would have checked their own SAPnotes – you can see that it is clearly supported and also used in SAP ECO Space. SAPnote #105047: “Materialized Views – Use permitted. For more information, see SAP Note 741478.” SAPnote #105047: “Trigger – Use permitted as part of the SAP standard system (for example, BW trigger /BI0/05* in accordance with SAP Note 449891, incremental conversion ICNV). Use of Logon Trigger permitted in accordance with SAP Note 712777. Implicit use as part of Oracle features permitted (for example, online reorganisation, materialized views, GridControl/Enterprise Manager). Use in connection with materialized views in an SAP BW system is permitted as long as no flat cubes are available as an alternative. There is no SAP Integration and SAP does not offer support for this.” Flat cubes are available in Beta since Q1/2016 – so nothing relevant to the Oracle benchmark from 2015.

And this leads into the next topic, and it is a big one.

SAP’s Conflict of Interest in Certifying Oracle 12c

The issue that SAP now completes with all of the hardware vendors places SAP in a conflict of interest when certifying databases, this is a conflict of interest that before its investment into HANA it did not have. What was once a straightforward process is now rife with political intrigue where one now has to parse the statements by SAP and Oracle to see who is telling the truth.

How can SAP certify Oracle, that is give them a fair hearing, if, by certifying Oracle, SAP cut’s into their market share for HANA?

The Mode Switching of Oracle 12c

Oracle 12c can switch between “modes” displaying either in memory rows or memory columns. That is a serious advantage. 

  • Oracle’s flexible design should beat SAP HANA in performance for all but pure analytic applications. 
  • The logic presented by SAP that the entire database should be columnar never made sense because few tables are used in analytics. Therefore does it make sense to use analytics-optimized tables (the columnar design) for every single application table?
  • There is a debate as to how mature Oracle’s in-memory database is. SAP lists 7,000 SAP HANA customers, however, most of these customers are known to either not use the software at all (i.e. it is shelf-ware) or to be test systems, not live systems. As a consequence, SAP HANA skills are still quite hard to find.

Conclusion

With Oracle 12c, Oracle 12c can switch between row based and column based tables and switch for the same table, which is a new capability.

As far as I can tell, just about all of the SAP marketing documentation on HANA has preceded this development. If I were heading up HANA marketing at SAP, I would not want to address Oracle 12c, because I would not have a good answer for it. This is because Oracle 12c undermines lots of effort expended on the part of SAP to get SAP customers to think that SAP HANA technology is unique to SAP to position SAP HANA as unique and better.

The new capabilities of Oracle 12c undermine some SAP contentions that have been proposed over the years. SAP has not addressed Oracle 12c, and most of the material created on SAP HANA was developed before Oracle 12c was released.

First, SAP now does not have a good reason — or should I say a good idea if it puts its customer’s interests first, to only port new SAP applications (like S/4) to SAP HANA.

The previous argument that only SAP could provide a fast enough database is most likely untrue. It was always a poor argument because regardless of the reason. No application vendor should be dictating the data layer to its customers. However, repeatedly that is what SAP has said that it wants to do.

“SAP still believes in running the new system in the cloud and on premise, but it will be only SAP S/4HANA with which we can achieve this in one software version going forward. This will reduce the TCO and speed up the so much needed step into the future. Every single application area like data entry, standard reporting, analytics and predictions, the digital boardroom or the multi-channel customer interaction, to name a few, becomes a world class component  in its own right. This alone is a reason to consider an earlier migration to SAP S/4HANA.” – Hasso Plattner

At the Computer History Museum in Mountain View, there is an exhibit that explains that at one time the software was proprietary to the hardware vendor. At that point software was not an “industry,” and a program released by IBM could only run on IBM hardware. The software was not charged for separately, so there was no competition at the software level.

The software industry we know it today only came into its own after it was decoupled from the hardware. And this was only done by the threat of the US enforcing anti-trust legislation against the proprietary software model and hardware vendors. HANA as a coupling between the applications and database layer — controlled by a single vendor, takes us back in time. This creates what amounts to a proprietary application/database combination.

  • SAP’s argument that only column based databases have a future is also untrue.
  • Finally, unsurprisingly to those who know the database vendors and their history, the idea that only SAP can develop a high-performance database that meets the speed capabilities of HANA is untrue.

SAP’s argument has not been that they are simply the equal of every other database vendor. With HANA they are superior to every other database vendor. That, of course, includes HANA vs Oracle or anyone else for that matter.

SAP certainly can and will keep selling HANA. But the exclusivity argument that SAP has been proposing is no longer a possible position to believe.

How Much Do You Know About HANA?

SAP HANA Quiz

This quiz will ask basic questions around SAP HANA.

Our Work on HANA

We are the most prominent research entity that tells the real story HANA. Both Forrester and Gartner take money from SAP, and Forrester created a false research report on how HANA reduces TCO in return for money. SAP then exaggerated the results of even the corrupted report by Forrester to say things that Forrester never said.

Companies like IBM, Deloitte, and Accenture have mindlessly repeated all of the SAP marketing talking points on HANA and have encouraged their customers to only accept HANA so they can get the implementation business.

Are you a company interested the actual performance benefit from HANA?

Do you need pricing and accurate database sizing for HANA for costing purposes?

Are you interested in accessing unbiased and deep research on HANA for your company?

For more information fill out the form at the end of this page.

References

http://www.forbes.com/sites/oracle/2015/12/18/oracle-challenges-sap-on-in-memory-database-claims/

http://www.amazon.com/SAP-Nation-2-0-empire-disarray-ebook/dp/B013F5BKJQ

https://en.wikipedia.org/wiki/Proprietary_software

 

 

Leave a Reply 0 comments