Logo
Pattern

Discover published sets by community

Explore tens of thousands of sets crafted by our community.

Database Locking Mechanisms

8

Flashcards

0/8

Still learning
StarStarStarStar

Two-Phase Locking (2PL)

StarStarStarStar

Guarantees serializability by acquiring all locks before any are released. Use for maintaining transaction consistency.

StarStarStarStar

Time Stamp Ordering

StarStarStarStar

Assigns timestamps to ensure transactions are processed in a certain order. Use to avoid serialization anomalies.

StarStarStarStar

Serializable Isolation

StarStarStarStar

Ensures transactions execute with the same effect as if they were executed serially. Use when absolute consistency is necessary.

StarStarStarStar

Pessimistic Locking

StarStarStarStar

Locks data when a transaction begins to prevent concurrent modifications. Use when high contention is expected.

StarStarStarStar

Read Committed Isolation

StarStarStarStar

Allows reading only committed data, preventing dirty reads. Use this in databases where reading uncommitted data is not acceptable.

StarStarStarStar

Multiple Granularity

StarStarStarStar

Allows transactions to lock resources at various levels of granularity. Use for efficiency when transactions need various types of access to data.

StarStarStarStar

Deadlock Detection

StarStarStarStar

Algorithm to identify deadlocks. Use when deadlock prevention is not feasible or practical.

StarStarStarStar

Optimistic Locking

StarStarStarStar

Assumes multiple transactions can complete without affecting each other, and checks at commit time. Use when read operations are more common than writes.

Know
0
Still learning
Click to flip
Know
0
Logo

© Hypatia.Tech. 2024 All rights reserved.