Back to papers
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
- 6435
- Venue
- SIGMOD
- Year
- 2022
- Pagerank
- 5.3080741e-05
- Overall Rank
- 5,835 | 59.45%
- DOI
-
10.1145/3514221.3526120
Incoming Non-self Citations Over Time
Incoming Citations (Sorted by Pagerank)
Showing 8 of 8 citing papers.
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 |
| 23 |
A Critique of ANSI SQL Isolation Levels |
1995 |
SIGMOD |
0.00083899338 |
| 45 |
Sagas |
1987 |
SIGMOD |
0.00071732655 |
| 175 |
ARIES/KVL: A Key-Value Locking Method for Concurrency Control of Multiaction Transactions Operating on B-Tree Indexes |
1990 |
VLDB |
0.00038354115 |
| 419 |
Fast Serializable Multi-Version Concurrency Control for Main-Memory Database Systems |
2015 |
SIGMOD |
0.00023720294 |
| 1,022 |
Coordination Avoidance in Database Systems |
2015 |
VLDB |
0.00014606725 |
| 1,087 |
ARIES/IM: An Efficient and High Concurrency Index Management Method Using Write-Ahead Logging |
1992 |
SIGMOD |
0.00014159274 |
| 1,311 |
Consistency Analysis in Bloom: a CALM and Collected Approach |
2011 |
CIDR |
0.00012650881 |
| 1,543 |
Split-Transactions for Open-Ended Activities |
1988 |
VLDB |
0.00011447601 |
| 1,734 |
Precision Locks |
1981 |
SIGMOD |
0.00010715681 |
| 1,985 |
ACIDRain: Concurrency-Related Attacks on Database-Backed Web Applications |
2017 |
SIGMOD |
9.8619045e-05 |
| 2,926 |
Design Principles for Scaling Multi-core OLTP Under High Contention |
2016 |
SIGMOD |
7.8868401e-05 |
| 3,517 |
Feral Concurrency Control: An Empirical Investigation of Modern Application Integrity |
2015 |
SIGMOD |
7.0183022e-05 |
| 3,789 |
Opportunities for Optimism in Contended Main-Memory Multicore Transactions |
2020 |
VLDB |
6.7614151e-05 |
| 4,519 |
Controlled Lock Violation |
2013 |
SIGMOD |
6.1125985e-05 |
| 4,625 |
Multi-Version Range Concurrency Control in Deuteronomy |
2015 |
VLDB |
6.0343309e-05 |
| 4,632 |
Transaction Healing: Scaling Optimistic Concurrency Control on Multicores |
2016 |
SIGMOD |
6.0286531e-05 |
| 4,840 |
Solving the Phantom Problem by Predicative Optimistic Concurrency Control |
1983 |
VLDB |
5.8819812e-05 |
| 6,236 |
IPA: Invariant-Preserving Applications for Weakly Consistent Replicated Databases |
2019 |
VLDB |
5.1373428e-05 |
| 6,255 |
Scalable Transactions across Heterogeneous NoSQL Key-Value Data Stores |
2013 |
VLDB |
5.1318353e-05 |
| 6,521 |
Transaction Repair for Multi-Version Concurrency Control |
2017 |
SIGMOD |
5.0235836e-05 |
| 7,088 |
Transaction Management In An Object-Oriented Database System |
1988 |
SIGMOD |
4.8321743e-05 |
Semantically Similar Papers
| Overall Rank |
Paper |
Year |
Venue |
Pagerank |
| 12,716 |
Concurrency Control and Recovery in Transactional Process Management |
1999 |
PODS |
4.1905499e-05 |
| 1,985 |
ACIDRain: Concurrency-Related Attacks on Database-Backed Web Applications |
2017 |
SIGMOD |
9.8619045e-05 |
| 3,605 |
Lazy Evaluation of Transactions in Database Systems |
2014 |
SIGMOD |
6.9247155e-05 |
| 3,126 |
Concurrency Control for Resilient Nested Transactions |
1983 |
PODS |
7.522633e-05 |
| 6,486 |
Nested Transactions with Multiple Commit Points: An Approach to the Structuring of Advanced Database Applications |
1984 |
VLDB |
5.0384864e-05 |
| 14,263 |
Safety Of Non-Well-Locked Transaction Systems |
1986 |
PODS |
- |
| 8,945 |
On Correctness of Non-serializable Executions |
1993 |
PODS |
4.4229886e-05 |
| 1,589 |
Transaction Synchronisation In Object Bases |
1988 |
PODS |
0.00011231186 |
| 9,869 |
Are Database System Researchers Making Correct Assumptions About Transaction Workloads? |
2025 |
SIGMOD |
4.2626861e-05 |
| 7,617 |
Developer’s Responsibility or Database’s Responsibility? Rethinking Concurrency Control in Databases |
2023 |
CIDR |
4.6901099e-05 |