Efficient Transaction Processing in SAP HANA Database – The End of a Column Store Myth
Summary: Unified in-memory architecture enabling OLTP/OLAP on a single data representation, SAP HANA challenges the column-store-only myth for transactions. It employs record life-cycle management to move entries between write- and read-optimized formats, optimizing both workloads. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Vishal Sikka (SAP)
- 2. Franz Färber (SAP)
- 3. Wolfgang Lehner (SAP)
- 4. Sang Kyun Cha (SAP)
- 5. Thomas Peh (SAP)
- 6. Christof Bornhövd (SAP)
BibTeX Citation
@inproceedings{sikka_sigmod12,
title = {{Efficient Transaction Processing in SAP HANA Database – The End of a Column Store Myth}},
author = {Sikka, Vishal and Färber, Franz and Lehner, Wolfgang and Cha, Sang Kyun and Peh, Thomas and Bornhövd, Christof},
series = {{SIGMOD} '12},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/2213836.2213946},
url = {https://dl.acm.org/doi/10.1145/2213836.2213946},
year = {2012}
}Incoming Citations (Sorted by Pagerank)
Showing 4 of 54 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 11,015 | Freely Moving Between the OLTP and OLAP Worlds: Hermes – an High-Performance OLAP Accelerator for MySQL | 2025 | VLDB | 5.093636e-05 |
| 11,418 | Efficient Approximation Framework for Attribute Recommendation | 2023 | SIGMOD | 5.093636e-05 |
| 11,819 | Towards Multi-way Join Aware Optimizer in SAP HANA | 2020 | VLDB | 5.093636e-05 |
| 12,117 | Purity: Building Fast, Highly-Available Enterprise Flash Storage from Commodity Components | 2015 | SIGMOD | 5.093636e-05 |
Outgoing Citations (Sorted by Pagerank)
Showing 6 of 6 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 68 | The End of an Architectural Era (It’s Time for a Complete Rewrite) | 2007 | VLDB | 0.00038446206 |
| 216 | SIMD-Scan: Ultra Fast in-Memory Table Scan using on-Chip Vector Processing Units | 2009 | VLDB | 0.00024498128 |
| 966 | A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database | 2009 | SIGMOD | 0.00012920281 |
| 3,658 | P*TIME: Highly Scalable OLTP DBMS for Managing Update-Intensive Stream Workload | 2004 | VLDB | 7.2184172e-05 |
| 5,855 | Bridging Two Worlds with RICE: Integrating R into the SAP In-Memory Computing Engine | 2011 | VLDB | 6.064726e-05 |
| 6,017 | Data Mining with the SAP NetWeaver BI Accelerator | 2006 | VLDB | 6.0061791e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 2,583 | Towards Scalable Real-time Analytics: An Architecture for Scale-out of OLxP Workloads | 2015 | VLDB |
| 2 | 10,997 | The HANA Native Query Engine for Lakehouse Systems | 2025 | VLDB |
| 3 | 4,133 | SAP HANA Adoption of Non-Volatile Memory | 2017 | VLDB |
| 4 | 9,350 | Enterprise Application-Database Co-Innovation for Hybrid Transactional/Analytical Processing: A Virtual Data Model and Its Query Optimization Needs | 2025 | SIGMOD |
| 5 | 5,921 | Page As You Go: Piecewise Columnar Access In SAP HANA | 2016 | SIGMOD |
| 6 | 5,991 | Iterative Query Processing based on Unified Optimization Techniques | 2019 | SIGMOD |
| 7 | 13,655 | Storing and Processing Temporal Data in a Main Memory Column Store | 2013 | VLDB |
| 8 | 9,772 | SAP HANA Cloud: Data Management for Modern Enterprise Applications | 2025 | SIGMOD |
| 9 | 3,873 | SAP HANA: The Evolution from a Modern Main-Memory Data Platform to an Enterprise Application Platform | 2013 | VLDB |
| 10 | 8,452 | A Storage Advisor for Hybrid-Store Databases | 2012 | VLDB |