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
hc7fbf82ed522ae78
Venue
SIGMOD
Year
2025
Pagerank
5.1865718e-05
Overall Rank
9,241 | 38.06%
DOI
10.1145/3725268
PDF
Download (CC BY 4.0)

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 3 of 3 citing papers.

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
54 Calvin: Fast Distributed Transactions for Partitioned Database Systems 2012 SIGMOD 0.00040489652
70 The End of an Architectural Era (It’s Time for a Complete Rewrite) 2007 VLDB 0.00037761637
80 H-Store: A High-Performance, Distributed Main Memory Transaction Processing System 2008 VLDB 0.00036267455
740 Rethinking serializable multiversion concurrency control 2015 VLDB 0.00014303858
764 The Case for Determinism in Database Systems 2010 VLDB 0.00014110914
797 Low Overhead Concurrency Control for Partitioned Main Memory Databases 2010 SIGMOD 0.0001388084
1,051 High Performance Transactions via Early Write Visibility 2017 VLDB 0.00012262974
1,437 Lightweight Locking for Main Memory Database Systems 2013 VLDB 0.0001064992
1,575 Carousel: Low-Latency Transaction Processing for Globally-Distributed Data 2018 SIGMOD 0.00010160119
1,655 Aria: A Fast and Practical Deterministic OLTP Database 2020 VLDB 9.9502338e-05
1,710 SLOG: Serializable, Low-latency, Geo-replicated Transactions 2019 VLDB 9.797642e-05
1,800 Procedural Extensions of SQL: Understanding their usage in the wild 2021 VLDB 9.5999908e-05
2,090 ACIDRain: Concurrency-Related Attacks on Database-Backed Web Applications 2017 SIGMOD 9.0448846e-05
2,221 Design Principles for Scaling Multi-core OLTP Under High Contention 2016 SIGMOD 8.807697e-05
2,405 What Are We Doing With Our Lives? Nobody Cares About Our Concurrency Control Research 2017 SIGMOD 8.4976424e-05
2,703 An Evaluation of the Advantages and Disadvantages of Deterministic Database Systems 2014 VLDB 8.0952583e-05
3,045 Handling Highly Contended OLTP Workloads Using Fast Dynamic Partitioning 2020 SIGMOD 7.7044181e-05
3,208 Feral Concurrency Control: An Empirical Investigation of Modern Application Integrity 2015 SIGMOD 7.5187209e-05
3,264 Scaling Multicore Databases via Constrained Parallel Execution 2016 SIGMOD 7.4667818e-05
3,587 Ocean Vista: Gossip-Based Visibility Control for Speedy Geo-Distributed Transactions 2019 VLDB 7.1681502e-05
4,038 STAR: Scaling Transactions through Asymmetric Replication 2019 VLDB 6.8244412e-05
4,844 Epoch-based Commit and Replication in Distributed OLTP Databases 2021 VLDB 6.3720999e-05
5,024 Detock: High Performance Multi-region Transactions at Scale 2023 SIGMOD 6.2984992e-05
5,337 Chiller: Contention-centric Transaction Execution and Data Partitioning for Modern Networks 2020 SIGMOD 6.1613626e-05
5,548 Ad Hoc Transactions in Web Applications: The Good, the Bad, and the Ugly 2022 SIGMOD 6.0713859e-05
5,984 When Private Blockchain Meets Deterministic Database 2023 SIGMOD 5.9094413e-05
6,012 Fine-Grained Re-Execution for Efficient Batched Commit of Distributed Transactions 2023 VLDB 5.8964082e-05
6,506 Caerus: Low-Latency Distributed Transactions for Geo-Replicated Systems 2024 VLDB 5.7453191e-05
6,586 WeBridge: Synthesizing Stored Procedures for Large-Scale Real-World Web Applications 2024 SIGMOD 5.7237124e-05
7,499 Developer’s Responsibility or Database’s Responsibility? Rethinking Concurrency Control in Databases 2023 CIDR 5.4956879e-05
7,588 Database Isolation By Scheduling 2021 VLDB 5.4744469e-05
7,589 Natto: Providing Distributed Transaction Prioritization for High-Contention Workloads 2022 SIGMOD 5.4738752e-05
10,071 NOC-NOC: Towards Performance-optimal Distributed Transactions 2024 SIGMOD 5.0732858e-05
Previous Page 1 / 1 Next

Semantically Similar Papers