Grokking Database Fundamentals for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content

On this page

What is Lock-Based Concurrency Control?

Why Use Locks?

Types of Locks

  1. Shared Lock (S-Lock)
  1. Exclusive Lock (X-Lock)
  1. Intention Locks

Lock Granularity

  1. Row-Level Lock
  1. Page-Level Lock
  1. Table-Level Lock

Locking Protocols

  1. Two-Phase Locking (2PL)
  1. Predicate Locking
  1. Index-Range Locking

Comparison of Locking Strategies