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, multiplegranularity 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 T needs to read object p What locks on which nodes does it need to acquire? For each lock, specify if it will be granted.
Suppose Transaction T needs to read p and write object r instead. What locks on which nodes does it need to acquire? For each lock, specify if it will be granted.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
