Ad Hoc Transactions in Web Applications: The Good, the Bad, and the Ugly

Summary: Comprehensive study of ad hoc transactions—application-coordinated DB operations—in 8 open-source web apps (91 instances, up to 16 per app; 71 critical). Findings: ad hoc concurrency control is more flexible than standard DB transactions, yet more error-prone (53 correctness issues; 33 developer-confirmed), suggesting performance gains from leveraging application semantics and implications for DB research. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h1a605a9271a03289
Venue: SIGMOD
Year: 2022
Pagerank: 6.0713859e-05
Overall Rank: 5,548 | 62.82%
DOI: 10.1145/3514221.3526120

Incoming Non-self Citations Over Time

Authors

1. Chuzhe Tang (Chinese Ministry of Education; Shanghai Jiao Tong University)
2. Zhaoguo Wang (Chinese Ministry of Education; Shanghai Jiao Tong University)
3. Xiaodong Zhang (Chinese Ministry of Education; Shanghai Jiao Tong University)
4. Qianmian Yu (Chinese Ministry of Education; Shanghai Jiao Tong University)
5. Binyu Zang (Chinese Ministry of Education; Shanghai Jiao Tong University)
6. Haibing Guan (Shanghai Jiao Tong University)
7. Haibo Chen (Chinese Ministry of Education; Shanghai Jiao Tong University)

BibTeX Citation

@inproceedings{tang_sigmod22,
        title = {{Ad Hoc Transactions in Web Applications: The Good, the Bad, and the Ugly}},
        author = {Tang, Chuzhe and Wang, Zhaoguo and Zhang, Xiaodong and Yu, Qianmian and Zang, Binyu and Guan, Haibing and Chen, Haibo},
        series = {{SIGMOD} '22},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3514221.3526120},
        url = {https://dl.acm.org/doi/10.1145/3514221.3526120},
        year = {2022}
}

Incoming Citations (Sorted by Pagerank)

Showing 8 of 8 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
7,499	Developer’s Responsibility or Database’s Responsibility? Rethinking Concurrency Control in Databases	2023	CIDR	5.4956879e-05
7,535	Epoxy: ACID Transactions Across Diverse Data Stores	2023	VLDB	5.4846682e-05
8,610	Mammoths Are Slow: The Overlooked Transactions of Graph Data	2024	VLDB	5.2890649e-05
9,241	Are Database System Researchers Making Correct Assumptions About Transaction Workloads?	2025	SIGMOD	5.1865718e-05
10,098	Simple Testing Can Expose Most Critical Transaction Bugs: Understanding and Detecting Write-Specific Serializability Violations in Database Systems	2025	VLDB	5.068372e-05
11,267	Styx: Transactional Stateful Functions on Streaming Dataflows	2025	SIGMOD	4.9605343e-05
11,345	Fair Transaction Processing for Multi-Tenant Databases	2025	VLDB	4.9605343e-05
11,379	Sonata: Multi-Database Transactions Made Fast and Serializable	2025	VLDB	4.9605343e-05

Outgoing Citations (Sorted by Pagerank)

Showing 21 of 21 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
19	A Critique of ANSI SQL Isolation Levels	1995	SIGMOD	0.00058631912
66	Sagas	1987	SIGMOD	0.00037911331
221	ARIES/KVL: A Key-Value Locking Method for Concurrency Control of Multiaction Transactions Operating on B-Tree Indexes	1990	VLDB	0.0002420049
228	Fast Serializable Multi-Version Concurrency Control for Main-Memory Database Systems	2015	SIGMOD	0.00023872855
807	Coordination Avoidance in Database Systems	2015	VLDB	0.00013734149
985	ARIES/IM: An Efficient and High Concurrency Index Management Method Using Write-Ahead Logging	1992	SIGMOD	0.00012661135
1,255	Consistency Analysis in Bloom: a CALM and Collected Approach	2011	CIDR	0.00011313104
1,752	Split-Transactions for Open-Ended Activities	1988	VLDB	9.7124696e-05
2,090	ACIDRain: Concurrency-Related Attacks on Database-Backed Web Applications	2017	SIGMOD	9.0448846e-05
2,213	Precision Locks	1981	SIGMOD	8.8423485e-05
2,221	Design Principles for Scaling Multi-core OLTP Under High Contention	2016	SIGMOD	8.807697e-05
3,073	Opportunities for Optimism in Contended Main-Memory Multicore Transactions	2020	VLDB	7.6660818e-05
3,208	Feral Concurrency Control: An Empirical Investigation of Modern Application Integrity	2015	SIGMOD	7.5187209e-05
3,862	Multi-Version Range Concurrency Control in Deuteronomy	2015	VLDB	6.9491506e-05
3,944	Controlled Lock Violation	2013	SIGMOD	6.8927605e-05
4,081	Transaction Healing: Scaling Optimistic Concurrency Control on Multicores	2016	SIGMOD	6.801179e-05
4,816	Solving the Phantom Problem by Predicative Optimistic Concurrency Control	1983	VLDB	6.3888168e-05
6,216	Transaction Repair for Multi-Version Concurrency Control	2017	SIGMOD	5.8297052e-05
6,652	Scalable Transactions across Heterogeneous NoSQL Key-Value Data Stores	2013	VLDB	5.7044375e-05
6,714	IPA: Invariant-Preserving Applications for Weakly Consistent Replicated Databases	2019	VLDB	5.6847011e-05
7,510	Transaction Management In An Object-Oriented Database System	1988	SIGMOD	5.4914596e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	2,090	ACIDRain: Concurrency-Related Attacks on Database-Backed Web Applications	2017	SIGMOD
2	13,237	Concurrency Control and Recovery in Transactional Process Management	1999	PODS
3	5,846	Concurrency Control for Resilient Nested Transactions	1983	PODS
4	3,097	Lazy Evaluation of Transactions in Database Systems	2014	SIGMOD
5	7,364	Nested Transactions with Multiple Commit Points: An Approach to the Structuring of Advanced Database Applications	1984	VLDB
6	14,806	Safety Of Non-Well-Locked Transaction Systems	1986	PODS
7	9,304	On Correctness of Non-serializable Executions	1993	PODS
8	2,148	Transaction Synchronisation In Object Bases	1988	PODS
9	9,241	Are Database System Researchers Making Correct Assumptions About Transaction Workloads?	2025	SIGMOD
10	7,499	Developer’s Responsibility or Database’s Responsibility? Rethinking Concurrency Control in Databases	2023	CIDR