Question: For better current execution, multiple - granularity locking ( MGL ) introduces three new types of locks, IS , IX , and SIX. Consider the

For better current execution, multiple-granularity locking (MGL) introduces three new types of locks, IS, IX, and SIX. Consider the following tree of objects, where each node contains all its children. Note that some nodes have been locked by other transactions and the types of locks are given nearby.
Suppose Transaction T1 needs to read object p1. What lock(s) on which node(s) does it need to acquire? For each lock, specify if it will be granted.
Suppose Transaction T1 needs to read p3 and write object r6 instead. What lock(s) on which node(s) does it need to acquire? For each lock, specify if it will be granted.
For better current execution, multiple -

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!