All Notes

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

Read-Committed Isolation prevents dirty reads and dirty writes

Isolation
Read Committed Isolation
Dirty Read
Dirty Write

Database Indexes need to be optimized to support MVCC

Multi-version Concurrency Control
Snapshot Isolation

Relationships decide the best data model fit

Relational Data Model

Tracks

© 2022 Ambitious Systems. All Rights Reserved.