Which of the following is faster for HANA and Oracle12c?

This article is from WhichisFasterHANAorOracle12C? Reading Notes, lists the key points. It does not represent my point of view. Introduction SAP claims that HANA is the fastest database, so SAP's new ERP system S4 no longer supports a new feature of OracleOracle12c for the same table, you can switch between the row and column types. SAP wants users to think that HA

This article is from Which is Faster HANA or Oracle 12C? Reading Notes, lists the key points. It does not represent my point of view. Introduction SAP claims that HANA is the fastest database, so SAP's new ERP system S4 no longer supports a new feature of Oracle 12c for the same table, you can switch between the row and column types. SAP wants users to think that HA

This article is from Which is Faster HANA or Oracle 12C? Reading Notes, lists the key points. It does not represent my point of view.

Introduction

SAP claims that HANA is the fastest database, so SAP's new ERP system S4 no longer supports Oracle

A new feature of Oracle 12c is that it can be converted between the row and column types for the same table.

SAP wants users to think of HANA as a unique technology. However, in this article, we can see that memory computing and columnar storage are not unique to SAP.

Hardware speed and database design Obfuscation

HANA obfuscated two different concepts:
1. on the hardware layer, HANA needs to load data to the memory.
2. At the database design level, HANA is a column-based database.

This obfuscation has actually been used in sap erp and has been used successfully. SAP believes that SAP's ERP can better integrate applications, and the risk of integration is lower.

Sap erp integration is at the horizontal application level, while HANA is at the vertical level until the database layer

One reason why SAP wants users to migrate data to HANA is that, unlike storing the database as data, SAP has stored the application logic in the database.

PS. However, I think these interfaces will be open to other databases.

Real HANA opportunities

I once thought that the real opportunity for HANA is to put ERP and other SAP applications on HANA, and then the analysis engine can run on the same hardware, so integration and conversion are no longer needed.

But what should I do for non-SAP applications? They cannot run on HANA. Do they need to be integrated?

In addition, HANA is very expensive, and currently HANA supports a small number of SAP applications.

What is the fastest database in the West?

The author is quite humorous.

HANA is clearly the champion of speed, as SAP said. One important reason or weakness is that HANA is a column-based database, which is an incorrect Design for non-analyticdb. Although SAP claims to be, from the computer science perspective, it is not. (SAP has a paper dedicated to the performance of columnar databases)

The insert, delete, and update operations on the transaction system are slower than the row-based database.

Debate on speed

Oracle's John Soat article in Forbes counterattacked HANA's speed. One important thing is that HANA has not released transaction processing performance indicators. Maybe it's done, but it's not good enough.

Oracle 12c dual-mode data

Oracle 12c can store data in both row-and column-based memory. This is an important advantage. In addition to pure analysis, Oracle's flexible design outweighs HANA in terms of performance.
SAP believes that Oracle's memory technology is not mature, and HANA has 7000 users, but most users do not actually use HANA.

Conclusion

The emergence of memory columnar storage in Oracle 12c makes SAP unable to fully justify migrating users to HANA.

SAP, as the application vendor, is now pushing the data layer to users. What is the result.

The following section is actually my favorite:

At Mountain View's computer history museum, an exhibition said that software was previously bound to hardware, and software was not an industry at that time. IBM released programs only run on IBM hardware. Software is not only charged, but there is no competition at the software level.

The software industry we know now is actually the requirement of US enforcing anti-trust legislation for exclusive software and hardware vendors after software and hardware decoupling. HANA, coupled with databases, is controlled by a vendor, bringing us back to the initial software era.
PS. Oracle Exadata is also a combination of software and hardware, but Oracle does not require the database to run only on Exadata

The conclusion is:
* It is wrong that only columnar databases have a future.
* Only SAP can develop high-performance databases, such as HANA.