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: 4165
Venue: SIGMOD
Year: 2009
Pagerank: 0.00012920281
Overall Rank: 966 | 93.38%
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
428	HYRISE—A Main Memory Hybrid Storage Engine	2011	VLDB	0.00018633493
575	Efficient Transaction Processing in SAP HANA Database – The End of a Column Store Myth	2012	SIGMOD	0.00016257033
1,199	Bridging the Archipelago between Row-Stores and Column-Stores for Hybrid Workloads	2016	SIGMOD	0.00011703966
1,238	BatchDB: Efficient Isolated Execution of Hybrid OLTP+OLAP Workloads for Interactive Applications	2017	SIGMOD	0.00011543368
1,315	Fast Updates on Read-Optimized Databases Using Multi-Core CPUs	2012	VLDB	0.00011181796
1,822	PALM: Parallel Architecture-Friendly Latch-Free Modifications to B+ Trees on Many-Core Processors	2011	VLDB	9.6765747e-05
2,136	Combining User Interaction, Speculative Query Execution and Sampling in the DICE System	2014	VLDB	9.1126926e-05
2,583	Towards Scalable Real-time Analytics: An Architecture for Scale-out of OLxP Workloads	2015	VLDB	8.3849987e-05
2,836	HyPer-sonic Combined Transaction AND Query Processing	2011	VLDB	8.0716718e-05
2,866	Optimal Column Layout for Hybrid Workloads	2019	VLDB	8.0175489e-05
2,922	Parallel Replication across Formats in SAP HANA for Scaling Out Mixed OLTP/OLAP Workloads	2017	VLDB	7.9593579e-05
3,434	Hybrid Garbage Collection for Multi-Version Concurrency Control in SAP HANA	2016	SIGMOD	7.4172842e-05
3,902	The Impact of Columnar In-Memory Databases on Enterprise Systems: Implications of Eliminating Transaction-Maintained Aggregates	2014	VLDB	7.0313122e-05
4,065	LeCo: Lightweight Compression via Learning Serial Correlations	2024	SIGMOD	6.930275e-05
4,637	Columnstore and B+ tree – Are Hybrid Physical Designs Important?	2018	SIGMOD	6.592197e-05
4,806	SharkDB: An In-Memory Storage System for Massive Trajectory Data	2015	SIGMOD	6.4994869e-05
6,056	QE3D: Interactive Visualization and Exploration of Complex, Distributed Query Plans	2015	SIGMOD	5.9925637e-05
6,447	Replication at the Speed of Change - a Fast, Scalable Replication Solution for Near Real-Time HTAP Processing	2020	VLDB	5.8761879e-05
7,235	An Examination of CXL Memory Use Cases for In-Memory Database Management Systems using SAP HANA	2024	VLDB	5.6655351e-05
8,072	Operational Analytics Data Management Systems	2016	VLDB	5.4933919e-05
8,452	A Storage Advisor for Hybrid-Store Databases	2012	VLDB	5.4230061e-05
9,350	Enterprise Application-Database Co-Innovation for Hybrid Transactional/Analytical Processing: A Virtual Data Model and Its Query Optimization Needs	2025	SIGMOD	5.2841297e-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
10,698	RedTAO: A Trillion-edge High-throughput Graph Store	2025	SIGMOD	5.093636e-05
12,316	Interactive Performance Monitoring of a Composite OLTP and OLAP Workload	2012	SIGMOD	5.093636e-05
12,464	Efficient Skyline Evaluation over Partially Ordered Domains	2010	VLDB	5.093636e-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.00069513174
19	A Critique of ANSI SQL Isolation Levels	1995	SIGMOD	0.00058720861
29	Database Architecture Optimized for the New Bottleneck: Memory Access	1999	VLDB	0.00052093615
60	Integrating Compression and Execution in Column-Oriented Database Systems	2006	SIGMOD	0.0003955489
115	A Decomposition Storage Model	1985	SIGMOD	0.00032338948
608	"One Size Fits All" Database Architectures Do Not Work For DSS	1995	SIGMOD	0.00015795625
1,477	Multi-Tenant Databases for Software as a Service: Schema-Mapping Techniques	2008	SIGMOD	0.00010654969

Semantically Similar Papers

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