<START T> <T, A, 10> <START U> <U, B, 20> <T, C, 30> <U, D, 40> <C0MMIT U> <T, E, 50> <C0MMIT T> |
Describe the action of the recovery manager by stating which database elments will be updated with which value if there is a crash and the last log record to appear on disk is:
|
<START S> <-------- Go back till here <S, A ,60> <START CHKT(S)> <C0MMIT S> <END CHKT> <START T> <T, A , 10> <START U> <U, B, 20> <T, C, 30> <START V> <U, D, 40> <V, F, 70> <C0MMIT U> <T ,E , 50> <C0MMIT T> <V ,B , 80> |
Questions:
|
<START S> <S, A ,60> <C0MMIT S> <START T> <-------- Go back till here <T, A , 10> <START CHKT(T)> <START U> <U, B, 20> <T, C, 30> <START V> <U, D, 40> <V, F, 70> <C0MMIT U> <T ,E , 50> <C0MMIT T> <END CHKT> <V ,B , 80> |
Questions:
|
<START S> <S, A ,60> <C0MMIT S> <START T> <-------- Go back till here <T, A , 10> <START U> <U, B, 20> <START CHKT(T,U)> <T, C, 30> <START V> <U, D, 40> <V, F, 70> <C0MMIT U> <T ,E , 50> <C0MMIT T> <END CHKT> <V ,B , 80> |
Questions:
|
<START S> <S, A ,60> <C0MMIT S> <START T> <-------- Go back till here <T, A , 10> <START U> <U, B, 20> <T, C, 30> <START V> <U, D, 40> <V, F, 70> <C0MMIT U> <START CHKT(T,V)> <T ,E , 50> <C0MMIT T> <V ,B , 80> ---- Check point did not finish !!! |
Questions:
|
<START T> <T, A, 10> <START U> <U, B, 20> <T, C, 30> <U, D, 40> <C0MMIT U> <T, E, 50> <C0MMIT T> |
Describe the action of the recovery manager by stating which database elments will be updated with which value if there is a crash and the last log record to appear on disk is:
|
<START S> <------ A <S, A ,60> <START CHKT(S)> <C0MMIT S> <START T> <T, A , 10> <START U> <U, B, 20> <END CHKT> <T, C, 30> <START V> <U, D, 40> <V, F, 70> <C0MMIT U> <T ,E , 50> |
Questions:
|
<START S> <S, A ,60> <C0MMIT S> <START T> <---------- A <T, A , 10> <START CHKT(T)> <START U> <U, B, 20> <T, C, 30> <START V> <U, D, 40> <V, F, 70> <C0MMIT U> <T ,E , 50> <END CHKT> <C0MMIT T> <V ,B , 80> |
Questions:
|
<START S> <S, A ,60> <C0MMIT S> <START T> <------- A <T, A , 10> <START U> <U, B, 20> <START CHKT(T,U)> <T, C, 30> <START V> <U, D, 40> <V, F, 70> <C0MMIT U> <T ,E , 50> <C0MMIT T> <END CHKT> <V ,B , 80> |
Questions:
|
<START S> <S, A ,60> <C0MMIT S> <START T> <------- A <T, A , 10> <START U> <U, B, 20> <T, C, 30> <START V> <U, D, 40> <V, F, 70> <C0MMIT U> <START CHKT(T,V)> <T ,E , 50> <C0MMIT T> <V ,B , 80> <END CHKT> |
Questions:
|
<START T> <T, A, 10, 11> <START U> <U, B, 20, 21> <T, C, 30, 31> <U, D, 40, 41> <C0MMIT U> <T, E, 50, 51> <C0MMIT T> |
Describe the action of the recovery manager by stating which database elments will be updated with which value if there is a crash and the last log record to appear on disk is:
|
<START S> <S, X ,60, 61> <START CHKT(S)> <---- A <C0MMIT S> <START T> <T, A, 10, 11> <START U> <U, B, 20, 21> <END CHKT> <T, C, 30, 31> <START V> <U, D, 40, 41> <V, F, 70> <C0MMIT U> <T ,E, 50, 51> |
Questions:
|
<START S> <S, X, 60, 61> <C0MMIT S> <START T> <T, A ,10, 11> <START CHKT(T)> <------ A <START U> <U, B, 20, 21> <T, C, 30, 31> <START V> <U, D, 40, 41> <V, F, 70, 71> <C0MMIT U> <T, E, 50, 51> <END CHKT> <C0MMIT T> <V ,Y, 80, 81> |
Questions:
|
<START S> <S, X, 60, 61> <C0MMIT S> <START T> <T, A, 10, 11> <START U> <U, B, 20, 21> <START CHKT(T,U)> <------ A <T, C, 30, 31> <START V> <U, D, 40, 41> <V, F, 70, 71> <C0MMIT U> <T, E, 50, 51> <C0MMIT T> <END CHKT> <V, Y, 80, 81> |
Questions:
|
<START S> <S, X, 60, 61> <C0MMIT S> <START T> <T, A, 10, 11> <START U> <U, B, 20, 21> <T, C, 30, 31> <START V> <U, D, 40, 41> <V, F, 70, 71> <C0MMIT U> <START CHKT(T,V)> <------ A <T, E, 50, 51> <C0MMIT T> <V, Y, 80, 81> <END CHKT> |
Questions:
|