A Critique of ANSI SQL Isolation Levels

Proc. ACM SIGMOD 95, pp. 1-10, San Jose CA, June 1995 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 s...

Full description

Saved in:

Bibliographic Details
Main Authors:	Berenson, Hal, Bernstein, Phil, Gray, Jim, Melton, Jim, O'Neil, Elizabeth, O'Neil, Patrick
Format:	Journal Article
Language:	English
Published:	25-01-2007
Subjects:	Computer Science - Databases
Online Access:	Get full text
Tags:	Add Tag No Tags, Be the first to tag this record!

Description
Summary:	Proc. ACM SIGMOD 95, pp. 1-10, San Jose CA, June 1995 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.
Bibliography:	MSR-TR-95-51
DOI:	10.48550/arxiv.cs/0701157