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.00012745575
Overall Rank: 975 | 93.45%
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.00018400856
575	Efficient Transaction Processing in SAP HANA Database – The End of a Column Store Myth	2012	SIGMOD	0.00016134406
1,200	Bridging the Archipelago between Row-Stores and Column-Stores for Hybrid Workloads	2016	SIGMOD	0.00011559584
1,242	BatchDB: Efficient Isolated Execution of Hybrid OLTP+OLAP Workloads for Interactive Applications	2017	SIGMOD	0.00011378275
1,332	Fast Updates on Read-Optimized Databases Using Multi-Core CPUs	2012	VLDB	0.00010993664
1,857	PALM: Parallel Architecture-Friendly Latch-Free Modifications to B+ Trees on Many-Core Processors	2011	VLDB	9.4935317e-05
2,180	Combining User Interaction, Speculative Query Execution and Sampling in the DICE System	2014	VLDB	8.9111325e-05
2,499	Towards Scalable Real-time Analytics: An Architecture for Scale-out of OLxP Workloads	2015	VLDB	8.3795899e-05
2,630	Hybrid Garbage Collection for Multi-Version Concurrency Control in SAP HANA	2016	SIGMOD	8.2008903e-05
2,814	HyPer-sonic Combined Transaction AND Query Processing	2011	VLDB	7.9767718e-05
2,880	Optimal Column Layout for Hybrid Workloads	2019	VLDB	7.9118308e-05
2,922	Parallel Replication across Formats in SAP HANA for Scaling Out Mixed OLTP/OLAP Workloads	2017	VLDB	7.8496897e-05
3,972	The Impact of Columnar In-Memory Databases on Enterprise Systems: Implications of Eliminating Transaction-Maintained Aggregates	2014	VLDB	6.8864862e-05
4,072	SharkDB: An In-Memory Storage System for Massive Trajectory Data	2015	SIGMOD	6.8181285e-05
4,155	LeCo: Lightweight Compression via Learning Serial Correlations	2024	SIGMOD	6.7730383e-05
4,692	Columnstore and B+ tree – Are Hybrid Physical Designs Important?	2018	SIGMOD	6.4656516e-05
6,189	QE3D: Interactive Visualization and Exploration of Complex, Distributed Query Plans	2015	SIGMOD	5.8553412e-05
6,560	Replication at the Speed of Change - a Fast, Scalable Replication Solution for Near Real-Time HTAP Processing	2020	VLDB	5.747061e-05
7,325	An Examination of CXL Memory Use Cases for In-Memory Database Management Systems using SAP HANA	2024	VLDB	5.5508106e-05
8,234	Operational Analytics Data Management Systems	2016	VLDB	5.3712067e-05
8,612	A Storage Advisor for Hybrid-Store Databases	2012	VLDB	5.3017701e-05
9,538	Enterprise Application-Database Co-Innovation for Hybrid Transactional/Analytical Processing: A Virtual Data Model and Its Query Optimization Needs	2025	SIGMOD	5.1631227e-05
9,932	In-Memory for the Masses: Enabling Cost-Efficient Deployments of In-Memory Data Management Platforms for Business Applications	2019	VLDB	5.1079647e-05
11,141	RedTAO: A Trillion-edge High-throughput Graph Store	2025	SIGMOD	4.9769913e-05
12,613	Interactive Performance Monitoring of a Composite OLTP and OLAP Workload	2012	SIGMOD	4.9769913e-05
12,761	Efficient Skyline Evaluation over Partially Ordered Domains	2010	VLDB	4.9769913e-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.0006897844
19	A Critique of ANSI SQL Isolation Levels	1995	SIGMOD	0.00058759613
27	Database Architecture Optimized for the New Bottleneck: Memory Access	1999	VLDB	0.00051576613
61	Integrating Compression and Execution in Column-Oriented Database Systems	2006	SIGMOD	0.00039236924
114	A Decomposition Storage Model	1985	SIGMOD	0.00031916625
611	"One Size Fits All" Database Architectures Do Not Work For DSS	1995	SIGMOD	0.00015572934
1,499	Multi-Tenant Databases for Software as a Service: Schema-Mapping Techniques	2008	SIGMOD	0.00010467167

Semantically Similar Papers

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