Site icon i2tutorials

DBMS- Types of Intention Mode Locks

Types of Intention Mode Locks

 

An intention lock is something when a lower granularity object needs a lock and then the lock manager places a lock on the higher granularity object.

 

There are three types of Intention-mode locks:

 

 The Compatibility-Function for these lock modes is :

 

SXISIXSIX
STTTTF
XTTFFF
ISTFTFF
IXTFFFF
SIXFFFFF

 

Here,

S = Shared Lock

X =Exclusive Lock

IS = Intention_shared Lock

IX = Intention-Shared lock

SIX =Shared and Intention-Exclusive

And, 

T = true

F = false.

 

The above is said to be the ‘Lock-Compatibility Matrix’.

 

Reference link

Types of Intention Mode Locks

Exit mobile version