Pessimistic Concurrency Control (PCC)

In this lesson, we will explore the 2-phase locking, a pessimistic concurrency control protocol.

We'll cover the following

2-Phase locking (2PL)

Types of locks

Interaction between write (exclusive) locks and read (shared) locks
Phases where transactions acquire or release locks

Expanding phase
Shrinking phase

Deadlocks

Ways to deal with deadlocks

Prevention
Detection

Get hands-on with 1300+ tech skills courses.