Which is Faster HANA or Oracle 12C?

Executive Summary

  • SAP proposes that HANA has advantages in performance versus all other databases with a database that runs 100,000 times faster than any other.
  • The confusion on HANA vs. Oracle performance due to the commingling of hardware speed and database design.
  • SAPs strategy for using HANA to lock out other database vendors (as claimed Teradata).
  • SAP’s conflict of interest in not certifying Oracle 12c for S/4HANA.

Introduction: How HANA Compares to Oracle

HANA is a constant source of discussion on SAP projects. The claims by SAP are enormous, but how many are true. You will learn about the debate and the truth on HANA vs. Oracle from an independent source and from the multiple dimensions that are claimed by SAP.

*Note: This article was originally written in April of 2016, and it refers to some articles by SAP earlier than this. However, the article has been updated as of August of 2019, and it is applicable several years later. 

The History of HANA

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. (as Oracle has the largest market share of supporting SAP applications, although SAP also is targeting IBM and SQL Server)

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.

Take the Queen: SAP’s Strategy for Locking Out Other Vendors

This is 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.

We refer to this as the “take the queen” software strategy.

By declaring that all other SAP applications would integrate better with the queen, SAP’s customers could have lower risk implementations. This ended up being false — and a primary reason for this was SAP’s applications had been far higher risk than the applications which they competed against. 

The Result of the “Take the Queen” Sales Strategy

This strategy has been enormously successful, even after most vendors have come very close to SAP’s integration with their adapters. Only the ERP system is “fully integrated” in that all of the modules run off of the same database, all other SAP applications are connected through adapters, and many SAP acquired applications have worse adapters than non-SAP applications.

The account control features of ERP systems are covered in the article ERP Systems as a Trojan Horse, and ERP Became an Out of Control Octopus.

SAP does not just sell a company an ERP system. The ERP system is just the wedge that breaks into the account. Like an octopus, SAP keeps hammering on different areas that must be made “SAP standard.” The development language used, the other applications, must also be SAP. Now SAP has pushed into the database layer. Oracle, the primary vendor that SAP is trying to push out of SAP accounts with HANA, functions the same way. 

Using Control of the Application Layer to Push into the Database Layer

One-Time horizontal competition — i.e., competition at the application layer. HANA is a twist on this block out strategy but takes it to the database layer. This is why SAP is so firmly positioning HANA vs. Oracle. It is preventing Oracle (and other databases) from competing with S/4 by not certifying Oracle’s database even though there is no reason that Oracle, IBM, and SQL Server cannot fully support S/4HANA. Further recall that none of the databases in the mix is open source — even though open source databases like PostgresSQL or MariaDB could easily support SAP. This is a battle between monopolistic high overhead and controlling software vendors.

Code Pushdown and Stored Procedures

SAP’s main arguments for why S/4HANA is restricted to HANA is that SAP has pushed some S/4HANA code into HANA, and it is not doing so for Oracle or other databases. The logic of the stored procedures placed into HANA is a cover for the fact that SAP is using S/4HANA’s exclusive certification to drive HANA sales, which we cover in the article SAP’s Arguments on Code Pushdown.

Let us be clear on this topic.

SAP does not care if performance increases for customers. SAP introduced HANA and says what it does about HANA for one reason, to increase its sales and to push Oracle out of accounts. SAP consultants at SAP consulting firms that repeat HANA talking points don’t themselves know if they are true, and also usually don’t care. They make statements to increase billing hours.

Finally, the general database knowledge inside of SAP, and inside of the consulting firms of SAP consulting firms is quite poor. At Brightwork, we don’t pay attention to what SAP resources say about HANA because it never matches the data points we receive from SAP customers. Or the private benchmarking information that we have access to or the evidence and history around HANA performance that we have extensively researched.

The Real Opportunity with HANA vs. Oracle?

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 and overall analysts obsession (which has lead to far fewer benefits than initially proposed). 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. Even more expensive than Oracle, which is already very expensive, and exorbitant if one follows Oracle’s “advice” and activates the higher-end functionality.

HANA is Not Expensive…Hasso?

Hasso Plattner has routinely argued that SAP HANA is not expensive.

Typically Hasso Plattner will use the example of compression that is available in column-based databases to reduce the footprint. Hasso has so frequently talked about compression because HANA is priced per GB, which is strange for a database as most commercial databases are priced per CPU. If Hasso or the SAP account rep can make the database sound like it will be smaller than it is, SAP can get more sales.

However, 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. We have routinely priced HANA for customers, and there is simply no getting around the fact that HANA is the most expensive database among the competing options.

We cover HANA pricing in the article How to Understand S/4HANA and HANA Pricing.

