ng sequence of 'logs' fror timeline and add logs to r

Database Systems: Design, Implementation, & Management
11th Edition
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter10: Transaction Management And Concurrency Control
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
Database Recovery System
1. Consider the following sequence of 'logs' from transactions A, B, C and D. Represent
transactions on the timeline and add logs to recovery. Complete the table and justify
your answer.
Redo Phase
Undo Phase
| Log
Start T1
Read T1, D
| Checkpoint
Write T1, D, 20, 25
Commit T1
Start T2
Read T2, B
Start, T3
Write T2, B, 12, 18
Commit T2
Read T3, D
Write T3, D, 25, 15
System crash -
Transcribed Image Text:Database Recovery System 1. Consider the following sequence of 'logs' from transactions A, B, C and D. Represent transactions on the timeline and add logs to recovery. Complete the table and justify your answer. Redo Phase Undo Phase | Log Start T1 Read T1, D | Checkpoint Write T1, D, 20, 25 Commit T1 Start T2 Read T2, B Start, T3 Write T2, B, 12, 18 Commit T2 Read T3, D Write T3, D, 25, 15 System crash -
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Binary Search Algorithm
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning