Concurrency control techniques, lock types (Shared vs Exclusive), Two-Phase Locking protocol (Growing & Shrinking), Strict 2PL, and deadlock handling.
Concurrency Control, Two-Phase Locking (2PL) & Deadlocks 1. Lock-Based Protocols & Lock Modes Locks control concurrent access to database items: Shared Lock (S-Lock / Read Lock): Acquired before reading. Multiple transactions can hold shared locks on the same data item simultaneously. Exclusive Lock (X-Lock / Write Lock): Acquired before writing. Only one transaction can hold an exclusive...…
Upgrade to Unlock