Concurrency Control in DBMS
📘 DBMS
👁 76 views
📅 Nov 14, 2025
⏱ Estimated reading time: 1 min
What is Concurrency Control?
Concurrency control ensures that multiple transactions can run simultaneously without causing data inconsistency or conflicts.
Why Concurrency Control?
- To avoid lost updates
- To maintain database consistency
- To avoid temporary inconsistency
- To ensure isolation
Concurrency Problems
- Lost Update: Two transactions overwrite each other’s changes.
- Dirty Read: Reading uncommitted data.
- Unrepeatable Read: Data changes between reads.
- Phantom Read: New rows appear during a transaction.
Concurrency Control Techniques
- Locking Mechanisms: Shared & exclusive locks
- Two-Phase Locking (2PL): Growing & shrinking phases
- Timestamp Ordering
- Validation-Based Protocols
🔒 Some advanced sections are available for Registered Members
Register Now
Register Now
Share this Post
← Back to Tutorials