A critique of ANSI SQL isolation levels-Reference-Cited by-同舟云学术

A critique of ANSI SQL isolation levels

Published:1995-05-22 Issue:2 Volume:24 Page:1-10
ISSN:0163-5808
Container-title:ACM SIGMOD Record
language:en
Short-container-title:SIGMOD Rec.

Author:

Berenson Hal¹,Bernstein Phil¹,Gray Jim²,Melton Jim³,O'Neil Elizabeth⁴,O'Neil Patrick

Affiliation:

1. Microsoft Corp.

2. U.C. Berkeley

3. Sybase Corp.

4. UMss/Boston

Abstract

ANSI SQL-92 [MS, ANSI] 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 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.

Publisher

Association for Computing Machinery (ACM)

Subject

Information Systems,Software

Link

https://dl.acm.org/doi/pdf/10.1145/568271.223785

Reference18 articles.

1. ANSI X3.135-1992 American National Standard for Information Systems -- Database Language -- SQL November 1992 ANSI X3.135-1992 American National Standard for Information Systems -- Database Language -- SQL November 1992

2. V. Atluri E. Bertino S. Jajodia "A Theoretical Formulation for Degrees of Isolation in Databases " Technical Report George Mason University Fairfax VA 1995 V. Atluri E. Bertino S. Jajodia "A Theoretical Formulation for Degrees of Isolation in Databases " Technical Report George Mason University Fairfax VA 1995

3. P. A. Bernstein V. Hadzilacos N. Goodman "Concurrency Control and Recovery in Database Systems " Addison-Wesley 1987. P. A. Bernstein V. Hadzilacos N. Goodman "Concurrency Control and Recovery in Database Systems " Addison-Wesley 1987.

Cited by 313 articles. 订阅此论文施引文献订阅此论文施引文献，注册后可以免费订阅5篇论文的施引文献，订阅后可以查看论文全部施引文献

1. Transactional TF: Transform Library with Concurrency and Correctness;IEICE Transactions on Information and Systems;2023-12-01

2. CSMV: A highly scalable multi-versioned software transactional memory for GPUs;Journal of Parallel and Distributed Computing;2023-10

3. BlockPilot: A Proposer-Validator Parallel Execution Framework for Blockchain;Proceedings of the 52nd International Conference on Parallel Processing;2023-08-07

4. ScalarDB: Universal Transaction Manager for Polystores;Proceedings of the VLDB Endowment;2023-08

5. DRPTM: A Decoupled Read-efficient High-scalable Persistent Transactional Memory;2023 60th ACM/IEEE Design Automation Conference (DAC);2023-07-09