Given the following details from a log file that survived a crash. Assuming that a log-based...

Transcribed Image Text:

Given the following details from a log file that survived a crash. Assuming that a log-based recovery scheme is in place with checkpointing, answer the questions below. <T1 start> <A, T1, 1000,0> <B, T1,500, 1500> <T1 commits> <T2 starts> <C, T2,750,650> <checkpoint> <T2 commits> <T3 starts> Questions: EX ce E ice (a) (7 marks) What is the concept of a deferred update recovery technique? Try to limit your answer to under 100 words. (b) (8 marks) With an immediate database modification strategy in place, which transactions should be redone and which transactions should be undone? (c) (5 marks) Assuming A, B, C all started at 300 before these T1 started, what would the final values of A, B, and C be after the recovery has been performed? Explain what happens in the recovery process to get to those values (you can refer to your previous answers in this question). Given the following details from a log file that survived a crash. Assuming that a log-based recovery scheme is in place with checkpointing, answer the questions below. <T1 start> <A, T1, 1000,0> <B, T1,500, 1500> <T1 commits> <T2 starts> <C, T2,750,650> <checkpoint> <T2 commits> <T3 starts> Questions: EX ce E ice (a) (7 marks) What is the concept of a deferred update recovery technique? Try to limit your answer to under 100 words. (b) (8 marks) With an immediate database modification strategy in place, which transactions should be redone and which transactions should be undone? (c) (5 marks) Assuming A, B, C all started at 300 before these T1 started, what would the final values of A, B, and C be after the recovery has been performed? Explain what happens in the recovery process to get to those values (you can refer to your previous answers in this question). Given the following details from a log file that survived a crash. Assuming that a log-based recovery scheme is in place with checkpointing, answer the questions below. <T1 start> <A, T1, 1000,0> <B, T1,500, 1500> <T1 commits> <T2 starts> <C, T2,750,650> <checkpoint> <T2 commits> <T3 starts> Questions: EX ce E ice (a) (7 marks) What is the concept of a deferred update recovery technique? Try to limit your answer to under 100 words. (b) (8 marks) With an immediate database modification strategy in place, which transactions should be redone and which transactions should be undone? (c) (5 marks) Assuming A, B, C all started at 300 before these T1 started, what would the final values of A, B, and C be after the recovery has been performed? Explain what happens in the recovery process to get to those values (you can refer to your previous answers in this question). Given the following details from a log file that survived a crash. Assuming that a log-based recovery scheme is in place with checkpointing, answer the questions below. <T1 start> <A, T1, 1000,0> <B, T1,500, 1500> <T1 commits> <T2 starts> <C, T2,750,650> <checkpoint> <T2 commits> <T3 starts> Questions: EX ce E ice (a) (7 marks) What is the concept of a deferred update recovery technique? Try to limit your answer to under 100 words. (b) (8 marks) With an immediate database modification strategy in place, which transactions should be redone and which transactions should be undone? (c) (5 marks) Assuming A, B, C all started at 300 before these T1 started, what would the final values of A, B, and C be after the recovery has been performed? Explain what happens in the recovery process to get to those values (you can refer to your previous answers in this question).

Answer rating: 100% (QA)

a A deferred update recovery technique defers the updates of a transaction in the log until after th... View the full answer