A Critique of ANSI SQL Isolation Levels

Simple item page
dc.creatorBerenson, Hal
dc.creatorBernstein, Phil
dc.creatorGray, Jim
dc.creatorMelton, Jim
dc.creatorO'Neil, Elizabeth
dc.creatorO'Neil, Patrick
dc.date2007-01-25
dc.date.accessioned2026-07-07T07:43:12Z
dc.date.available2026-07-07T07:43:12Z
dc.descriptionANSI 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.
dc.identifierhttps://arxiv.org/abs/cs/0701157
dc.identifierhttp://arxiv.org/abs/cs/0701157
dc.identifierProc. ACM SIGMOD 95, pp. 1-10, San Jose CA, June 1995
dc.identifier.urihttp://salesiana.dossiersoluciones.com/handle/123456789/122737
dc.subjectDatabases
dc.titleA Critique of ANSI SQL Isolation Levels
dc.typetext

Files

Collections

arXiv