- [[ANSI SQL]]における[[Isolation|トランザクション分離レベル]]の曖昧さを指摘し、フォーマルな定義を与えた論文 - 後半では[[Snapshot isolation]]を提案している # 書誌情報 - **タイトル**: A Critique of ANSI SQL Isolation Levels - **著者**: Hal Berenson, Phil Bernstein, Jim Gray, Jim Melton, Elizabeth O'Neil, Patrick O'Neil - **出版年**: 1995 - **ジャーナル・カンファレンス**: [[SIGMOD]] - **Abstract**: ANSI SQL-92 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 properly characterize several popular isolation levels, including the standard locking 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. # 参考 - [トランザクション分離レベルの古典的論文 A Critique of ANSI SQL Isolation Levels を読む - Hatena Developer Blog](https://developer.hatenastaff.com/entry/2017/06/21/100000)