reset password
Author Message
jpascua
Posts: 197
Posted 18:06 Nov 26, 2015 |

For number 3, do we choose where to place the crash? For instance:

Start Transaction
<START, T>
Write(X, vx')
Flush(X);
<UPDATE, T, X, vx, vx'>
Write(Y, vy’)

---> Crash

Flush(Y)
<UPDATE, T, Y, vy, vy'>
Commit;
<COMMIT, T>
Flush(log);

 

And determine whether the DBMS can recover using Undo-Only Recovery?

 

 

cysun
Posts: 2935
Posted 09:33 Nov 27, 2015 |

That's not how you determine whether it's recoverable or not as a crash can happen anywhere.