A Critique of ANSI SQL Isolation Levels

Details A Critique of ANSI SQL Isolation Levels A Critique of ANSI SQL Isolation Levels

2007-01-25

arxiv.org/abs/cs/0701157v1

Proc. ACM SIGMOD 95, pp. 1-10, San Jose CA, June 1995

Computer Science

Databases

Scientific paper

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.

Affiliated with

Also associated with

No associations

Rating

A Critique of ANSI SQL Isolation Levels does not yet have a rating. At this time, there are no reviews or comments for this scientific paper.

If you have personal experience with A Critique of ANSI SQL Isolation Levels, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and A Critique of ANSI SQL Isolation Levels will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFWR-SCP-O-568193