Concurrency Control 편집하기 (부분)

==Techniques for Concurrency Control==
The following techniques are commonly used for concurrency control:
{| class="wikitable"
!Technique!!Description!!Advantages!!Limitations
|-
|'''Lock-Based Protocols'''||Transactions acquire locks on data items to control access.||Prevents conflicts, widely used.||Can lead to deadlocks, reduced concurrency.
|-
|'''Timestamp-Based Protocols'''||Assigns timestamps to transactions to enforce serializability.||No locks, avoids deadlocks.||Requires global timestamp management.
|-
|'''Optimistic Concurrency Control'''||Validates transactions at commit time to ensure no conflicts.||High performance in low-contention systems.||Rollbacks can be expensive in high-contention systems.
|-
|'''Multiversion Concurrency Control (MVCC)'''||Maintains multiple versions of data to provide consistent snapshots.||Supports high concurrency, avoids read-write conflicts.||Storage overhead due to multiple versions.
|}