Experimental Evaluation of Optimizing Memory Consumption in SAP HANA Using PEOopt

Summary: PEOopt: optimize Pipeline Execution Order to cut memory from intermediates in SAP HANA by shrinking pipeline-breaker lifetimes. Experiments show 36% memory reduction with negligible runtime on long queries under high intra-pipeline parallelism. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 7100
Venue: SIGMOD
Year: 2025
Pagerank: 4.4374415e-05
Overall Rank: 8,845 | 38.47%
DOI: 10.1145/3722212.3724437

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 1 of 1 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
9,186	Enterprise Application-Database Co-Innovation for Hybrid Transactional/Analytical Processing: A Virtual Data Model and Its Query Optimization Needs	2025	SIGMOD	4.3791424e-05

Outgoing Citations (Sorted by Pagerank)

Showing 15 of 15 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
418	Morsel-Driven Parallelism: A NUMA-Aware Query Evaluation Framework for the Many-Core Age	2014	SIGMOD	0.00023729211
940	SharedDB: Killing One Thousand Queries With One Stone	2012	VLDB	0.00015173166
1,016	Memory-Efficient Hash Joins	2015	VLDB	0.00014638492
1,136	Chain: Operator Scheduling for Memory Minimization in Data Stream Systems	2003	SIGMOD	0.00013760154
1,497	Accelerating Relational Databases by Leveraging Remote Memory and RDMA	2016	SIGMOD	0.00011685781
3,124	Parallel Query Scheduling and Optimization with Time- and Space-Shared Resources	1997	VLDB	7.5201555e-05
3,905	Native Store Extension for SAP HANA	2019	VLDB	6.6408563e-05
6,543	On the Complexity of Generating Optimal Plans with Cross Products (extended abstract)	1997	PODS	5.0208799e-05
7,335	MorphStore: Analytical Query Engine with a Holistic Compression-Enabled Processing Model	2020	VLDB	4.7603723e-05
7,546	Is Perfect Hashing Practical for OLAP Systems?	2024	CIDR	4.7148429e-05
8,798	Resource-Adaptive Query Execution with Paged Memory Management	2025	CIDR	4.4489415e-05
8,855	A Design Space Exploration and Evaluation for Main-Memory Hash Joins in Storage Class Memory	2023	VLDB	4.4348906e-05
9,186	Enterprise Application-Database Co-Innovation for Hybrid Transactional/Analytical Processing: A Virtual Data Model and Its Query Optimization Needs	2025	SIGMOD	4.3791424e-05
9,464	Memory Efficient Scheduling of Query Pipeline Execution	2022	CIDR	4.3355852e-05
10,415	SAP HANA Cloud: Data Management for Modern Enterprise Applications	2025	SIGMOD	4.1945683e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
6,245	Iterative Query Processing based on Unified Optimization Techniques	2019	SIGMOD	5.1391202e-05
6,777	Revisiting Reuse in Main Memory Database Systems	2017	SIGMOD	4.9288776e-05
6,304	Elastic Pipelining in an In-Memory Database Cluster	2016	SIGMOD	5.1210182e-05
11,152	Pipeline Group Optimization on Disaggregated Systems	2023	CIDR	4.1945683e-05
8,482	Cost Modelling for Optimal Data Placement in Heterogeneous Main Memory	2022	VLDB	4.5010191e-05
8,122	Comprehensive and Interactive Temporal Query Processing with SAP HANA	2013	VLDB	4.5805587e-05
5,881	Page As You Go: Piecewise Columnar Access In SAP HANA	2016	SIGMOD	5.2895336e-05
7,408	An Examination of CXL Memory Use Cases for In-Memory Database Management Systems using SAP HANA	2024	VLDB	4.7371479e-05
6,114	Database Processing-in-Memory: An Experimental Study	2020	VLDB	5.204248e-05
9,464	Memory Efficient Scheduling of Query Pipeline Execution	2022	CIDR	4.3355852e-05