Which one is faster for HANA and Oracle 12c

This article comes from reading notes on which is Faster HANA or Oracle 12C, and outlines the key points. Does not represent my point of view.

Brief 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 the ability to convert between rows and columns for the same table

SAP wants users to think of Hana as a unique technology, but in this article you can see that both memory and Columnstore are not proprietary technologies of SAP

Hardware speed and database design confusion

Hana mixes two different concepts together:
1. At the hardware level, Hana needs to load the data into memory
2. At the database design level, Hana is a column-based database

This confusion in fact in SAP ERP has been used, and the use of success, SAP believes that SAP's own ERP can better integrate the application, the risk of integration less.

The integration of SAP ERP is at the level of application, and Hana is at the vertical level until the database layer

One reason why SAP wants users to migrate to Hana is that SAP has decentralized the application logic to the database, unlike previously storing the database as a data store.

PS. But I think these interfaces are open to other databases.

A real opportunity for Hana

The real opportunity for Hana was to put ERP and other SAP applications on Hana, and then the analysis engine could run on the same hardware, and integration and transformation were no longer needed.

But what about non-SAP applications that can't run on Hana and they don't need integration?

In addition, Hana is very expensive, and currently Hana supports a small subset of SAP applications

The fastest database in the West?

Look at the headline, the writer's kinda funny.

Hana is obviously not the speed champion, as SAP says. One important reason or weakness is that Hana is a column-based database, which is an incorrect design for a non-analytic database. Although SAP claims to be, it is not from a computer science point of view. (SAP has a paper that specifically describes the performance of a column database.)

For the insertion, deletion, and update of the trading system, the column database is slower than the row-type database

The debate about speed

Oracle's John Soat's article on Forbes has countered the speed of Hana, and it's important to note that Hana has not released performance metrics for transaction processing. Maybe it's done, but it's not good enough.

Oracle 12c Data Dual mode

An important advantage is that Oracle 12c can present data in memory in both row and column. In addition to pure analytical operations, Oracle's flexible design has the performance to triumph over Hana.
SAP believes Oracle's memory technology is immature, while Hana has 7,000 users, but most of the users don't really use Hana.

Conclusion

The advent of Oracle 12c in-memory columnstore makes it no longer sufficient for SAP to migrate users to Hana.

SAP as a manufacturer of applications, now the data layer to the user, the results, only to wait and see.

The following paragraph is actually what I admire most:

At the Computer History Museum in Mountain View, there was an exhibition that once software was tied to hardware, software was not an industry at the time, and IBM released programs that ran only on IBM hardware. Software not only charges, at the software level there is no competition.

What we now know about the software industry is actually after the decoupling of hardware and software, the US enforcing anti-trust legislation for proprietary software and hardware vendors. Hana, as an application and database coupling, is controlled by a single vendor, which brings us back to the earliest days of software.
PS. Oracle's Exadata is also a combination of software and hardware, but Oracle does not require that the database be run on Exadata

The conclusion is:
* The future is not the same as a column-only database.
* Only SAP can develop a high-performance database like Hana is also wrong

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced. *******************************************************************************************

SAP Hana is a newly designed in- memory database system that supports traditional row-type storage as well as Columnstore. The HANA database has high performance, concurrency, and scalability. Hana can support OLTP applications as well as OLAP systems.

As we all know, the key bottleneck that restricts the performance of database systems is I/O. To address this problem,Oracle has introduced Exadata to optimize I/O processing and transmission between the database tier and storage tiers by using intelligent storage software built into the storage tier. the SAP Hana database is a separate direction, taking advantage of the trend toward a multi-core processor architecture and a lower cost of computer memory, storing data in memory, while traditional disk storage Systems act as "persistent layers" to prevent memory loss due to failures. For Hana, the relevant data is in memory so that no physical disk I/O is required to access the data, so there is no disk "I/O" bottleneck. In this case, we don't want to discuss the pros and cons of SAP Hana and Oracle Exadata Two technologies, and I think the two technologies represent both directions and ultimately need to be judged by the market and the customer.

As the current SAP Hana Open Information is very small, personal feel very unfavorable to the promotion and use of products, a product only understand, use more people, to establish a good "ecosystem" can be developed. This is especially true for base platform software such as databases. Technicians understand and learn a product that likes to install it first and then use it. This article will show you how to install it for beginners in SAP HANA. It is important to note that the purpose of this article is to help people who intend to learn the SAP database to build their own learning environment, not for the actual production environment

*************************************************************************************************************** ******************************

• This article has been included in the following columns:
• In-memory Computing Technology

Which one is faster for HANA and Oracle 12c