DBScholar

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
7267
Venue
SIGMOD
Year
2025
Pagerank
5.2566631e-05
Overall Rank
9,517 | 34.71%
DOI
10.1145/3725268

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{nguyen_sigmod25,
        title = {{Are Database System Researchers Making Correct Assumptions About Transaction Workloads?}},
        author = {Nguyen, Cuong D. T. and Niechen, Kevin and DeCarolis, Chris and Abadi, Daniel J.},
        series = {{SIGMOD} '25},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3725268},
        url = {https://dl.acm.org/doi/10.1145/3725268},
        year = {2025}
}

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank Citing Paper Year Venue Pagerank
10,033 Modeling Concurrency Control as a Learnable Function 2026 SIGMOD 5.173224e-05
10,348 Brook-2PL: Tolerating High Contention Workloads with A Deadlock-Free Two-Phase Locking Protocol 2026 SIGMOD 5.093636e-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
57 Calvin: Fast Distributed Transactions for Partitioned Database Systems 2012 SIGMOD 0.00040139242
68 The End of an Architectural Era (It’s Time for a Complete Rewrite) 2007 VLDB 0.00038446206
83 H-Store: A High-Performance, Distributed Main Memory Transaction Processing System 2008 VLDB 0.00036185259
755 Rethinking serializable multiversion concurrency control 2015 VLDB 0.00014326008
766 The Case for Determinism in Database Systems 2010 VLDB 0.0001420984
773 Low Overhead Concurrency Control for Partitioned Main Memory Databases 2010 SIGMOD 0.00014131021
1,063 High Performance Transactions via Early Write Visibility 2017 VLDB 0.00012343623
1,420 Lightweight Locking for Main Memory Database Systems 2013 VLDB 0.00010829638
1,570 Carousel: Low-Latency Transaction Processing for Globally-Distributed Data 2018 SIGMOD 0.00010334131
1,700 Aria: A Fast and Practical Deterministic OLTP Database 2020 VLDB 9.9726588e-05
1,775 SLOG: Serializable, Low-latency, Geo-replicated Transactions 2019 VLDB 9.7870611e-05
1,892 Procedural Extensions of SQL: Understanding their usage in the wild 2021 VLDB 9.5277793e-05
2,052 ACIDRain: Concurrency-Related Attacks on Database-Backed Web Applications 2017 SIGMOD 9.251901e-05
2,234 Design Principles for Scaling Multi-core OLTP Under High Contention 2016 SIGMOD 8.8937932e-05
2,368 What Are We Doing With Our Lives? Nobody Cares About Our Concurrency Control Research 2017 SIGMOD 8.6827828e-05
2,765 An Evaluation of the Advantages and Disadvantages of Deterministic Database Systems 2014 VLDB 8.1530951e-05
2,998 Handling Highly Contended OLTP Workloads Using Fast Dynamic Partitioning 2020 SIGMOD 7.8727047e-05
3,186 Feral Concurrency Control: An Empirical Investigation of Modern Application Integrity 2015 SIGMOD 7.6559187e-05
3,198 Scaling Multicore Databases via Constrained Parallel Execution 2016 SIGMOD 7.6434062e-05
3,696 Ocean Vista: Gossip-Based Visibility Control for Speedy Geo-Distributed Transactions 2019 VLDB 7.1905677e-05
3,967 STAR: Scaling Transactions through Asymmetric Replication 2019 VLDB 6.984665e-05
4,869 Epoch-based Commit and Replication in Distributed OLTP Databases 2021 VLDB 6.4709867e-05
5,324 Detock: High Performance Multi-region Transactions at Scale 2023 SIGMOD 6.2649486e-05
5,406 Ad Hoc Transactions in Web Applications: The Good, the Bad, and the Ugly 2022 SIGMOD 6.2289734e-05
5,725 Chiller: Contention-centric Transaction Execution and Data Partitioning for Modern Networks 2020 SIGMOD 6.108451e-05
5,900 Fine-Grained Re-Execution for Efficient Batched Commit of Distributed Transactions 2023 VLDB 6.0468661e-05
6,475 WeBridge: Synthesizing Stored Procedures for Large-Scale Real-World Web Applications 2024 SIGMOD 5.8687157e-05
6,476 When Private Blockchain Meets Deterministic Database 2023 SIGMOD 5.8686486e-05
6,867 Caerus: Low-Latency Distributed Transactions for Geo-Replicated Systems 2024 VLDB 5.7506468e-05
7,347 Developer’s Responsibility or Database’s Responsibility? Rethinking Concurrency Control in Databases 2023 CIDR 5.6375582e-05
7,434 Database Isolation By Scheduling 2021 VLDB 5.619487e-05
7,562 Natto: Providing Distributed Transaction Prioritization for High-Contention Workloads 2022 SIGMOD 5.5958739e-05
9,857 NOC-NOC: Towards Performance-optimal Distributed Transactions 2024 SIGMOD 5.2079113e-05
Previous Page 1 / 1 Next

Semantically Similar Papers