Concurrency Control

Why Concurrency Control is required? Formal Concepts Serial, realizable, equivalent schedules 4 invalid schedules Concurrency control – a DBMS component Isolation levels ANSI SQL isolation levels Snapshot Isolation Locking Basics Deadlocks Index locking Optimistic locking Multi-Version Concurrency Control