Database Paper Browser

Back to papers

Are Database System Researchers Making Correct Assumptions About Transaction Workloads?

Summary: Empirical study of 111 OSS apps (30k+ transactions) tests two common workload assumptions behind high-performance OLTP designs. Finds the second assumption is stronger: 90% have ≥58% read/write sets inferable; 39% are non-interactive, and 61% could be so with minimal changes, reshaping OLTP expressivity and performance. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
7205
Venue
SIGMOD
Year
2025
Pagerank
4.2667743e-05
Overall Rank
9,870 | 31.34%
DOI
10.1145/3725268

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 1 of 1 citing papers.

Rank Citing Paper Year Venue Pagerank
10,056 Brook-2PL: Tolerating High Contention Workloads with A Deadlock-Free Two-Phase Locking Protocol 2026 SIGMOD 4.1945683e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 33 of 33 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
86 The End of an Architectural Era (It's Time for a Complete Rewrite) 2007 VLDB 0.00052563276
122 Calvin: Fast Distributed Transactions for Partitioned Database Systems 2012 SIGMOD 0.00045316749
137 H-Store: A High-Performance, Distributed Main Memory Transaction Processing System 2008 VLDB 0.00042342967
889 Carousel: Low-Latency Transaction Processing for Globally-Distributed Data 2018 SIGMOD 0.0001557156
959 The Case for Determinism in Database Systems 2010 VLDB 0.00015025361
1,090 Low Overhead Concurrency Control for Partitioned Main Memory Databases 2010 SIGMOD 0.0001415654
1,217 Rethinking serializable multiversion concurrency control 2015 VLDB 0.0001323177
1,521 High Performance Transactions via Early Write Visibility 2017 VLDB 0.00011532045
1,832 Lightweight Locking for Main Memory Database Systems 2013 VLDB 0.00010380187
1,994 ACIDRain: Concurrency-Related Attacks on Database-Backed Web Applications 2017 SIGMOD 9.842936e-05
2,237 Procedural Extensions of SQL: Understanding their usage in the wild 2021 VLDB 9.2212748e-05
2,369 Aria: A Fast and Practical Deterministic OLTP Database 2020 VLDB 8.9490403e-05
2,373 SLOG: Serializable, Low-latency, Geo-replicated Transactions 2019 VLDB 8.9476269e-05
2,601 What Are We Doing With Our Lives? Nobody Cares About Our Concurrency Control Research 2017 SIGMOD 8.468229e-05
2,926 Design Principles for Scaling Multi-core OLTP Under High Contention 2016 SIGMOD 7.884983e-05
3,421 An Evaluation of the Advantages and Disadvantages of Deterministic Database Systems 2014 VLDB 7.1139504e-05
3,512 Feral Concurrency Control: An Empirical Investigation of Modern Application Integrity 2015 SIGMOD 7.0250008e-05
3,586 Handling Highly Contended OLTP Workloads Using Fast Dynamic Partitioning 2020 SIGMOD 6.9435005e-05
4,054 Scaling Multicore Databases via Constrained Parallel Execution 2016 SIGMOD 6.4919461e-05
4,575 Ocean Vista: Gossip-Based Visibility Control for Speedy Geo-Distributed Transactions 2019 VLDB 6.0736009e-05
4,727 STAR: Scaling Transactions through Asymmetric Replication 2019 VLDB 5.9690763e-05
5,768 Epoch-based Commit and Replication in Distributed OLTP Databases 2021 VLDB 5.3333911e-05
5,822 Ad Hoc Transactions in Web Applications: The Good, the Bad, and the Ugly 2022 SIGMOD 5.313161e-05
5,842 Detock: High Performance Multi-region Transactions at Scale 2023 SIGMOD 5.3038084e-05
6,317 Chiller: Contention-centric Transaction Execution and Data Partitioning for Modern Networks 2020 SIGMOD 5.1140356e-05
6,634 Fine-Grained Re-Execution for Efficient Batched Commit of Distributed Transactions 2023 VLDB 4.982784e-05
6,692 WeBridge: Synthesizing Stored Procedures for Large-Scale Real-World Web Applications 2024 SIGMOD 4.9599916e-05
6,857 When Private Blockchain Meets Deterministic Database 2023 SIGMOD 4.906043e-05
7,211 Caerus: Low-Latency Distributed Transactions for Geo-Replicated Systems 2024 VLDB 4.7990535e-05
7,406 Database Isolation By Scheduling 2021 VLDB 4.7375424e-05
7,618 Developer’s Responsibility or Database’s Responsibility? Rethinking Concurrency Control in Databases 2023 CIDR 4.6944277e-05
7,825 Natto: Providing Distributed Transaction Prioritization for High-Contention Workloads 2022 SIGMOD 4.6417301e-05
9,722 NOC-NOC: Towards Performance-optimal Distributed Transactions 2024 SIGMOD 4.2959935e-05
Previous Page 1 / 1 Next

Semantically Similar Papers