| Alternate document: Details A Critique of ANSI SQL Isolation Levels (95) Hal Berenson, et al. |
Hal Berenson, Phil Bernstein, Jim Gray, Jim Melton, Elizabeth O’Neil, Patrick O'Neil  Home/Search
Context Related
| microsoft.com/pub/tr/tr9551.pdf Cached: PS.gz PS PDF This document uses CoBlitz to cache paper downloads. If your firewall is blocking outgoing connections to port 3125, you can use these links to download local copies.
Image Update HelpPS.gz PS PDF From: microsoft.com/~...rayPublications (more) (Enter author homepages) |
Rate this article:      (best)Comment on this article |
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 characterize several popular isolation levels, including the standard locking implementations of the levels. Investigating the ambiguities of the phenomena leads to clearer definitions (Update)
Similar documents based on text: More All
1.6: A Critique of ANSI SQL Isolation Levels - Berenson, al. (1995) (Correct)
0.4: Standards In Practice - Andrew Eisenberg Sybase (Correct)
0.3: SQLJ Part 0, now known as SQL/OLB (Object-Language Bindings) - Andrew Eisenberg Sybase (Correct)
Related documents from co-citation: More All
29: Concurrency Control and Recovery in Database Systems (context) - Bernstein, Hadzilacos et al. - 1987
19: Transaction Processing: Concepts and Techniques (context) - Gray, Reuter - 1993
16: The dangers of replication and a solution - Gray, Helland et al. - 1996
BibTeX entry: (Update)
H. Berenson, P. Bernstein, J. Gray, J. Melton, E. O'Neil, and P. O'Neil. A critique of ANSI SQL isolation levels. In Proceedings of the ACM SIGMOD International Conference on Management of Data, pages 1--10, June 1995. http://citeseer.ist.psu.edu/berenson95critique.html More
@inproceedings{ berenson95critique,
author = "Hal Berenson and Phil Bernstein and Jim Gray and Jim Melton and Elizabeth O'Neil and Patrick O'Neil",
title = "A critique of {ANSI {SQL}} isolation levels",
booktitle = "{Proceedings of the ACM SIGMOD International Conference on Management of Data}",
pages = "1--10",
year = "1995",
url = "citeseer.ist.psu.edu/berenson95critique.html" }
Citations (may not include all citations):1209 Concurrency Control and Recovery in Database Systems (context) - Bernstein, Hadzilacos et al. - 1987
901 Transaction Processing: Concepts and Techniques (context) - Gray, Reuter - 1993
434 An Introduction to Database Systems (context) - Date - 1990
323 The Notions of Consistency and Predicate Locks in a Database.. (context) - Eswaran, Gray et al. - 1978
150 Understanding The New SQL: A Complete Guide (context) - Melton, Simon - 1993
102 Granularity of Locks and Degrees of Consistency in a Shared .. (context) - Gray, Lorie et al. - 1977
92 The Theory of Database Concurrency Control (context) - Papadimitriou - 1986
83 The Design of the POSTGRES Storage System - Stonebraker - 1994
50 Implementing Atomic Actions On Decentralized Data (context) - Reed - 1981
12 Illustra User's Guide (context) - Technologies - 1994
9 A Guide to DB2 (context) - Date, White - 1989
9 Database: Principles (context) - O'Neil - 1994
3 Rdb/VMS, A Comprehensive Guide (context) - Hobbs, England - 1991
3 A Theoretical Formulation for Degrees of Isolation in Databa.. - Atluri, Bertino et al. - 1995
2 Oracle Corp (context) - SQL, Reference et al. - 1989
2 Transaction Models in InterBase 4 (context) - Thakur - 1994
1 An Investigation of Transactional Isolation Levels (context) - O'Neil, O'Neil et al.
The graph only includes citing articles where the year of publication is known.
Documents on the same site (http://research.microsoft.com/~Gray/JimGrayPublications.htm): More
Unknown - (2002) (Correct)
A Quick Look at Serial ATA (SATA) Disk Performance - Barclay, Chong, Gray (2003) (Correct)
A "Measure of Transaction Processing" 20 Years Later - Gray (2005) (Correct)
Online articles have much greater impact More about CiteSeer.IST Add search form to your site Submit documents Feedback
CiteSeer.IST - Copyright Penn State and NEC