• Documents
  • Authors
  • Tables
  • Other Seers ▼
    RefSeer AckSeer CollabSeer SeerSeer
  • Log in
  • Sign up
  • MetaCart

CiteSeerX logo

Advanced Search Include Citations
Advanced Search Include Citations | Disambiguate

A critique of ANSI SQL isolation levels (1995)

Cached

  • Download as a PDF

Download Links

  • [cs.ucsb.edu]
  • [www.cs.uoregon.edu]
  • [www.cs.umb.edu]
  • [ftp.research.microsoft.com]
  • [research.microsoft.com]
  • [www.cs.wisc.edu]
  • [pages.cs.wisc.edu]

  • Other Repositories/Bibliography

  • DBLP
  • Save to List
  • Add to Collection
  • Correct Errors
  • Monitor Changes
by Jim Gray , U. C. Berkeley
Citations:178 - 4 self
  • Summary
  • Active Bibliography
  • Co-citation
  • Clustered Documents
  • Version History

BibTeX

@INPROCEEDINGS{Gray95acritique,
    author = {Jim Gray and U. C. Berkeley},
    title = {A critique of ANSI SQL isolation levels},
    booktitle = {},
    year = {1995},
    pages = {1--10},
    publisher = {ACM Press}
}

Years of Citing Articles

Bookmark

citeulike Connotea Bibsonomy Del.icio.us Digg Reddit

OpenURL

 

Abstract

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 Ioeking 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. 1.

Citations

1439 Concurrency Control and Recovery in Database Systems - Bernstein, Hadzilacos, et al. - 1987
1236 Transaction Processing: Concepts and Techniques - Gray, Reuter - 1993
465 The notions of consistency and predicate locks in a database system - Eswaran, Gray, et al. - 1976
193 Understanding the New SQL: A Complete Guide - Melton, Simon - 1993
170 The theory of Database Concurrency Control - Papadimitriou - 1986
155 e design of the POSTGRES storage system - Stonebraker
147 Granularity of Locks and Degrees of Consistency in a Shared Database. Modeling - Gray, Lorie, et al. - 1975
90 Implementing atomic actions on decentralized data - Reed - 1983
17 American National Standard for Information Systems – Database Language – SQL - 135-1992 - 1992
10 Rdb: A Comprehensive Guide - Hobbs, England - 1995
6 Traiger, "The Notions of Consistency and Predicate Locks in a Database System - Eswaran, Gray, et al. - 1976
5 An Introduction to Database Systems,” Fifth Edition - Date - 1990
5 An Optimality Theory of Database Concurrency - Kung, Papadimitriou - 1984
4 Understanding The New SQL: A Complete Guide, ” Morgan Kaufmrmn - Melton, Simon - 1993
4 A theoretical formulation for degrees of isolation in databases - Atluri, Bertino, et al. - 1995
3 Transaction models in interbase 4 - Thakur - 1994
3 A Guide to DB2,” Third Edition - Date, White - 1989
1 ANSI] [AEul [BHG] [DAT] [DB2] [EGLT] [GLPT] ANSI X3. 135-1992, American Nalional Standard for Information Systems – Database Language – SQL - Atluri, Bertino, et al. - 1992
1 Seetion 7.6 and [HOB - Kanfmann - 1993
1 User’s Guide and Reference - “PllSQL - 1989
1 An Introduction to Database Systems," Fifth Edition - Date - 1990
1 A Guide to DB2," Third Edition - Date, White - 1989
1 An Investigation of Transactional Isolation Levels," UMass/Boston Dept - O'Neil, O'Neil, et al.
1 Database - O'Neil - 1994
1 Section 7.6 and following - Gray, Reuter - 1993
1 The Design of the POSTGRES Storage System,” 13th VLDB - Stonebraker - 1987
1 Implementing Atomic Actions On Decentralized - Reed
The National Science Foundation
  • About CiteSeerX
  • Submit Documents
  • Privacy Policy
  • Help
  • Data
  • Source
  • Contact Us

Developed at and hosted by The College of Information Sciences and Technology

© 2007-2010 The Pennsylvania State University