Multiple granularities of database locks

Multiple granularity locking To understand this concept, first let us take a look at the structure of a database. It can be represented by the following hierarchy. Now, whenever we explicitly apply a lock at any level, all the children nodes are imp...