Question: Please answer this. 3) (20 pts) Consider the following lock requests in the table below Here, S( and X) stand for Shared Lock' and 'Exclusive

 Please answer this. 3) (20 pts) Consider the following lock requests

Please answer this.

3) (20 pts) Consider the following lock requests in the table below Here, S( and X) stand for Shared Lock' and 'Exclusive Lock', respectively. TI, T2, and T3 represent three transactions. LM stands for 'lock manager' and Transactions will never release a granted lock. to t7 ts S(B)S(C) t3 tA time ti T, S( A) 12 T3 LMg S(B) X(C) X(B) X(A) For the lock requests in above table, decide which lock will be granted or blocked by LM. Write g' in the LM row to indicate the lock is granted and 'b' to indicate that the lock is blocked (the lock acquisition fails). For example, in the table, the first lock (S(A) at time t) is marked as granted with g'. Moreover, show your rtustify your

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 Databases Questions!