A Critique of ANSI SQL Isolation Levels | the morning paper

the morning paper a random walk through Computer Science research, by Adrian Colyer Made delightfully fast by strattic A Critique of ANSI SQL Isolation Levels – Berenson et al. 1995 udpate: 2 minor corrections in the section on A5A per the comment from ‘banks’ – thanks! The ANSI SQL isolation levels were originally defined in prose, in terms of three specific anomalies that they were designed to p

[tgk]

dirty writeなhistoryがなぜserializableではないとされているか。T1がx=1, y=1をwriteし、T2がx=2, y=2をwriteするとき、結果がx=1, y=2になるかもしれないから。特にx=yの制約が付いているなら、この結果はエラーになる

[taroleo]

僕が学生のころにこのまとめがあればもっとすんなりこの論文を読めた気がする