OLTP Through the Looking Glass, and What We Found There

Summary: Examines memory-resident OLTP by reworking Shore on a TPC-C to reveal hardware bottlenecks. Shows ~20x speedups via iterative feature removal and optimizations, revealing no single bottleneck; logging, locking, B-tree, and buffer management all matter. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 4047
Venue: SIGMOD
Year: 2008
Pagerank: 0.0003354907
Overall Rank: 215 | 98.51%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 22 of 72 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
5,667	Code generation for efficient query processing in managed runtimes	2014	VLDB	5.3806399e-05
6,840	LeanStore: A High-Performance Storage Engine for NVMe SSDs	2024	VLDB	4.9109345e-05
7,329	LRU-C: Parallelizing Database I/Os for Flash SSDs	2023	VLDB	4.7610574e-05
7,431	Memory-Optimized Multi-Version Concurrency Control for Disk-Based Database Systems	2022	VLDB	4.7316464e-05
7,880	Thread Cooperation in Multicore Architectures for Frequency Counting over Multiple Data Streams	2009	VLDB	4.6291185e-05
7,987	Concurrent Prefix Recovery: Performing CPR on a Database	2019	SIGMOD	4.6132851e-05
8,128	Lotus: Scalable Multi-Partition Transactions on Single-Threaded Partitioned Databases	2022	VLDB	4.5785914e-05
8,471	STARRY: Multi-master Transaction Processing on Semi-leader Architecture	2023	VLDB	4.5037948e-05
8,798	Resource-Adaptive Query Execution with Paged Memory Management	2025	CIDR	4.4489415e-05
9,224	Executing Long-Running Transactions in Synchronization-Free Main Memory Database Systems	2013	CIDR	4.3696239e-05
9,841	BTrim – Hybrid In-Memory Database Architecture for Extreme Transaction Processing in VLDBs	2018	VLDB	4.2732806e-05
9,904	TiQuE: Improving the Transactional Performance of Analytical Systems for True Hybrid Workloads	2023	VLDB	4.258022e-05
10,193	Predictive Translation: High-Performance Buffer Management Without the Trade-Offs	2026	SIGMOD	4.1945683e-05
10,333	OLTP Through the Looking Glass 16 Years Later: Communication is the New Bottleneck	2025	CIDR	4.1945683e-05
10,493	Moving on From Group Commit: Autonomous Commit Enables High Throughput and Low Latency on NVMe SSDs	2025	SIGMOD	4.1945683e-05
10,722	Enhancing Transaction Processing through Indirection Skipping	2025	VLDB	4.1945683e-05
10,763	TuskFlow: An Efficient Graph Database for Long-Running Transactions	2025	VLDB	4.1945683e-05
10,783	ScaleCache: Scalable and Production-grade Buffer Management for Disk-based Database Systems	2025	VLDB	4.1945683e-05
10,989	High-Performance Query Processing with NVMe Arrays: Spilling without Killing Performance	2024	SIGMOD	4.1945683e-05
11,776	The Next 700 Transaction Processing Engines	2017	SIGMOD	4.1945683e-05
11,862	Nitro: A Fast, Scalable In-Memory Storage Engine for NoSQL Global Secondary Index	2016	VLDB	4.1945683e-05
12,093	DAX: A Widely Distributed Multi-tenant Storage Service for DBMS Hosting	2013	VLDB	4.1945683e-05

Outgoing Citations (Sorted by Pagerank)

Showing 14 of 14 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
10	Benchmarking Database Systems: A Systematic Approach	1983	VLDB	0.0012103754
21	C-Store: A Column-oriented DBMS	2005	VLDB	0.00086087497
52	Database Architecture Optimized for the new Bottleneck: Memory Access	1999	VLDB	0.00066474881
86	The End of an Architectural Era (It's Time for a Complete Rewrite)	2007	VLDB	0.00052563276
103	Making B+-Trees Cache Conscious in Main Memory	2000	SIGMOD	0.00049150032
124	DBMSs On A Modern Processor: Where Does Time Go?	1999	VLDB	0.00045103515
174	ARIES/KVL: A Key-Value Locking Method for Concurrency Control of Multiaction Transactions Operating on B-Tree Indexes	1990	VLDB	0.00038347904
190	Models for Studying Concurrency Control Performance: Alternatives and Implications	1985	SIGMOD	0.0003579699
233	A Study of Index Structures for Main Memory Database Management Systems	1986	VLDB	0.00032021526
238	Cache Conscious Indexing for Decision-Support in Main Memory	1999	VLDB	0.00031642425
292	Shoring Up Persistent Applications	1994	SIGMOD	0.00028741386
298	Life beyond Distributed Transactions: an Apostate's Opinion	2007	CIDR	0.00028591413
2,354	An Integrated Approach to Recovery and High Availability in an Updatable, Distributed Data Warehouse	2006	VLDB	8.9685256e-05
2,582	Database Architectures for New Hardware	2004	VLDB	8.5007371e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
2,926	Design Principles for Scaling Multi-core OLTP Under High Contention	2016	SIGMOD	7.884983e-05
137	H-Store: A High-Performance, Distributed Main Memory Transaction Processing System	2008	VLDB	0.00042342967
8,096	Micro-architectural Analysis of OLAP: Limitations and Opportunities	2020	VLDB	4.5860565e-05
1,090	Low Overhead Concurrency Control for Partitioned Main Memory Databases	2010	SIGMOD	0.0001415654
1,485	Improving OLTP Scalability using Speculative Lock Inheritance	2009	VLDB	0.00011706232
10,333	OLTP Through the Looking Glass 16 Years Later: Communication is the New Bottleneck	2025	CIDR	4.1945683e-05
3,595	Database Buffer Size Investigation for OLTP Workloads	1997	SIGMOD	6.9373987e-05
11,776	The Next 700 Transaction Processing Engines	2017	SIGMOD	4.1945683e-05
2,445	OLTP on Hardware Islands	2012	VLDB	8.8057827e-05
5,272	Micro-architectural Analysis of In-memory OLTP	2016	SIGMOD	5.5937875e-05