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.00012719146
Overall Rank: 976 | 93.46%
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.00018411252
574	Efficient Transaction Processing in SAP HANA Database – The End of a Column Store Myth	2012	SIGMOD	0.00016142754
1,188	Bridging the Archipelago between Row-Stores and Column-Stores for Hybrid Workloads	2016	SIGMOD	0.00011580449
1,232	BatchDB: Efficient Isolated Execution of Hybrid OLTP+OLAP Workloads for Interactive Applications	2017	SIGMOD	0.00011406847
1,340	Fast Updates on Read-Optimized Databases Using Multi-Core CPUs	2012	VLDB	0.00010962559
1,865	PALM: Parallel Architecture-Friendly Latch-Free Modifications to B+ Trees on Many-Core Processors	2011	VLDB	9.4644494e-05
2,191	Combining User Interaction, Speculative Query Execution and Sampling in the DICE System	2014	VLDB	8.8844453e-05
2,505	Towards Scalable Real-time Analytics: An Architecture for Scale-out of OLxP Workloads	2015	VLDB	8.3555487e-05
2,636	Hybrid Garbage Collection for Multi-Version Concurrency Control in SAP HANA	2016	SIGMOD	8.176465e-05
2,812	HyPer-sonic Combined Transaction AND Query Processing	2011	VLDB	7.9566265e-05
2,891	Optimal Column Layout for Hybrid Workloads	2019	VLDB	7.887378e-05
2,895	Parallel Replication across Formats in SAP HANA for Scaling Out Mixed OLTP/OLAP Workloads	2017	VLDB	7.8856044e-05
3,986	The Impact of Columnar In-Memory Databases on Enterprise Systems: Implications of Eliminating Transaction-Maintained Aggregates	2014	VLDB	6.8646239e-05
4,093	SharkDB: An In-Memory Storage System for Massive Trajectory Data	2015	SIGMOD	6.7956344e-05
4,169	LeCo: Lightweight Compression via Learning Serial Correlations	2024	SIGMOD	6.7526687e-05
4,701	Columnstore and B+ tree – Are Hybrid Physical Designs Important?	2018	SIGMOD	6.44638e-05
6,200	QE3D: Interactive Visualization and Exploration of Complex, Distributed Query Plans	2015	SIGMOD	5.8359798e-05
6,408	Replication at the Speed of Change - a Fast, Scalable Replication Solution for Near Real-Time HTAP Processing	2020	VLDB	5.7786603e-05
7,343	An Examination of CXL Memory Use Cases for In-Memory Database Management Systems using SAP HANA	2024	VLDB	5.5324561e-05
8,250	Operational Analytics Data Management Systems	2016	VLDB	5.3539237e-05
8,630	A Storage Advisor for Hybrid-Store Databases	2012	VLDB	5.2843511e-05
9,565	Enterprise Application-Database Co-Innovation for Hybrid Transactional/Analytical Processing: A Virtual Data Model and Its Query Optimization Needs	2025	SIGMOD	5.1460502e-05
9,966	In-Memory for the Masses: Enabling Cost-Efficient Deployments of In-Memory Data Management Platforms for Business Applications	2019	VLDB	5.0910746e-05
11,200	RedTAO: A Trillion-edge High-throughput Graph Store	2025	SIGMOD	4.9605343e-05
12,656	Interactive Performance Monitoring of a Composite OLTP and OLAP Workload	2012	SIGMOD	4.9605343e-05
12,804	Efficient Skyline Evaluation over Partially Ordered Domains	2010	VLDB	4.9605343e-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.00068985264
19	A Critique of ANSI SQL Isolation Levels	1995	SIGMOD	0.00058631912
27	Database Architecture Optimized for the New Bottleneck: Memory Access	1999	VLDB	0.0005146739
61	Integrating Compression and Execution in Column-Oriented Database Systems	2006	SIGMOD	0.00039323387
114	A Decomposition Storage Model	1985	SIGMOD	0.00031854546
611	"One Size Fits All" Database Architectures Do Not Work For DSS	1995	SIGMOD	0.00015537413
1,500	Multi-Tenant Databases for Software as a Service: Schema-Mapping Techniques	2008	SIGMOD	0.00010434847

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	3,148	Data Warehousing and OLAP for Decision Support	1997	SIGMOD
2	11,417	No Cap, This Memory Slaps: Breaking Through the Memory Wall of Transactional Database Systems with Processing-in-Memory	2025	VLDB
3	3,663	Maximizing Persistent Memory Bandwidth Utilization for OLAP Workloads	2021	SIGMOD
4	12,656	Interactive Performance Monitoring of a Composite OLTP and OLAP Workload	2012	SIGMOD
5	894	Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation	2016	SIGMOD
6	13,764	Micro-architectural Analysis of OLAP Systems on Persistent Memory	2022	CIDR
7	8,250	Operational Analytics Data Management Systems	2016	VLDB
8	8,053	Micro-architectural Analysis of OLAP: Limitations and Opportunities	2020	VLDB
9	3,986	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