Locking

Problem

Two transactions want to modify the same data simultaneously. Allowing both uncontrolled access could produce inconsistent results.

Solution — Locks

The database can temporarily restrict access to a resource.
Transaction A → LOCK row 42
Transaction B → wait
A commits
B continues
Core idea: locking coordinates concurrent access by temporarily restricting conflicting operations.