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

Rank Citing Paper Year Venue Pagerank
35 Hekaton: SQL Server’s Memory-Optimized OLTP Engine 2013 SIGMOD 0.00047996489
261 Data-Oriented Transaction Execution 2010 VLDB 0.0002286084
373 Umbra: A Disk-Based System with In-Memory Performance 2020 CIDR 0.00019705706
444 Staring into the Abyss: An Evaluation of Concurrency Control with One Thousand Cores 2015 VLDB 0.0001817002
473 Skew-Aware Automatic Database Partitioning in Shared-Nothing, Parallel OLTP Systems 2012 SIGMOD 0.00017684278
542 FOEDUS: OLTP Engine for a Thousand Cores and NVRAM 2015 SIGMOD 0.00016654017
635 ERMIA: Fast Memory-Optimized Database System for Heterogeneous Workloads 2016 SIGMOD 0.00015362118
729 Anti-Caching: A New Approach to Database Management System Architecture 2013 VLDB 0.00014417679
756 Rethinking serializable multiversion concurrency control 2015 VLDB 0.00014208768
797 Low Overhead Concurrency Control for Partitioned Main Memory Databases 2010 SIGMOD 0.00013916653
864 Let’s Talk About Storage & Recovery Methods for Non-Volatile Memory Database Systems 2015 SIGMOD 0.00013388481
902 Analyzing the Energy Efficiency of a Database Server 2010 SIGMOD 0.00013178114
960 Reducing the Storage Overhead of Main-Memory OLTP Databases with Hybrid Indexes 2016 SIGMOD 0.0001283613
993 Unbundling Transaction Services in the Cloud 2009 CIDR 0.00012633413
1,025 Aether: A Scalable Approach to Logging 2010 VLDB 0.00012422375
1,124 FlashLogging: Exploiting Flash Devices for Synchronous Logging Performance 2009 SIGMOD 0.00011923526
1,283 Managing Non-Volatile Memory in Database Systems 2018 SIGMOD 0.00011205832
1,297 Improving OLTP Scalability using Speculative Lock Inheritance 2009 VLDB 0.00011125055
1,382 PLP: Page Latch-free Shared-everything OLTP 2011 VLDB 0.0001085396
1,398 LLAMA: A Cache/Storage Subsystem for Modern Hardware 2013 VLDB 0.00010778761
1,433 Lightweight Locking for Main Memory Database Systems 2013 VLDB 0.0001067528
1,524 Trekking Through Siberia: Managing Cold Data in a Memory-Optimized Database 2014 VLDB 0.0001036095
1,842 On Predictive Modeling for Optimizing Transaction Execution in Parallel OLTP Systems 2012 VLDB 9.5247433e-05
1,973 OLTP on Hardware Islands 2012 VLDB 9.2817268e-05
2,279 Design Principles for Scaling Multi-core OLTP Under High Contention 2016 SIGMOD 8.7047643e-05
2,291 In-Memory Performance for Big Data 2015 VLDB 8.6855592e-05
2,380 Low-Overhead Asynchronous Checkpointing in Main-Memory Database Systems 2016 SIGMOD 8.5466497e-05
2,402 REWIND: Recovery Write-Ahead System for In-Memory Non-Volatile Data-Structures 2015 VLDB 8.5165931e-05
2,425 Squall: Fine-Grained Live Reconfiguration for Partitioned Main Memory Databases 2015 SIGMOD 8.4820179e-05
2,727 Energy Efficiency: The New Holy Grail of Data Management Systems Research 2009 CIDR 8.0858491e-05
2,800 An Evaluation of the Advantages and Disadvantages of Deterministic Database Systems 2014 VLDB 7.988872e-05
2,814 HyPer-sonic Combined Transaction AND Query Processing 2011 VLDB 7.9767718e-05
2,889 High-Throughput Transaction Executions on Graphics Processors 2011 VLDB 7.9034864e-05
3,124 Analytics in Motion: High Performance Event-Processing AND Real-Time Analytics in the Same Database 2015 SIGMOD 7.6222513e-05
3,262 Scaling Multicore Databases via Constrained Parallel Execution 2016 SIGMOD 7.4800686e-05
3,266 BCC: Reducing False Aborts in Optimistic Concurrency Control with Low Cost for In-Memory Databases 2016 VLDB 7.4749205e-05
3,298 To Lock, Swap, or Elide: On the Interplay of Hardware Transactional Memory and Lock-Free Indexing 2015 VLDB 7.4414299e-05
3,466 Adaptive Logging: Optimizing Logging and Recovery Costs in Distributed In-memory Databases 2016 SIGMOD 7.2755875e-05
3,827 ScaleStore: A Fast and Cost-Efficient Storage Engine using DRAM, NVMe, and RDMA 2022 SIGMOD 6.9972263e-05
4,037 Scalable Replay-Based Replication For Fast Databases 2017 VLDB 6.8359601e-05
4,139 Latch-Free Data Structures for DBMS: Design, Implementation, and Evaluation 2013 SIGMOD 6.7825495e-05
4,166 Spitfire: A Three-Tier Buffer Manager for Volatile and Non-Volatile Memory 2021 SIGMOD 6.7635038e-05
4,261 MorphoSys: Automatic Physical Design Metamorphosis for Distributed Database Systems 2020 VLDB 6.6960399e-05
4,375 Graph Analytics Through Fine-Grained Parallelism 2016 SIGMOD 6.6271654e-05
4,613 Building High Throughput Permissioned Blockchain Fabrics: Challenges and Opportunities 2020 VLDB 6.4997362e-05
4,682 Enabling Low Tail Latency on Multicore Key-Value Stores 2020 VLDB 6.4696727e-05
4,738 Rethinking Logging, Checkpoints, and Recovery for High-Performance Storage Engines 2020 SIGMOD 6.4417968e-05
4,900 Micro-architectural Analysis of In-memory OLTP 2016 SIGMOD 6.3625602e-05
4,913 A Top-Down Approach to Achieving Performance Predictability in Database Systems 2017 SIGMOD 6.3548977e-05
4,934 Data Management in Non-Volatile Memory 2015 SIGMOD 6.3451379e-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.

Previous Page 1 / 1 Next

Semantically Similar Papers