-
- Hal Berenson
- Microsoft Corp.
-
- Phil Bernstein
- Microsoft Corp.
-
- Jim Gray
- U.C. Berkeley
-
- Jim Melton
- Sybase Corp.
-
- Elizabeth O'Neil
- UMss/Boston
この論文をさがす
説明
<jats:p> ANSI SQL-92 [MS, ANSI] defines Isolation <jats:italic>Levels</jats:italic> in terms of <jats:italic>phenomena:</jats:italic> Dirty Reads, Non-Repeatable Reads, and Phantoms. This paper shows that these phenomena and the ANSI SQL definitions fail to properly characterize several popular isolation levels, including the standard locking implementations of the levels covered. Ambiguity in the statement of the phenomena is investigated and a more formal statement is arrived at; in addition new phenomena that better characterize isolation types are introduced. Finally, an important multiversion isolation type, called Snapshot Isolation, is defined. </jats:p>
収録刊行物
-
- ACM SIGMOD Record
-
ACM SIGMOD Record 24 (2), 1-10, 1995-05-22
Association for Computing Machinery (ACM)
