Term
| What should you make of everything? |
|
Definition
|
|
Term
| If you have a crash, what happens to all of the work you have done since you started and the crash? |
|
Definition
|
|
Term
| Therefore, what should be kept of the work you do? |
|
Definition
|
|
Term
|
Definition
| keeps track of all transactions and physical changes to the database |
|
|
Term
| What columns does a log have? |
|
Definition
(1) trans id
(2) time
(3) action
(4) record
(5) before image
(6) after image |
|
|
Term
|
Definition
|
|
Term
| What happens when there is forward recovery? |
|
Definition
(1) load the backup copy
(2) use after images of all committed transactions |
|
|
Term
| What happens when there is backward recovery? |
|
Definition
| (1) using before images to "undo" problem transactions |
|
|
