Two distributed transactions execute at the same two sites. Each site uses a strict two-phase locking concurrency control, and the entire system uses a two-phase commit protocol. Give a schedule for the execution of these transactions in which the commit order is different at each site but the global schedule is serializable.
What will be an ideal response?
Site 1: w1(x) Commit1 w2(y) Commit2
Site 2: w1(a) w2(b) Commit2 Commit1
It takes a long time for the commit message for transaction 1 to get to Site 2
Computer Science & Information Technology
You might also like to view...
The ____ property indicates how light reflects from the object.
A. Mirror B. Luminosity C. Paint D. Opacity
Computer Science & Information Technology
Which of these support management concerns directly affects the support staff's job?
A. The support mission statement B. Support performance measures C. Staffing the support group D. All of these
Computer Science & Information Technology