A Critique of ANSI SQL Isolation Levels

最新推荐文章于 2021-11-08 11:17:52 发布

weixin_30294295

最新推荐文章于 2021-11-08 11:17:52 发布

阅读量119

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/simplefrog/archive/2012/07/14/2591868.html

本文探讨了ANSI SQL定义的隔离级别在实现过程中存在的问题，指出其未能充分描述多种流行隔离级别，包括标准锁定实现的隔离级别。通过研究现有现象的模糊性，提出了更清晰的定义，并引入了更好地描述隔离类型的新型现象。文中定义了一种重要的多版本隔离类型——快照隔离。

Hal Berenson, Phil Bernstein, Jim Gray, Jim Melton, Elizabeth O'Neil, and Patrick O'Neil
June 1995

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; in addition new phenomena that better characterize isolation types are introduced. An important multiversion isolation type, Snapshot Isolation, is defined.

全文下载 A_Critique_of_ANSI_SQL_Isolation_Levels.pdf

转载于:https://www.cnblogs.com/simplefrog/archive/2012/07/14/2591868.html