Question
Does the following partial schedule S obey two phase locking? If it does not, change it to obey two phase locking. T1 T2 Lock-X(B) Read(B)
Does the following partial schedule S obey two phase locking? If it does not, change it to obey two phase locking.
| T1 | T2 |
| Lock-X(B) |
|
| Read(B) |
|
| Write (B) |
|
| Lock-X(A) |
|
|
| Lock-S(A) |
|
| Read(A) |
|
| Unlock(A) |
|
| Lock-S(B) |
|
| Read(B) |
|
| Unlock(B) |
| Unlock(B) |
|
| Read(A) |
|
| Write(A) |
|
| Unlock(A) |
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Database Processing
Authors: David J. Auer David M. Kroenke
13th Edition
B01366W6DS, 978-0133058352
