Page As You Go: Piecewise Columnar Access In SAP HANA

Summary: Page loadable columns: use contiguous in-memory pages instead of full columns to ease memory pressure under vectorized workloads. Introduces a new persistency layout and access methods for encoded vectors, order-preserving dictionaries, and inverted indexes; integrated in SAP HANA with experiments on overhead and cold-data use. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 5250
Venue: SIGMOD
Year: 2016
Pagerank: 6.0417538e-05
Overall Rank: 5,921 | 59.38%
DOI: 10.1145/2882903.2903729

Incoming Non-self Citations Over Time

Authors

1. Reza Sherkat (Systems, Applications, and Products in Data Processing Societas Europaea)
2. Colin Florendo (Systems, Applications, and Products in Data Processing Societas Europaea)
3. Mihnea Andrei (Systems, Applications, and Products in Data Processing Societas Europaea)
4. Anil K. Goel (Systems, Applications, and Products in Data Processing Societas Europaea)
5. Anisoara Nica (Systems, Applications, and Products in Data Processing Societas Europaea)
6. Peter Bumbulis (Systems, Applications, and Products in Data Processing Societas Europaea)
7. Ivan Schreter (Systems, Applications, and Products in Data Processing Societas Europaea)
8. Günter Radestock (Systems, Applications, and Products in Data Processing Societas Europaea)
9. Christian Bensberg (Systems, Applications, and Products in Data Processing Societas Europaea)
10. Daniel Booss (Systems, Applications, and Products in Data Processing Societas Europaea)
11. Heiko Gerwens (Systems, Applications, and Products in Data Processing Societas Europaea)

BibTeX Citation

@inproceedings{sherkat_sigmod16,
        title = {{Page As You Go: Piecewise Columnar Access In SAP HANA}},
        author = {Sherkat, Reza and Florendo, Colin and Andrei, Mihnea and Goel, Anil K. and Nica, Anisoara and Bumbulis, Peter and Schreter, Ivan and Radestock, Günter and Bensberg, Christian and Booss, Daniel and Gerwens, Heiko},
        series = {{SIGMOD} '16},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/2882903.2903729},
        url = {https://dl.acm.org/doi/10.1145/2882903.2903729},
        year = {2016}
}

Incoming Citations (Sorted by Pagerank)

Showing 5 of 5 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
3,367	Native Store Extension for SAP HANA	2019	VLDB	7.4718829e-05
6,907	Statisticum: Data Statistics Management in SAP HANA	2017	VLDB	5.7417459e-05
8,579	Cost Modelling for Optimal Data Placement in Heterogeneous Main Memory	2022	VLDB	5.4087323e-05
9,745	In-Memory for the Masses: Enabling Cost-Efficient Deployments of In-Memory Data Management Platforms for Business Applications	2019	VLDB	5.227679e-05
11,768	Workload-Aware Column Imprints	2020	SIGMOD	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 14 of 14 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
12	C-Store: A Column-oriented DBMS	2005	VLDB	0.00069513174
165	DB2 with BLU Acceleration: So Much More than Just a Column Store	2013	VLDB	0.00027693424
186	The Vertica Analytic Database: C-Store 7 Years Later	2012	VLDB	0.00026182534
216	SIMD-Scan: Ultra Fast in-Memory Table Scan using on-Chip Vector Processing Units	2009	VLDB	0.00024498128
575	Efficient Transaction Processing in SAP HANA Database – The End of a Column Store Myth	2012	SIGMOD	0.00016257033
720	Anti-Caching: A New Approach to Database Management System Architecture	2013	VLDB	0.00014632914
870	BitWeaving: Fast Scans for Main Memory Data Processing	2013	SIGMOD	0.0001350293
1,524	Trekking Through Siberia: Managing Cold Data in a Memory-Optimized Database	2014	VLDB	0.00010501517
1,679	Self-organizing Tuple Reconstruction in Column-stores	2009	SIGMOD	0.00010029136
1,761	ByteSlice: Pushing the Envelop of Main Memory Data Processing with a New Storage Layout	2015	SIGMOD	9.8154969e-05
2,267	In-Memory Performance for Big Data	2015	VLDB	8.8388928e-05
2,951	Instant Recovery for Main-Memory Databases	2015	CIDR	7.9260674e-05
3,292	Compacting Transactional Data in Hybrid OLTP&OLAP Databases	2012	VLDB	7.5518441e-05
3,902	The Impact of Columnar In-Memory Databases on Enterprise Systems: Implications of Eliminating Transaction-Maintained Aggregates	2014	VLDB	7.0313122e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	10,997	The HANA Native Query Engine for Lakehouse Systems	2025	VLDB
2	8,579	Cost Modelling for Optimal Data Placement in Heterogeneous Main Memory	2022	VLDB
3	9,007	Experimental Evaluation of Optimizing Memory Consumption in SAP HANA Using PEOopt	2025	SIGMOD
4	7,235	An Examination of CXL Memory Use Cases for In-Memory Database Management Systems using SAP HANA	2024	VLDB
5	12,178	Multi-dimensional Data Statistics for Columnar In-Memory Databases	2014	SIGMOD
6	13,655	Storing and Processing Temporal Data in a Main Memory Column Store	2013	VLDB
7	4,133	SAP HANA Adoption of Non-Volatile Memory	2017	VLDB
8	8,452	A Storage Advisor for Hybrid-Store Databases	2012	VLDB
9	3,367	Native Store Extension for SAP HANA	2019	VLDB
10	575	Efficient Transaction Processing in SAP HANA Database – The End of a Column Store Myth	2012	SIGMOD