Tag: "Lost Updates"

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

Write Skew
Lost Updates
Atomic Writes
Materializing Conflicts
Serializable Isolation

Atomic Write operations prevent Lost Updates

Lost Updates
Atomic Writes

Databases that automatically detect lost updates simplify application code

Lost Updates
Snapshot Isolation

Databases without transaction support can avoid lost updates with compare-and-set operations

Lost Updates
Compare-and-Set

Applications can use Explicit Locks to prevent Lost Updates

Explicit Locks
Lost Updates

Read committed and Snapshot isolations do not prevent Lost Updates

Lost Updates

Locks and atomic operations do not work with replicated databases

Lost Updates
© 2022 Ambitious Systems. All Rights Reserved.