4 ms·
Is there a consensus / standard on the wording of the "consistency level" and "system guarantee"? https://dbmsmusings.blogspot.com/2019/06/correctness-anomali
by alijimin 4y ago
Is there a consensus / standard on the wording of the
"consistency level" and "system guarantee"?
https://dbmsmusings.blogspot.com/2019/06/correctness-anomalies-under.html https://dbmsmusings.blogspot.com/2019/06/correctness-anomali...
Classification of serializable systems
* (consistency level)
READ UNCOMMITTED (ISO)
READ COMMITTED (ISO)
REPEATABLE READ (ISO)
SNAPSHOT ISOLATION
SERIALIZABLE (ISO)
ONE COPY SERIALIZABLE
STRONG SESSION SERIALIZABLE
STRONG WRITE SERIALIZABLE
STRONG PARTITION SERIALIZABLE
STRICT SERIALIZABLE
* System Guarantee
Dirty read (ISO)
Non-repeatable read (ISO)
Phantom Read (ISO)
Write Skew
Immortal write
Stale read
Causal reverse