Contents

Concurrency Control Techniques
Locking Method
Types of a Locke
Locking - Basic Rules
Mandatory Access Control
Discretionary Access Control (DAC) ............

Concurrency Control Techniques

January 8, 2020

Concurrency Control is the process of managing simultaneous operations on the database without having them interfere with one another. Prevents interference when two or more users are accessing database simultaneously and at least one is updating data.
Three basic concurrency control techniques:
Locking methods
Time stamping
Optimistic
Locking and Time stamping are pessimistic approaches since they delay transactions. The optimistic approach allows us to proceed and check conflicts at the end. Optimistic methods assume conflict is rare and only check for conflicts at commit.

Download the Slide To get The Full Content