- Titel
- Efficient Transaction Processing in SAP HANA Database
- Untertitel
- The End of a Column Store Myth
- Zitierfähige Url:
- https://nbn-resolving.org/urn:nbn:de:bsz:14-qucosa2-803685
- Konferenz
- SIGMOD/PODS '12: International Conference on Management of Data. Scottsdale, 20. -24. Mai 2012
- Quellenangabe
- SIGMOD '12: Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data
Herausgeber: K. Selçuk Candan
Herausgeber: Yi Chen
Erscheinungsort: New York
Verlag: ACM
Erscheinungsjahr: 2012
Seiten: 731-742
ISBN: 978-1-4503-1247-9 - Erstveröffentlichung
- 2012
- Abstract (EN)
- 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.
- Andere Ausgabe
- Link zum Artikel, der zuerst in der ACM Digital Library erschienen ist.
DOI: 10.1145/2213836.2213946 - Freie Schlagwörter (DE)
- SAP HANA, Spaltenspeicher, Transaktionsverarbeitung
- Freie Schlagwörter (EN)
- SAP HANA, Column store, Transaction processing
- Klassifikation (DDC)
- 004
- Verlag
- ACM, New York
- Version / Begutachtungsstatus
- angenommene Version / Postprint / Autorenversion
- URN Qucosa
- urn:nbn:de:bsz:14-qucosa2-803685
- Veröffentlichungsdatum Qucosa
- 11.08.2022
- Dokumenttyp
- Konferenzbeitrag
- Sprache des Dokumentes
- Englisch
- Lizenz / Rechtehinweis
