A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database

Summary: Unified in-memory columnar DB for OLTP and OLAP; exploits large memory and cores, with dictionary compression and column pruning. No separate warehouse; keeps data in-memory and accessible to both workloads, enabling unified operations and analytics. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h46564cfb13bf1a18
Venue: SIGMOD
Year: 2009
Pagerank: 0.00012749922
Overall Rank: 976 | 93.44%
DOI: 10.1145/1559845.1559846

Incoming Non-self Citations Over Time

Authors

1. Hasso Plattner (Hasso Plattner Institute; University of Potsdam)

BibTeX Citation

@inproceedings{plattner_sigmod09,
        title = {{A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database}},
        author = {Plattner, Hasso},
        series = {{SIGMOD} '09},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1559845.1559846},
        url = {https://dl.acm.org/doi/10.1145/1559845.1559846},
        year = {2009}
}

Incoming Citations (Sorted by Pagerank)

Showing 26 of 26 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
431	HYRISE—A Main Memory Hybrid Storage Engine	2011	VLDB	0.00018403783
575	Efficient Transaction Processing in SAP HANA Database – The End of a Column Store Myth	2012	SIGMOD	0.00016132182
1,200	Bridging the Archipelago between Row-Stores and Column-Stores for Hybrid Workloads	2016	SIGMOD	0.00011563303
1,241	BatchDB: Efficient Isolated Execution of Hybrid OLTP+OLAP Workloads for Interactive Applications	2017	SIGMOD	0.00011378254
1,335	Fast Updates on Read-Optimized Databases Using Multi-Core CPUs	2012	VLDB	0.0001099401
1,855	PALM: Parallel Architecture-Friendly Latch-Free Modifications to B+ Trees on Many-Core Processors	2011	VLDB	9.4973014e-05
2,178	Combining User Interaction, Speculative Query Execution and Sampling in the DICE System	2014	VLDB	8.9152266e-05
2,499	Towards Scalable Real-time Analytics: An Architecture for Scale-out of OLxP Workloads	2015	VLDB	8.3815142e-05
2,632	Hybrid Garbage Collection for Multi-Version Concurrency Control in SAP HANA	2016	SIGMOD	8.1995358e-05
2,813	HyPer-sonic Combined Transaction AND Query Processing	2011	VLDB	7.9794684e-05
2,882	Optimal Column Layout for Hybrid Workloads	2019	VLDB	7.9116043e-05
2,922	Parallel Replication across Formats in SAP HANA for Scaling Out Mixed OLTP/OLAP Workloads	2017	VLDB	7.8519075e-05
3,970	The Impact of Columnar In-Memory Databases on Enterprise Systems: Implications of Eliminating Transaction-Maintained Aggregates	2014	VLDB	6.8895992e-05
4,070	SharkDB: An In-Memory Storage System for Massive Trajectory Data	2015	SIGMOD	6.8213576e-05
4,153	LeCo: Lightweight Compression via Learning Serial Correlations	2024	SIGMOD	6.776246e-05
4,690	Columnstore and B+ tree – Are Hybrid Physical Designs Important?	2018	SIGMOD	6.4687131e-05
6,186	QE3D: Interactive Visualization and Exploration of Complex, Distributed Query Plans	2015	SIGMOD	5.8581144e-05
6,558	Replication at the Speed of Change - a Fast, Scalable Replication Solution for Near Real-Time HTAP Processing	2020	VLDB	5.7497828e-05
7,321	An Examination of CXL Memory Use Cases for In-Memory Database Management Systems using SAP HANA	2024	VLDB	5.5534395e-05
8,228	Operational Analytics Data Management Systems	2016	VLDB	5.3736562e-05
8,605	A Storage Advisor for Hybrid-Store Databases	2012	VLDB	5.3042445e-05
9,529	Enterprise Application-Database Co-Innovation for Hybrid Transactional/Analytical Processing: A Virtual Data Model and Its Query Optimization Needs	2025	SIGMOD	5.165568e-05
9,925	In-Memory for the Masses: Enabling Cost-Efficient Deployments of In-Memory Data Management Platforms for Business Applications	2019	VLDB	5.1103839e-05
11,132	RedTAO: A Trillion-edge High-throughput Graph Store	2025	SIGMOD	4.9793485e-05
12,607	Interactive Performance Monitoring of a Composite OLTP and OLAP Workload	2012	SIGMOD	4.9793485e-05
12,755	Efficient Skyline Evaluation over Partially Ordered Domains	2010	VLDB	4.9793485e-05

Outgoing Citations (Sorted by Pagerank)

Showing 7 of 7 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.00068998927
19	A Critique of ANSI SQL Isolation Levels	1995	SIGMOD	0.00058781151
27	Database Architecture Optimized for the New Bottleneck: Memory Access	1999	VLDB	0.0005158963
61	Integrating Compression and Execution in Column-Oriented Database Systems	2006	SIGMOD	0.000392237
114	A Decomposition Storage Model	1985	SIGMOD	0.00031928929
611	"One Size Fits All" Database Architectures Do Not Work For DSS	1995	SIGMOD	0.00015574329
1,499	Multi-Tenant Databases for Software as a Service: Schema-Mapping Techniques	2008	SIGMOD	0.00010471977

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	11,357	No Cap, This Memory Slaps: Breaking Through the Memory Wall of Transactional Database Systems with Processing-in-Memory	2025	VLDB
2	3,137	Data Warehousing and OLAP for Decision Support	1997	SIGMOD
3	3,657	Maximizing Persistent Memory Bandwidth Utilization for OLAP Workloads	2021	SIGMOD
4	12,607	Interactive Performance Monitoring of a Composite OLTP and OLAP Workload	2012	SIGMOD
5	906	Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation	2016	SIGMOD
6	13,719	Micro-architectural Analysis of OLAP Systems on Persistent Memory	2022	CIDR
7	8,228	Operational Analytics Data Management Systems	2016	VLDB
8	8,050	Micro-architectural Analysis of OLAP: Limitations and Opportunities	2020	VLDB
9	3,970	The Impact of Columnar In-Memory Databases on Enterprise Systems: Implications of Eliminating Transaction-Maintained Aggregates	2014	VLDB
10	3,308	Compacting Transactional Data in Hybrid OLTP&OLAP Databases	2012	VLDB