Last Updated on April 12, 2021 by HostingandOther
- SAP proposes that HANA has advantages in performance versus all other databases with a database that runs 100,000 times faster than any other.
- We cover if HANA is really faster than Oracle.
Lack of Financial Bias Notice: The vast majority of content available on the Internet about SAP is marketing fiddle-faddle published by SAP, SAP partners, or media entities paid by SAP to run their marketing on the media website. Each one of these entities tries to hide its financial bias from readers. The article below is very different.
- First, it is published by a research entity.
- Second, no one paid for this article to be written, and it is not pretending to inform you while being rigged to sell you software or consulting services. Unlike nearly every other article you will find from Google on this topic, it has had no input from any company's marketing or sales department.
Video Introduction: How HANA Compares to Oracle
Text Introduction (Skip if You Watched the Video)
HANA is a constant source of discussion on SAP projects. The claims by SAP are enormous, but how many are true. 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). We cover SAP’s conflict of interest in not certifying Oracle 12c for S/4HANA.You will learn about the debate, and the truth on HANA vs. Oracle from an independent source and the multiple dimensions claimed by SAP.
Our References for This Article
If you want to see our references for this article and related Brightwork articles, see this link.
*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 February 2020, and it is applicable several years later.
The History of HANA
SAP has promoted HANA and has run far faster than any alternative database, which principally means HANA vs. Oracle.
This has been the logic 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 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 severe 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 affect decades significantly, 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 they competed against.
The Result of the “Take the Queen” Sales Strategy
This strategy has been enormously successful, even after most vendors have come close to SAP’s integration with their adapters. Only the ERP system is “fully integrated.” All of the modules run off the same database, all other SAP applications are connected through adapters, and many SAP acquired applications have worse adapters than non-SAP applications.
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 prevents 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.
As soon as Oracle resources want to cry foul, remember that Oracle also restricts databases that are certified for its applications even more so than SAP.
Code Pushdown and Stored Procedures
SAP’s main argument 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 because 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 know if they are true and usually don’t care. They make statements to increase billing hours.
Finally, the general database knowledge inside SAP and the consulting firms of SAP consulting firms is relatively poor. At Brightwork, we ignore what SAP resources say about HANA because it never matches the data points we receive from SAP customers. We have extensively researched the private benchmarking information that we have access to or the evidence and history around HANA performance.
The Real Opportunity with HANA vs. Oracle?
It has been proposed 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.
SAP’s Idea of All Data Sitting on HANA
After over five years of breathless conferences about the brave new world of analytics, and the latest Big Data and overall analysts obsession (which has lead to far fewer benefits than initially proposed), SAP has proposed this will be all made better by having all company data sitting on HANA. How convenient. 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 argue that those applications are legacy because they don’t sit on the “strategic platform” for the company?
Secondly, using HANA is expensive. This is a topic we cover in the article How to Understand the Pricing of HANA and S/4HANA. HANA is quite a bit more expensive than Oracle, which is already very expensive. It falls into the exorbitant category 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 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 relatively 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 passes off his honorary Ph.D. as a real Ph.D., as I covered in the article Does SAP’s Hasso Plattner Have a Ph.D.?
- Hasso has routinely lied about HANA’s origins, as I covered in the article Did Hasso Plattner and His Ph.D. Students Invent HANA?, and is overall an unreliable source of information on both computing topics and SAP. (what works, what doesn’t, what is real, what isn’t real).
- Hasso makes up “peer-reviewed” journals that support his views, as I covered in the article How Accurate Was Hasso Plattner About SAP HANA Publications?
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 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.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.
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 directly responds 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. 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. John Appleby quickly discusses 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.” He then declares the answer for this suite.
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 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
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 of memory columns. That is a serious advantage. IBM BLU has a similar ability. However, 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 databases trend 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 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 (i.e., it is shelf-ware) or 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 has 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 raises 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.
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 the right answer. This is because Oracle 12c undermines lots of effort expended on 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, focused 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, the software was not an “industry,” 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 US’s threat to enforce 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 HANA’s speed capabilities is untrue.
SAP’s argument has not been that they are equal to 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.