Question: Consider transaction T 1 that sets x = 0 and y = 1 and transaction T 2 that sets x = 2 and y =

Consider transaction T1 that sets x=0 and y =1 and transaction T2 that sets x=2 and y=3. T1 runs first and after recording its intentions in the REDO write-ahead log commits.Then T2 runs and writes its intentions to the log but a crash occurs before T2 writes its commit record to the log. Consider two cases. In one case, the part of the log containing intentions of T1 was garbage collected before the crash. In the second case, the log garbage collection did not run yet after T1 committed. Explain what will be the state of x and y on disk after recovery in each case?

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