Question: Given the schedule below, complete the recovery log to match the schedule. T read X X=X+7 Schedule write X Y=Y/5 write Y save main
Given the schedule below, complete the recovery log to match the schedule. T read X X=X+7 Schedule write X Y=Y/5 write Y save main memory rollback commit Check T2 read Y Next Recovery Log start T2 start T update T2. YID. Yoriginal. Ynew (A) (B) rollback T (C) commit T (A) Pick (B) Pick (C Pick checkpoint T, T undo T, XID, Xoriginal undo T, YID, Yoriginal update T, XID, Xoriginal, Xnew update T, YID, Yoriginal, Ynew
Step by Step Solution
There are 3 Steps involved in it
Youve provided an image of a database transaction schedule involving two transactions T1 and T2 along with an incomplete recovery log that needs to be ... View full answer
Get step-by-step solutions from verified subject matter experts
