db笔记 - 事务1:隔离级别

锁

read lock write lock long duration lock short duration lock

predicate lock

history

SQL-92 –> SQL-95:

an overview of isolation degree

• P0(Dirty Write)

• Read Uncommited

• P1(Dirty Read)

• Read Commited

• P4C(Lost Update of Cursor)

• Cursor Stability

• P4(Lost Update)

• P2(Non-Repeatable Read)

• Repeatable Read

• P3(Phantom)

• Serializable

• Snapshot Isolation(Sql-95)

• Serializable Snapshot Isolation（SSI-08)

读写偏序问题（Read/Write Skew）

References

• A Critique of ANSI SQL Isolation Levels 阅读笔记
• Sql-95:A Critique of ANSI SQL Isolation Levels
• DB2 隔离级别
• 再谈数据库事务隔离性
• [SSI-08] Michael J. Cahill, Uwe Röhm, and Alan D.Fekete. 2008. Serializable isolation for snapshot databases. In SIGMOD ’08:Proceedings of the 2008 ACM SIGMOD international conference on Management of data, pages 729–738, New York, NY, USA. ACM.