pith. sign in

arxiv: cs/0701157 · v1 · submitted 2007-01-25 · 💻 cs.DB

A Critique of ANSI SQL Isolation Levels

Hal Berenson , Phil Bernstein , Jim Gray , Jim Melton , Elizabeth O'Neil , Patrick O'Neil This is my paper
classification 💻 cs.DB
keywords isolationlevelsphenomenaansicharacterizedefinitionsreadsaddition
0
0 comments X
read the original abstract

ANSI SQL-92 defines Isolation Levels in terms of phenomena: Dirty Reads, Non-Repeatable Reads, and Phantoms. This paper shows that these phenomena and the ANSI SQL definitions fail to characterize several popular isolation levels, including the standard locking implementations of the levels. Investigating the ambiguities of the phenomena leads to clearer definitions; in addition new phenomena that better characterize isolation types are introduced. An important multiversion isolation type, Snapshot Isolation, is defined.

This paper has not been read by Pith yet.

discussion (0)

Sign in with ORCID, Apple, or X to comment. Anyone can read and Pith papers without signing in.

Forward citations

Cited by 1 Pith paper

Reviewed papers in the Pith corpus that reference this work. Sorted by Pith novelty score.

  1. Versioned Late Materialization for Ultra-Long Sequence Training in Recommendation Systems at Scale

    cs.IR 2026-04 unverdicted novelty 6.0

    Versioned late materialization stores user histories once and reconstructs sequences just-in-time during training to cut redundancy and enable longer sequences in large-scale recommendation systems.