A Critique of ANSI SQL Isolation Levels
Summary: ANSI SQL-92 isolation levels critiqued: phenomena-based criteria and locking semantics mischaracterize common levels. Investigates ambiguity, formalizes phenomena, introduces new ones, and defines Snapshot Isolation as a central multiversion isolation type. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Hal Berenson (Microsoft)
- 2. Phil Bernstein (Microsoft)
- 3. Jim Gray (University of California Berkeley)
- 4. Jim Melton (Sybase)
- 5. Elizabeth O'Neil (University of Massachusetts Boston)
- 6. Patrick O'Neil (University of Massachusetts Boston)
BibTeX Citation
@inproceedings{berenson_sigmod95,
title = {{A Critique of ANSI SQL Isolation Levels}},
author = {Berenson, Hal and Bernstein, Phil and Gray, Jim and Melton, Jim and O'Neil, Elizabeth and O'Neil, Patrick},
series = {{SIGMOD} '95},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/223784.223785},
url = {https://dl.acm.org/doi/10.1145/223784.223785},
year = {1995}
}Incoming Citations (Sorted by Pagerank)
Showing 35 of 135 citing papers.
Outgoing Citations (Sorted by Pagerank)
Showing 1 of 1 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 99 | The Design of the POSTGRES Storage System | 1987 | VLDB | 0.00034506601 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 7,988 | Scalable and Robust Snapshot Isolation for High-Performance Storage Engines | 2023 | VLDB |
| 2 | 11,371 | Allocating Isolation Levels to Transactions in a Multiversion Setting | 2023 | PODS |
| 3 | 754 | Lazy Database Replication with Snapshot Isolation | 2006 | VLDB |
| 4 | 2,646 | Allocating Isolation Levels to Transactions | 2005 | PODS |
| 5 | 9,955 | Deciding Robustness for Lower SQL Isolation Levels | 2020 | PODS |
| 6 | 733 | Serializable Snapshot Isolation in PostgreSQL | 2012 | VLDB |
| 7 | 2,057 | Automating the Detection of Snapshot Isolation Anomalies | 2007 | VLDB |
| 8 | 245 | Serializable Isolation for Snapshot Databases | 2008 | SIGMOD |
| 9 | 3,940 | Quantifying Isolation Anomalies | 2009 | VLDB |
| 10 | 14,006 | Testing Isolation Levels of Relational Database Management Systems | 2002 | VLDB |