Lesson 8 of 15 • 9 upvotes • 14:32mins
In this lesson you will learn about Two phase locking protocol, it's variation and pros-cons. Also, we will see how we can solve lost update and uncommitted dependency problem using 2PL
15 lessons • 2h 36m
Overview
6:06mins
Transactions and their Properties
12:04mins
Schedules
13:44mins
Serializability
11:57mins
Conflict Serializability Test
14:27mins
View Serializability Test
11:50mins
Lock Based Protocols
7:15mins
Two Phase Locking Protocol
14:32mins
Deadlock Detection
11:40mins
Deadlock Prevention
9:21mins
Deadlock Recovery
7:37mins
Timestamp Ordering Protocol
9:14mins
Thomas Write Rule
8:26mins
Optimistic Concurrency Control
11:14mins
GATE Questions related to Concurrency control
6:25mins