Skip to Content

New Publication: Efficient transaction processing in SAP HANA database: the end of a column store myth

A new Publication about SAP HANA is out, you can find it here:

http://www.informatik.uni-trier.de/~ley/db/conf/sigmod/sigmod2012.html#SikkaFLCPB12

Abstract

The SAP HANA database is the core of SAP’s new data management platform. The overall goal of the SAP HANA database is to provide a generic but powerful system for different query scenarios, both transactional and analytical, on the same data representation within a highly scalable execution environment. Within this paper, we highlight the main features that differentiate the SAP HANA database from classical relational database engines. Therefore, we outline the general architecture and design criteria of the SAP HANA in a first step. In a second step, we challenge the common belief that column store data structures are only superior in analytical workloads and not well suited for transactional workloads. We outline the concept of record life cycle management to use different storage formats for the different stages of a record. We not only discuss the general concept but also dive into some of the details of how to efficiently propagate records through their life cycle and moving database entries from write-optimized to read-optimized storage formats. In summary, the paper aims at illustrating how the SAP HANA database is able to efficiently work in analytical as well as transactional workload environments.

If you’re interested in other publications of our team, have a look at our list

1 Comment
You must be Logged on to comment or reply to a post.
  • The reason why I believe SAP-HANA is NOT hype is because of SAP's openness in revealing how it works inside. SAP-HANA is not a black box. I just downloaded the article, will read and contact you with any questions.

    Best regards,

    Bala