DBScholar

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
h82f0ecc986ea2a43
Venue
SIGMOD
Year
2008
Pagerank
0.00028244257
Overall Rank
157 | 98.95%
DOI
10.1145/1376616.1376713

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{harizopoulos_sigmod08,
        title = {{OLTP Through the Looking Glass, and What We Found There}},
        author = {Harizopoulos, Stavros and Abadi, Daniel J. and Madden, Samuel and Stonebraker, Michael},
        series = {{SIGMOD} '08},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1376616.1376713},
        url = {https://dl.acm.org/doi/10.1145/1376616.1376713},
        year = {2008}
}

Incoming Citations (Sorted by Pagerank)

Showing 22 of 72 citing papers.

Rank Citing Paper Year Venue Pagerank
5,225 LeanStore: A High-Performance Storage Engine for NVMe SSDs 2024 VLDB 6.2100105e-05
5,470 Code generation for efficient query processing in managed runtimes 2014 VLDB 6.101779e-05
6,740 Memory-Optimized Multi-Version Concurrency Control for Disk-Based Database Systems 2022 VLDB 5.6774409e-05
7,393 LRU-C: Parallelizing Database I/Os for Flash SSDs 2023 VLDB 5.5202899e-05
7,760 Lotus: Scalable Multi-Partition Transactions on Single-Threaded Partitioned Databases 2022 VLDB 5.440847e-05
8,164 Concurrent Prefix Recovery: Performing CPR on a Database 2019 SIGMOD 5.3716408e-05
8,411 Thread Cooperation in Multicore Architectures for Frequency Counting over Multiple Data Streams 2009 VLDB 5.3213581e-05
8,597 Starry: Multi-master Transaction Processing on Semi-leader Architecture 2023 VLDB 5.2926286e-05
9,014 Resource-Adaptive Query Execution with Paged Memory Management 2025 CIDR 5.2235585e-05
9,388 ScaleCache: Scalable and Production-grade Buffer Management for Disk-based Database Systems 2025 VLDB 5.168439e-05
9,504 Executing Long-Running Transactions in Synchronization-Free Main Memory Database Systems 2013 CIDR 5.1531044e-05
9,830 TiQuE: Improving the Transactional Performance of Analytical Systems for True Hybrid Workloads 2023 VLDB 5.1065586e-05
9,987 OLTP Through the Looking Glass 16 Years Later: Communication is the New Bottleneck 2025 CIDR 5.0845476e-05
10,202 BTrim - Hybrid In-Memory Database Architecture for Extreme Transaction Processing in VLDBs 2018 VLDB 5.0492443e-05
10,305 TuskFlow: An Efficient Graph Database for Long-Running Transactions 2025 VLDB 5.0294306e-05
10,741 Predictive Translation: High-Performance Buffer Management Without the Trade-Offs 2026 SIGMOD 4.9605343e-05
11,258 Moving on From Group Commit: Autonomous Commit Enables High Throughput and Low Latency on NVMe SSDs 2025 SIGMOD 4.9605343e-05
11,412 Enhancing Transaction Processing through Indirection Skipping 2025 VLDB 4.9605343e-05
11,597 High-Performance Query Processing with NVMe Arrays: Spilling without Killing Performance 2024 SIGMOD 4.9605343e-05
12,328 The Next 700 Transaction Processing Engines 2017 SIGMOD 4.9605343e-05
12,405 Nitro: A Fast, Scalable In-Memory Storage Engine for NoSQL Global Secondary Index 2016 VLDB 4.9605343e-05
12,630 DAX: A Widely Distributed Multi-tenant Storage Service for DBMS Hosting 2013 VLDB 4.9605343e-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
12 C-Store: A Column-oriented DBMS 2005 VLDB 0.00068985264
27 Database Architecture Optimized for the New Bottleneck: Memory Access 1999 VLDB 0.0005146739
46 Benchmarking Database Systems: A Systematic Approach 1983 VLDB 0.00044656322
68 Making B+-Trees Cache Conscious in Main Memory 2000 SIGMOD 0.00037861537
70 The End of an Architectural Era (It’s Time for a Complete Rewrite) 2007 VLDB 0.00037761637
111 DBMSs On A Modern Processor: Where Does Time Go? 1999 VLDB 0.00032621499
209 Cache Conscious Indexing for Decision-Support in Main Memory 1999 VLDB 0.00024915373
221 ARIES/KVL: A Key-Value Locking Method for Concurrency Control of Multiaction Transactions Operating on B-Tree Indexes 1990 VLDB 0.0002420049
230 A Study of Index Structures for Main Memory Database Management Systems 1986 VLDB 0.00023845485
270 Models for Studying Concurrency Control Performance: Alternatives and Implications 1985 SIGMOD 0.00022604714
302 Shoring Up Persistent Applications 1994 SIGMOD 0.00021600053
384 Life beyond Distributed Transactions: an Apostate's Opinion 2007 CIDR 0.00019432779
2,715 An Integrated Approach to Recovery and High Availability in an Updatable, Distributed Data Warehouse 2006 VLDB 8.0838677e-05
2,928 Database Architectures for New Hardware 2004 VLDB 7.8316168e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 2,221 Design Principles for Scaling Multi-core OLTP Under High Contention 2016 SIGMOD
2 80 H-Store: A High-Performance, Distributed Main Memory Transaction Processing System 2008 VLDB
3 8,053 Micro-architectural Analysis of OLAP: Limitations and Opportunities 2020 VLDB
4 797 Low Overhead Concurrency Control for Partitioned Main Memory Databases 2010 SIGMOD
5 1,299 Improving OLTP Scalability using Speculative Lock Inheritance 2009 VLDB
6 9,987 OLTP Through the Looking Glass 16 Years Later: Communication is the New Bottleneck 2025 CIDR
7 3,872 Database Buffer Size Investigation for OLTP Workloads 1997 SIGMOD
8 12,328 The Next 700 Transaction Processing Engines 2017 SIGMOD
9 1,976 OLTP on Hardware Islands 2012 VLDB
10 4,918 Micro-architectural Analysis of In-memory OLTP 2016 SIGMOD