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
- 6434
- Venue
- SIGMOD
- Year
- 2022
- Pagerank
- 5.313161e-05
- Overall Rank
- 5,822 | 59.50%
- 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.00083894938 |
| 45 |
Sagas |
1987 |
SIGMOD |
0.00071800944 |
| 174 |
ARIES/KVL: A Key-Value Locking Method for Concurrency Control of Multiaction Transactions Operating on B-Tree Indexes |
1990 |
VLDB |
0.00038347904 |
| 419 |
Fast Serializable Multi-Version Concurrency Control for Main-Memory Database Systems |
2015 |
SIGMOD |
0.00023720338 |
| 1,028 |
Coordination Avoidance in Database Systems |
2015 |
VLDB |
0.00014584518 |
| 1,088 |
ARIES/IM: An Efficient and High Concurrency Index Management Method Using Write-Ahead Logging |
1992 |
SIGMOD |
0.00014161003 |
| 1,310 |
Consistency Analysis in Bloom: a CALM and Collected Approach |
2011 |
CIDR |
0.00012658593 |
| 1,540 |
Split-Transactions for Open-Ended Activities |
1988 |
VLDB |
0.00011460082 |
| 1,739 |
Precision Locks |
1981 |
SIGMOD |
0.00010719584 |
| 1,994 |
ACIDRain: Concurrency-Related Attacks on Database-Backed Web Applications |
2017 |
SIGMOD |
9.842936e-05 |
| 2,926 |
Design Principles for Scaling Multi-core OLTP Under High Contention |
2016 |
SIGMOD |
7.884983e-05 |
| 3,512 |
Feral Concurrency Control: An Empirical Investigation of Modern Application Integrity |
2015 |
SIGMOD |
7.0250008e-05 |
| 3,788 |
Opportunities for Optimism in Contended Main-Memory Multicore Transactions |
2020 |
VLDB |
6.7656267e-05 |
| 4,519 |
Controlled Lock Violation |
2013 |
SIGMOD |
6.1176534e-05 |
| 4,627 |
Multi-Version Range Concurrency Control in Deuteronomy |
2015 |
VLDB |
6.0390708e-05 |
| 4,633 |
Transaction Healing: Scaling Optimistic Concurrency Control on Multicores |
2016 |
SIGMOD |
6.0340758e-05 |
| 4,840 |
Solving the Phantom Problem by Predicative Optimistic Concurrency Control |
1983 |
VLDB |
5.8864974e-05 |
| 6,238 |
IPA: Invariant-Preserving Applications for Weakly Consistent Replicated Databases |
2019 |
VLDB |
5.14228e-05 |
| 6,256 |
Scalable Transactions across Heterogeneous NoSQL Key-Value Data Stores |
2013 |
VLDB |
5.1367472e-05 |
| 6,529 |
Transaction Repair for Multi-Version Concurrency Control |
2017 |
SIGMOD |
5.0252405e-05 |
| 7,093 |
Transaction Management In An Object-Oriented Database System |
1988 |
SIGMOD |
4.8367994e-05 |
Semantically Similar Papers
| Overall Rank |
Paper |
Year |
Venue |
Pagerank |
| 6,028 |
Ensuring Relaxed Atomicity for Flexible Transactions in Multidatabase Systems |
1994 |
SIGMOD |
5.2415551e-05 |
| 1,994 |
ACIDRain: Concurrency-Related Attacks on Database-Backed Web Applications |
2017 |
SIGMOD |
9.842936e-05 |
| 3,605 |
Lazy Evaluation of Transactions in Database Systems |
2014 |
SIGMOD |
6.9281695e-05 |
| 3,123 |
Concurrency Control for Resilient Nested Transactions |
1983 |
PODS |
7.5249489e-05 |
| 6,489 |
Nested Transactions with Multiple Commit Points: An Approach to the Structuring of Advanced Database Applications |
1984 |
VLDB |
5.0433313e-05 |
| 14,249 |
Safety Of Non-Well-Locked Transaction Systems |
1986 |
PODS |
- |
| 8,941 |
On Correctness of Non-serializable Executions |
1993 |
PODS |
4.427232e-05 |
| 1,642 |
Transaction Synchronisation In Object Bases |
1988 |
PODS |
0.00011044566 |
| 9,870 |
Are Database System Researchers Making Correct Assumptions About Transaction Workloads? |
2025 |
SIGMOD |
4.2667743e-05 |
| 7,618 |
Developer’s Responsibility or Database’s Responsibility? Rethinking Concurrency Control in Databases |
2023 |
CIDR |
4.6944277e-05 |