in practice? the conservative 2P pr , LO8N Question 7. (15 marks) Consider the e
ID: 3753901 • Letter: I
Question
in practice? the conservative 2P pr , LO8N Question 7. (15 marks) Consider the execu LSN prev LSNI trans ID ution shown in the following log exec age ID undonextLSN 10 type begin checkpoint end checkpoint update update update commit end update update abort 20 30 PI P2 P3 40 T1 50 TI T1 T2 T2 60 70 30 60 80 90 100 PI P4 50 80 1 10 120 130 XCrash, Restart 140 150 160 Please answer the following questions: (I) (3 marks) What are the roles of the Analysis (2) (6 marks) Fill the following 1a time.(you will assume that the were empty record.) ARIES? , Redo, and Undo phases in ng Dirty Page Table and Transaction Table at the cras two tables were empty in the most recent begin_checkpoin Transaction Table TranID lastLSN Dirty Page Table pageID recLSN (3) (6 marks) Fill the log tail when the recovery is complete.Explanation / Answer
1Q) ARIES: (Roles of Analysis,Redo and Undo phases)
The most development and most troublesome recuperation calculation ARIES recuperation calculation.The benefit of this recuperation procedure is that it lessnes recuperation time and in addition overhead of a log.
Analysis phase:
Redo phase:
Undo Phase:
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.