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
4109
Venue
SIGMOD
Year
2008
Pagerank
0.0002863588
Overall Rank
157 | 98.93%
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,356 Code generation for efficient query processing in managed runtimes 2014 VLDB 6.2498397e-05
6,498 LeanStore: A High-Performance Storage Engine for NVMe SSDs 2024 VLDB 5.861854e-05
7,184 Memory-Optimized Multi-Version Concurrency Control for Disk-Based Database Systems 2022 VLDB 5.6785094e-05
7,261 LRU-C: Parallelizing Database I/Os for Flash SSDs 2023 VLDB 5.6612613e-05
7,973 Concurrent Prefix Recovery: Performing CPR on a Database 2019 SIGMOD 5.5157734e-05
7,975 Lotus: Scalable Multi-Partition Transactions on Single-Threaded Partitioned Databases 2022 VLDB 5.515614e-05
8,231 Thread Cooperation in Multicore Architectures for Frequency Counting over Multiple Data Streams 2009 VLDB 5.4617036e-05
8,418 Starry: Multi-master Transaction Processing on Semi-leader Architecture 2023 VLDB 5.4283265e-05
8,818 Resource-Adaptive Query Execution with Paged Memory Management 2025 CIDR 5.3637177e-05
9,287 Executing Long-Running Transactions in Synchronization-Free Main Memory Database Systems 2013 CIDR 5.2913314e-05
9,990 BTrim - Hybrid In-Memory Database Architecture for Extreme Transaction Processing in VLDBs 2018 VLDB 5.1823627e-05
10,058 TiQuE: Improving the Transactional Performance of Analytical Systems for True Hybrid Workloads 2023 VLDB 5.1664022e-05
10,482 Predictive Translation: High-Performance Buffer Management Without the Trade-Offs 2026 SIGMOD 5.093636e-05
10,631 OLTP Through the Looking Glass 16 Years Later: Communication is the New Bottleneck 2025 CIDR 5.093636e-05
10,770 Moving on From Group Commit: Autonomous Commit Enables High Throughput and Low Latency on NVMe SSDs 2025 SIGMOD 5.093636e-05
10,965 Enhancing Transaction Processing through Indirection Skipping 2025 VLDB 5.093636e-05
10,993 TuskFlow: An Efficient Graph Database for Long-Running Transactions 2025 VLDB 5.093636e-05
11,012 ScaleCache: Scalable and Production-grade Buffer Management for Disk-based Database Systems 2025 VLDB 5.093636e-05
11,200 High-Performance Query Processing with NVMe Arrays: Spilling without Killing Performance 2024 SIGMOD 5.093636e-05
11,981 The Next 700 Transaction Processing Engines 2017 SIGMOD 5.093636e-05
12,063 Nitro: A Fast, Scalable In-Memory Storage Engine for NoSQL Global Secondary Index 2016 VLDB 5.093636e-05
12,290 DAX: A Widely Distributed Multi-tenant Storage Service for DBMS Hosting 2013 VLDB 5.093636e-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.00069513174
29 Database Architecture Optimized for the New Bottleneck: Memory Access 1999 VLDB 0.00052093615
45 Benchmarking Database Systems: A Systematic Approach 1983 VLDB 0.00045531113
67 Making B+-Trees Cache Conscious in Main Memory 2000 SIGMOD 0.00038461275
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
204 Cache Conscious Indexing for Decision-Support in Main Memory 1999 VLDB 0.00025342994
214 ARIES/KVL: A Key-Value Locking Method for Concurrency Control of Multiaction Transactions Operating on B-Tree Indexes 1990 VLDB 0.00024680756
219 A Study of Index Structures for Main Memory Database Management Systems 1986 VLDB 0.00024293529
260 Models for Studying Concurrency Control Performance: Alternatives and Implications 1985 SIGMOD 0.00023103999
299 Shoring Up Persistent Applications 1994 SIGMOD 0.00022084669
374 Life beyond Distributed Transactions: an Apostate's Opinion 2007 CIDR 0.00019766683
2,674 An Integrated Approach to Recovery and High Availability in an Updatable, Distributed Data Warehouse 2006 VLDB 8.2709176e-05
2,870 Database Architectures for New Hardware 2004 VLDB 8.0128645e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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