Tag: "Serializable Isolation"

Stored Procedures improve throughput by removing interactivity

Serializable Isolation
Serial Execution
Stored Procedure

True serializability imposes system constraints

Serializable Isolation
Serial Execution
Partitioning

Index range locks are more performant than Predicate Locks

Serializable Isolation
Predicate Lock
Index-range Lock

Use Predicate Locks to eliminate write skews

Two-phase locking
Serializable Isolation
Write Skew

Two-phase Locking does not scale well

Two-phase locking
Serializable Isolation

Two-phase locking improves on Explicit Locks

Two-phase locking
Explicit Locks
Serializable Isolation

Applications using two-phase locking cannot scale well

Two-phase locking
Transactions
Serializable Isolation

Serializable Isolation is the only way to prevent all write-related race conditions

Write Skew
Lost Updates
Atomic Writes
Materializing Conflicts
Serializable Isolation

Most databases do not support true Isolation

Isolation
Serializable Isolation
© 2022 Ambitious Systems. All Rights Reserved.