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 50 of 72 citing papers.

Rank Citing Paper Year Venue Pagerank
87 Hekaton: SQL Server’s Memory-Optimized OLTP Engine 2013 SIGMOD 0.00052844656
336 Data-Oriented Transaction Execution 2010 VLDB 0.00027008897
632 Staring into the Abyss: An Evaluation of Concurrency Control with One Thousand Cores 2015 VLDB 0.00018895506
679 Skew-Aware Automatic Database Partitioning in Shared-Nothing, Parallel OLTP Systems 2012 SIGMOD 0.00018211621
692 Analyzing the Energy Efficiency of a Database Server 2010 SIGMOD 0.00018045529
729 Umbra: A Disk-Based System with In-Memory Performance 2020 CIDR 0.00017448059
756 FOEDUS: OLTP Engine for a Thousand Cores and NVRAM 2015 SIGMOD 0.00017079523
940 Let’s Talk About Storage & Recovery Methods for Non-Volatile Memory Database Systems 2015 SIGMOD 0.00015149366
980 Anti-Caching: A New Approach to Database Management System Architecture 2013 VLDB 0.00014868633
1,036 ERMIA: Fast Memory-Optimized Database System for Heterogeneous Workloads 2016 SIGMOD 0.00014515226
1,086 Low Overhead Concurrency Control for Partitioned Main Memory Databases 2010 SIGMOD 0.00014159702
1,105 FlashLogging: Exploiting Flash Devices for Synchronous Logging Performance 2009 SIGMOD 0.00013980159
1,130 Unbundling Transaction Services in the Cloud 2009 CIDR 0.00013767385
1,217 Rethinking serializable multiversion concurrency control 2015 VLDB 0.00013228757
1,300 Reducing the Storage Overhead of Main-Memory OLTP Databases with Hybrid Indexes 2016 SIGMOD 0.00012711153
1,369 Aether: A Scalable Approach to Logging 2010 VLDB 0.0001235533
1,483 Improving OLTP Scalability using Speculative Lock Inheritance 2009 VLDB 0.00011713238
1,594 PLP: Page Latch-free Shared-everything OLTP 2011 VLDB 0.00011212541
1,649 Managing Non-Volatile Memory in Database Systems 2018 SIGMOD 0.00011006201
1,772 LLAMA: A Cache/Storage Subsystem for Modern Hardware 2013 VLDB 0.00010603139
1,827 Lightweight Locking for Main Memory Database Systems 2013 VLDB 0.00010389522
2,075 Trekking Through Siberia: Managing Cold Data in a Memory-Optimized Database 2014 VLDB 9.6115775e-05
2,309 On Predictive Modeling for Optimizing Transaction Execution in Parallel OLTP Systems 2012 VLDB 9.0630462e-05
2,437 OLTP on Hardware Islands 2012 VLDB 8.8206221e-05
2,483 Energy Efficiency: The New Holy Grail of Data Management Systems Research 2009 CIDR 8.6765914e-05
2,505 HyPer-sonic Combined Transaction AND Query Processing 2011 VLDB 8.6299194e-05
2,634 REWIND: Recovery Write-Ahead System for In-Memory Non-Volatile Data-Structures 2015 VLDB 8.4091408e-05
2,806 Low-Overhead Asynchronous Checkpointing in Main-Memory Database Systems 2016 SIGMOD 8.1011309e-05
2,926 Design Principles for Scaling Multi-core OLTP Under High Contention 2016 SIGMOD 7.8868401e-05
2,940 Squall: Fine-Grained Live Reconfiguration for Partitioned Main Memory Databases 2015 SIGMOD 7.8508808e-05
2,976 In-Memory Performance for Big Data 2015 VLDB 7.7865451e-05
3,109 High-Throughput Transaction Executions on Graphics Processors 2011 VLDB 7.5516962e-05
3,387 Analytics in Motion: High Performance Event-Processing AND Real-Time Analytics in the Same Database 2015 SIGMOD 7.1505623e-05
3,416 An Evaluation of the Advantages and Disadvantages of Deterministic Database Systems 2014 VLDB 7.1162306e-05
3,487 Building High Throughput Permissioned Blockchain Fabrics: Challenges and Opportunities 2020 VLDB 7.0466499e-05
3,630 To Lock, Swap, or Elide: On the Interplay of Hardware Transactional Memory and Lock-Free Indexing 2015 VLDB 6.8989362e-05
3,747 BCC: Reducing False Aborts in Optimistic Concurrency Control with Low Cost for In-Memory Databases 2016 VLDB 6.7883562e-05
3,784 Adaptive Logging: Optimizing Logging and Recovery Costs in Distributed In-memory Databases 2016 SIGMOD 6.7664522e-05
4,057 Scaling Multicore Databases via Constrained Parallel Execution 2016 SIGMOD 6.4889756e-05
4,447 MorphoSys: Automatic Physical Design Metamorphosis for Distributed Database Systems 2020 VLDB 6.1745324e-05
4,458 Latch-Free Data Structures for DBMS: Design, Implementation, and Evaluation 2013 SIGMOD 6.1617961e-05
4,523 ScaleStore: A Fast and Cost-Efficient Storage Engine using DRAM, NVMe, and RDMA 2022 SIGMOD 6.1102901e-05
4,597 Scalable Replay-Based Replication For Fast Databases 2017 VLDB 6.0539632e-05
4,816 Spitfire: A Three-Tier Buffer Manager for Volatile and Non-Volatile Memory 2021 SIGMOD 5.897817e-05
4,845 Graph Analytics Through Fine-Grained Parallelism 2016 SIGMOD 5.8731048e-05
5,175 Data Management in Non-Volatile Memory 2015 SIGMOD 5.6391661e-05
5,273 Micro-architectural Analysis of In-memory OLTP 2016 SIGMOD 5.5919449e-05
5,362 Rethinking Logging, Checkpoints, and Recovery for High-Performance Storage Engines 2020 SIGMOD 5.5474601e-05
5,433 Enabling Low Tail Latency on Multicore Key-Value Stores 2020 VLDB 5.5086304e-05
5,518 A Top-Down Approach to Achieving Performance Predictability in Database Systems 2017 SIGMOD 5.468383e-05
Previous Page 1 / 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