Assume that transactions containing the following operations are executed on a database: Transaction Log LSN Transaction Operation
Fantastic news! We've Found the answer you've been seeking!
Question:
Assume that transactions containing the following operations are executed on a database:
Transaction Log | ||
LSN | Transaction | Operation |
10 | T1 | Update P20 |
20 | T3 | Update P30 |
30 | T2 | Update P40 |
40 | T1 | Update P30 |
50 | T2 | Commit |
60 | T3 | Update P40 |
CRASH! |
Using the ARIES recovery algorithm, create the Transaction Log, Dirty Page Table, and Transaction Table.
Dirty Page Table | |
Page | RecLSN |
Transaction Log | ||||
LSN | prevLSN | transaction | type | page |
Transaction Table | |
transaction | lastLSN |
Related Book For
Governmental and Nonprofit Accounting
ISBN: 978-0132751261
10th edition
Authors: Robert Freeman, Craig Shoulders, Gregory Allison, Robert Smi
Posted Date: