In this 55 mins Video Lesson
Introduction,
Lock Based Protocols,
Starvation,
Desdlocks,
2 Phase Locking Protocol,
Strict 2PL,
Rogorous 2PL,
Lock Conversion Based Protocol,
and other topics.
In this 46 mins Video Lesson
Timestamp based Protocols,
Timestamp Ordering protocol,
Thomas' Write Rule,
Optimistic/ Validation Based Protocols,
Multiversion Scheme,
and other topics.
In this 38 mins Video Lesson
DeadLocks,
Deadlock Prevention,
Preemtion/ Rollback Scheme,
Wait-Die Scheme,
Wound-Wait Scheme,
Deadlock Detection,
Deadlock Recovery,
Selection of Victim,
Rollbacks,
and other topics.
In this 45 mins Video Lesson
Introduction,
Types of Failures,
Log Based Recovery,
Deferred Database Modification,
Immediate Database Modification,
and other topics.
Concurrency Control: Need, Locking Methods, Deadlocks, Timestamping Methods, Optimistic Techniques, Multi-Version Concurrency Control, Different Crash Recovery methods such as Shadow-Paging and Log-Based Recovery: Deferred and Immediate, Checkpoints