Degrees of Isolation (cont’d)
Could run queries Degree 2 and updaters Degree 3
- Updaters are still serializable w.r.t. each other
Degree 1 - no read locks; hold write locks to commit
Unfortunately, SQL concurrency control standards have been stated in terms of “repeatable reads” and “cursor stability” instead of serializability, leading to much confusion.