Question: uestion 2 ( 1 4 marks ) Consider the log in Question 1 . ( 1 ) How the durability of the committed T 1

uestion 2(14 marks) Consider the log in Question 1.(1) How the durability of the committed T1 and the atomicity of the uncommitted T2 are enforced after the crash? (2) What are the TT and DPT saved by Checkpoint? (3) What are the TT and DPT just before crash? (4) What are the TT and DPT reconstructed by Analysis Phase? Explain any differences between (3) and (4), if any. (5) Where does the redo phase start? (6) What transactions will be undone? (7) Which portion of the log will be scanned by Analysis phase? How does the recovery manager know this?

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!