A Critique of ANSI SQL Isolation Levels

ACM SIGMOD Record

Volumn 24, Issue 2, 1995, Pages 1-10

  Berenson, Hal ^a   Bernstein, Phil ^a   Gray, Jim ^b   Melton, Jim ^c   O'Neil, Elizabeth ^d   O'Neil, Patrick ^d  

^a MICROSOFT   (United States)

^b UNIVERSITY OF CALIFORNIA   (United States)

^c Sybase Inc   (United States)

^d UNIVERSITY OF MASSACHUSETTS BOSTON   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

EID: 84976863388     PISSN: 01635808     EISSN: N/A     Source Type: Journal    
DOI: 10.1145/568271.223785     Document Type: Article

References (18)

1. [ANSI] ANSI X3.135-1992, American National Standard for Information Systems — Database Language — SQL, November, 1992
2. [ABJ] V. Atiuri, E. Bertino, S. Jajodia, “A Theoretical Formulation for Degrees of Isolation in Databases,” Technical Report, George Mason University, Fairfax, VA, 1995
3. [BHG] P. A. Bernstein, V. Hadzilacos, N. Goodman, “Concurrency Control and Recovery in Database Systems,” Addison-Wesley 1987.
4. [DAT] C. I. Date, “An Introduction to Database Systems Fifth Edition, Addison-Wesley, 1990
5. [DB2] C. J. Date and C. J. White, “A Guide to DB2,” Third Edition, Addison-Wesley, 1989.
6. [EGLT] K. P. Eswaran, J. Gray, R. Lorie, I. Traiger, “The Notions of Consistency and Predicate Locks in a Database System, ” CACM V 19.11, pp. 624–633, Nov. 1978
7. [GLPT] J, Gray, R. Lorie, G. Putzolu and, I. Traiger, “Granularity of Locks and Degrees of Consistency in a Shared Data Base, ” in Readings in Database Systems, Second Edition, Chapter 3, Michael Stonebraker, Ed., Mofgan Kaufmann 1994 (originally published in 1977).
8. [GR] J. Gray and A. Reuter, “Transaction Processing: Concepts and TechniquesCorrected Second Printing, Morgan Kaufmann 1993, Section 7.6 and following.
9. [HOB] L. Hobbs and K. England, “Rdb/VMS, A Comprehensive Guide,” Digital Press, 1991.
10. [ELL] Illustra Information Technologies, “IUustra User's Guide,”, Illustra Information Technologies, Oakland, CA. 1994.
11. [MS] J. Melton and A. R. Simon, “Understanding The New SQL: A Complete Guide, ” Morgan Kaufmann 1993.
12. [OOBBGM] P. O’Neil, E. O’Neil, H. Berenson, P. Bernstein, J. Gray, J. Melton, “An Investigation of Transactional Isolation LevelsUMass/Boston Dept, of Math & C.S. Preprint.
13. [ORA] “PL/SQL User's Guide and Reference, Version L0,” Part 800-V1.0, Oracle Corp., 1989.
14. [PAP] C. Papadimitriou, “The Theory of Database Concurrency Control, Computer Science Press, 1986.
15. [PON] P. O’Neil, “Database: Principles, Programming, Performance, Morgan Kaufmann 1994, Section 9.5.
16. [REE] D. Reed, “Implementing Atomic Actions On Decentralized Data,” ACMTOCS 1.1,1981,pp. 3–23.
17. [STO] M. J. Stonebraker, “The Design of the POSTGRES Storage System,” 13th VLDB, 1987, reprinted in Readings in Database Systems, Second Edition, M. J. Stonebraker, Ed., Morgan Kaufmann 1994
18. [THA] M. Thakur, “Transaction Models in InterBase 4,” Proceedings of the Borland International Conference, June 1994.