A Critique of ANSI SQL Isolation Levels

Hal Berenson, Phil Bernstein, Jim Gray +3

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…