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
You might also like to view...
By exchanging the data in RAM with the data in ____, your computer effectively gains almost unlimited memory capacity.
A. the buffer B. cache C. virtual memory D. SDRAM
Cloud computing requires less bandwidth than traditional client/server networks.
Answer the following statement true (T) or false (F)
The Open dialog box uses file names to filter the list of files so that it displays only those files that can be opened using the current application.
Answer the following statement true (T) or false (F)
Match font effect with its definition
I. Embossed A. text flashes on and off II. Engraved B. text does not display on screen or when printed III. Blinking C. text displays with a 3-d shadow effect IV. Hidden D. text displays as if it had been pressed down into the page V. Shadow E. text displays as if it had been raised from the page