It is a simple thing for Hasso Plattner 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 an SAP account executive.

Hasso Plattner’s Constant Inaccuracy

Something essential to consider is that Hasso’s accuracy historically is quite poor, 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, and when Hasso says something, he usually is wrong.

Hasso considers himself a professor and highly technical visionary. However, his accuracy puts him close to a salesperson as we cover in the article Thomas Edison, Elizabeth Holmes, and Hasso Plattner and How Much Should Hasso Plattner Be Cut Slack for Lying?

As we cover in a few paragraphs, SAP will never allow a fair competition against Oracle or other databases, because SAP knows it will lose. SAP is both the gunfighter in this scenario and also the entity supervising the gunfight, as it is the certifying entity. SAP also has the power to block any database provider from publishing any benchmark under the partnership agreement. 

The Fastest Database in the West (HANA vs. Oracle)?

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-based or 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 transaction 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 Database 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 subject 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 apparent why not. And that is for transaction processing systems like ERP systems. These benchmarks won’t be particularly fast.

Vinnie Mirchandani, who was an independent source of the SAP HANA/Oracle 12C debate at the time of publication of SAP Nation 2.0, in his book SAP Nation 2.0reinforces 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.”

Misdirection from John Appleby

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

John Appleby, the Global Head of HANA at Bluefin Consulting and a well known HANA advocate and someone who has provided an enormous amount of false information about HANA, 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. It looks to me that John Appleby is changing the topic in his answer.

We tracked John Appleby’s accuracy and displayed the article The Appleby Accuracy Checker: A Study into John Appleby’s Accuracy on HANA. Back in 2013, Appleby was aggressively and falsely promoting HANA to get his company ready to sell to Mindtree, as we covered in the article Appleby’s False HANA Statements and the Mindtree Acquisitions.

The Appleby (Formerly Known as the Hasso) Pivot

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 (at the time of this quotation) was S/4 Finance. There is a lot of debate as to how implementable S/4 Finance was at this time.

Secondly, the rest of the suite, now called SAP HANA Enterprise Management, as I stated, was not available for purchase at this time. John Appleby is phrasing his response to 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 its story, and SAP has theirs. John Soat has a good explanation of each side’s position in his article.

Also, Stephan Kohler, 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 & Paste: “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 to the next topic, and it is a big one.

SAP’s Conflict of Interest in Not 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, a New Wrinkle in HANA vs. Oracle

Oracle 12c can switch between “modes” displaying either in memory rows or memory columns. That is a serious advantage. IBM BLU has a similar ability. Although there is not that much evidence that there is a major need for a database that does both OLTP and OLAP — and it may not be feasible to design one that does each type of database processing equally well. The trend in databases is the opposite of this, with specialized database designs such as NoSQL, indexing databases flourishing.

However, getting back to the HANA versus Oracle 12c discussion:

  • 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.

Furthermore, Oracle’s in-memory modal switch adds to the price of Oracle 12c both in license and in maintenance.

SAP’s Rigged Benchmarks

SAP has had ample opportunity to prove their claims of superiority around HANA, but have never done so. SAP has never allowed a comparative benchmark in transaction processing, as is covered in the article The Hidden Issue with the SD HANA Benchmark. And because HANA performed so poorly in the transaction process benchmark, it created a new reference that attempts to cover up this fact. But the reference they provided is designed around analytics, which is covered in the article The Four Hidden Issues with SAP’s BW-EML Benchmark. This overall topic has come to a head, as numerous companies have complained about HANA’s transaction processing performance, which brings up the question of how well HANA can support an ERP system, as is covered in the article HANA as a Mismatch for S/4HANA and ERP.

Advice on Enjoying the Quiz

To see the full screen, just select the lower right-hand corner and expand. Trust us, expanding makes the experience a whole lot more fun.

 

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 right 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. IBM and MS SQL Server have similar column store capabilities. Not because there was a big reason to develop them, but because SAP, through its enormous marketing, placed the focus on this type of database functionality.

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.

Dictating the Database to the Customers?

The previous argument that only SAP could provide a fast enough database is most likely untrue. It was always a weak 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

SAP’s Interest in Sending the IT Industry Back in Time

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 vs Oracle. But the exclusivity argument that SAP has been proposing is no longer a possible position to believe.

Financial Disclosure

Financial Bias Disclosure

Neither this article nor any other article on the Brightwork website is paid for by a software vendor, including Oracle, SAP or their competitors. As part of our commitment to publishing independent, unbiased research; no paid media placements, commissions or incentives of any nature are allowed.

Getting the Most Accurate Information on SAP

Accessing Custom SAP Research

We provide custom research into SAP, as well as fact checking of the claims of multiple options. To find out more, contact us.

References

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

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

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