All Notes

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

Data persistence process is prone to errors

Transactions

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

Write Skews can be avoided by Materializing Conflicts

Write Skew

Materializing Conflicts

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

Write Skew

Lost Updates

Atomic Writes

Materializing Conflicts

Serializable Isolation

← Newer Older →