Micro-architectural Analysis of In-memory OLTP

Summary: In-memory vs disk-based OLTP: micro-architecture is stall-dominated, with L1 instruction misses and LL cache misses driving most runtime. Aggressive compilation reduces instruction stalls but shifts bottlenecks to LL cache misses, IPC near one on modern CPUs. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 5169
Venue: SIGMOD
Year: 2016
Pagerank: 6.4720641e-05
Overall Rank: 4,866 | 66.62%
DOI: 10.1145/2882903.2882916

Incoming Non-self Citations Over Time

Authors

1. Utku Sirin (EPFL)
2. Pinar Tözün (IBM)
3. Danica Porobic (EPFL)
4. Anastasia Ailamaki (EPFL; RAW Labs)

BibTeX Citation

@inproceedings{sirin_sigmod16,
        title = {{Micro-architectural Analysis of In-memory OLTP}},
        author = {Sirin, Utku and Tözün, Pinar and Porobic, Danica and Ailamaki, Anastasia},
        series = {{SIGMOD} '16},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/2882903.2882916},
        url = {https://dl.acm.org/doi/10.1145/2882903.2882916},
        year = {2016}
}

Incoming Citations (Sorted by Pagerank)

Showing 10 of 10 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
649	Everything You Always Wanted to Know About Compiled and Vectorized Queries But Were Afraid to Ask	2018	VLDB	0.00015320656
3,205	On Optimizing Operator Fusion Plans for Large-Scale Machine Learning in SystemML	2018	VLDB	7.6386536e-05
3,644	CoroBase: Coroutine-Oriented Main-Memory Database Engine	2021	VLDB	7.2306862e-05
4,440	The Art of Latency Hiding in Modern Database Engines	2024	VLDB	6.7049797e-05
4,626	In-Network Support for Transaction Triaging	2021	VLDB	6.5985783e-05
4,861	CXL and the Return of Scale-Up Database Engines	2024	VLDB	6.4747307e-05
4,888	Enabling Low Tail Latency on Multicore Key-Value Stores	2020	VLDB	6.4609843e-05
7,991	Micro-architectural Analysis of OLAP: Limitations and Opportunities	2020	VLDB	5.5107319e-05
8,494	POLAR: Adaptive and Non-invasive Join Order Selection via Plans of Least Resistance	2024	VLDB	5.4142129e-05
11,981	The Next 700 Transaction Processing Engines	2017	SIGMOD	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 8 of 8 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
23	Efficiently Compiling Efficient Query Plans for Modern Hardware	2011	VLDB	0.00054886415
38	Hekaton: SQL Server’s Memory-Optimized OLTP Engine	2013	SIGMOD	0.00047648573
68	The End of an Architectural Era (It’s Time for a Complete Rewrite)	2007	VLDB	0.00038446206
109	DBMSs On A Modern Processor: Where Does Time Go?	1999	VLDB	0.000331207
157	OLTP Through the Looking Glass, and What We Found There	2008	SIGMOD	0.0002863588
256	Data-Oriented Transaction Execution	2010	VLDB	0.00023172982
473	Staring into the Abyss: An Evaluation of Concurrency Control with One Thousand Cores	2015	VLDB	0.00017900942
2,679	Database Servers on Chip Multiprocessors: Limitations and Opportunities	2007	CIDR	8.2675008e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	29	Database Architecture Optimized for the New Bottleneck: Memory Access	1999	VLDB
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,292	Compacting Transactional Data in Hybrid OLTP&OLAP Databases	2012	VLDB
4	720	Anti-Caching: A New Approach to Database Management System Architecture	2013	VLDB
5	3,860	Analyzing the Impact of System Architecture on the Scalability of OLTP Engines for High-Contention Workloads	2018	VLDB
6	1,964	OLTP on Hardware Islands	2012	VLDB
7	3,837	Database Buffer Size Investigation for OLTP Workloads	1997	SIGMOD
8	157	OLTP Through the Looking Glass, and What We Found There	2008	SIGMOD
9	13,405	Micro-architectural Analysis of OLAP Systems on Persistent Memory	2022	CIDR
10	7,991	Micro-architectural Analysis of OLAP: Limitations and Opportunities	2020	VLDB