Generalized Isolation Level Definitions (2000) [27 citations — 0 self]
http://research.microsoft.com/~adya/pubs/icde00.pd
http://www.pmg.lcs.mit.edu/~adya/pubs/published.ps
http://pmg.csail.mit.edu/papers/icde00.ps.gz
DBLP
CACHED:
|
Popular Tags
No tags have been applied to this document.
BibTeX | Add To MetaCart
author = {Atul Adya and Barbara Liskov and Patrick O'Neil},
title = {Generalized Isolation Level Definitions},
booktitle = {In ICDE},
year = {2000},
pages = {67--78}
}
Years of Citing Articles
Bookmarks
OpenURL
Abstract:
Commercial databases support different isolation levels to allow programmers to trade off consistency for a potential gain in performance. The isolation levels are defined in the current ANSI standard, but the definitions are ambiguous and revised definitions proposed to correct the problem are too constrained since they allow only pessimistic (locking) implementations. This paper presents new specifications for the ANSI levels. Our specifications are portable; they apply not only to locking implementations, but also to optimistic and multi-version concurrency control schemes. Furthermore, unlike earlier definitions, our new specifications handle predicates in a correct and flexible manner at all levels. 1. Introduction This paper gives new, precise definitions of the ANSISQL isolation levels [6]. Unlike previous proposals [13, 6, 8], the new definitions are both correct (they rule out all bad histories) and implementation-independent. Our specifications allow a wide range of concurr...
