Concurrency Control in Database Systems

Concurrency Control in Database Systems

#dbms

Articles tagged with #dbms

Two Phase Locking
In our previous blog post, we discussed the problems related to concurrency control in database management systems. Now, we will explore a solution to these problems using the two-phase locking protocol. This technique helps prevent conflicting trans...
May 11, 20238 min read310
Concurrency Problems in Database Systems
Before beginning, it's important to introduce some abbreviations that will be used: R(A): This refers to reading the value of A from the database. W(A): This refers to writing or updating the value of A with a new value. What is Concurrency? It's...
May 2, 20235 min read168