Aries Analysis #4

Consider the execution of the ARIES recovery algorithm given the following For the questions below, when you are asked which log records are read, you are to supply the exact list of LSNs from log above. When data pages are asked for, you are to supply the exact list of page identifiers from the log above. And so on. Be specific and concrete in your answers, answering specifically for the provided log. a) What log records are read? b) What are the contents of the Dirty Page Table (DPT) and the transaction table at the end of the analysis stage? During Redo: a) What log records are read? b) What data pages are read? c) What operations are redone? (Assume no updates made it out to disk before the crash, except updates written to disk us part of a transaction commit.) During Undo: a) What log records are read? b) What operation are undone? Consider the execution of the ARIES recovery algorithm given the following For the questions below, when you are asked which log records are read, you are to supply the exact list of LSNs from log above. When data pages are asked for, you are to supply the exact list of page identifiers from the log above. And so on. Be specific and concrete in your answers, answering specifically for the provided log. a) What log records are read? b) What are the contents of the Dirty Page Table (DPT) and the transaction table at the end of the analysis stage? During Redo: a) What log records are read? b) What data pages are read? c) What operations are redone? (Assume no updates made it out to disk before the crash, except updates written to disk us part of a transaction commit.) During Undo: a) What log records are read? b) What operation are undone