Database Paper Browser

Back to papers

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
4048
Venue
SIGMOD
Year
2008
Pagerank
0.00033609709
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,680 Code generation for efficient query processing in managed runtimes 2014 VLDB 5.3759701e-05
6,838 LeanStore: A High-Performance Storage Engine for NVMe SSDs 2024 VLDB 4.906223e-05
7,325 LRU-C: Parallelizing Database I/Os for Flash SSDs 2023 VLDB 4.7564908e-05
7,424 Memory-Optimized Multi-Version Concurrency Control for Disk-Based Database Systems 2022 VLDB 4.7293034e-05
7,878 Thread Cooperation in Multicore Architectures for Frequency Counting over Multiple Data Streams 2009 VLDB 4.6257581e-05
7,989 Concurrent Prefix Recovery: Performing CPR on a Database 2019 SIGMOD 4.6088612e-05
8,131 Lotus: Scalable Multi-Partition Transactions on Single-Threaded Partitioned Databases 2022 VLDB 4.5742014e-05
8,468 STARRY: Multi-master Transaction Processing on Semi-leader Architecture 2023 VLDB 4.4994768e-05
8,795 Resource-Adaptive Query Execution with Paged Memory Management 2025 CIDR 4.4446768e-05
9,227 Executing Long-Running Transactions in Synchronization-Free Main Memory Database Systems 2013 CIDR 4.365436e-05
9,840 BTrim – Hybrid In-Memory Database Architecture for Extreme Transaction Processing in VLDBs 2018 VLDB 4.2692221e-05
9,903 TiQuE: Improving the Transactional Performance of Analytical Systems for True Hybrid Workloads 2023 VLDB 4.2539423e-05
10,193 Predictive Translation: High-Performance Buffer Management Without the Trade-Offs 2026 SIGMOD 4.1905499e-05
10,345 OLTP Through the Looking Glass 16 Years Later: Communication is the New Bottleneck 2025 CIDR 4.1905499e-05
10,503 Moving on From Group Commit: Autonomous Commit Enables High Throughput and Low Latency on NVMe SSDs 2025 SIGMOD 4.1905499e-05
10,729 Enhancing Transaction Processing through Indirection Skipping 2025 VLDB 4.1905499e-05
10,769 TuskFlow: An Efficient Graph Database for Long-Running Transactions 2025 VLDB 4.1905499e-05
10,789 ScaleCache: Scalable and Production-grade Buffer Management for Disk-based Database Systems 2025 VLDB 4.1905499e-05
10,992 High-Performance Query Processing with NVMe Arrays: Spilling without Killing Performance 2024 SIGMOD 4.1905499e-05
11,784 The Next 700 Transaction Processing Engines 2017 SIGMOD 4.1905499e-05
11,870 Nitro: A Fast, Scalable In-Memory Storage Engine for NoSQL Global Secondary Index 2016 VLDB 4.1905499e-05
12,101 DAX: A Widely Distributed Multi-tenant Storage Service for DBMS Hosting 2013 VLDB 4.1905499e-05
Previous Page 2 / 2 Next

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.0012093675
20 C-Store: A Column-oriented DBMS 2005 VLDB 0.00086163998
52 Database Architecture Optimized for the new Bottleneck: Memory Access 1999 VLDB 0.00066322421
88 The End of an Architectural Era (It's Time for a Complete Rewrite) 2007 VLDB 0.0005262025
104 Making B+-Trees Cache Conscious in Main Memory 2000 SIGMOD 0.00049475932
124 DBMSs On A Modern Processor: Where Does Time Go? 1999 VLDB 0.0004501099
175 ARIES/KVL: A Key-Value Locking Method for Concurrency Control of Multiaction Transactions Operating on B-Tree Indexes 1990 VLDB 0.00038354115
190 Models for Studying Concurrency Control Performance: Alternatives and Implications 1985 SIGMOD 0.00035797633
235 A Study of Index Structures for Main Memory Database Management Systems 1986 VLDB 0.00031980259
240 Cache Conscious Indexing for Decision-Support in Main Memory 1999 VLDB 0.00031526134
292 Shoring Up Persistent Applications 1994 SIGMOD 0.00028735468
298 Life beyond Distributed Transactions: an Apostate's Opinion 2007 CIDR 0.00028556426
2,363 An Integrated Approach to Recovery and High Availability in an Updatable, Distributed Data Warehouse 2006 VLDB 8.9594816e-05
2,582 Database Architectures for New Hardware 2004 VLDB 8.4982366e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
2,926 Design Principles for Scaling Multi-core OLTP Under High Contention 2016 SIGMOD 7.8868401e-05
136 H-Store: A High-Performance, Distributed Main Memory Transaction Processing System 2008 VLDB 0.00042409816
8,101 Micro-architectural Analysis of OLAP: Limitations and Opportunities 2020 VLDB 4.581825e-05
1,086 Low Overhead Concurrency Control for Partitioned Main Memory Databases 2010 SIGMOD 0.00014159702
1,483 Improving OLTP Scalability using Speculative Lock Inheritance 2009 VLDB 0.00011713238
10,345 OLTP Through the Looking Glass 16 Years Later: Communication is the New Bottleneck 2025 CIDR 4.1905499e-05
3,601 Database Buffer Size Investigation for OLTP Workloads 1997 SIGMOD 6.9285208e-05
11,784 The Next 700 Transaction Processing Engines 2017 SIGMOD 4.1905499e-05
2,437 OLTP on Hardware Islands 2012 VLDB 8.8206221e-05
5,273 Micro-architectural Analysis of In-memory OLTP 2016 SIGMOD 5.5919449e-05