What implications would a no-steal/force buffer management policy have on checkpointing and recovery?
What will be an ideal response?
No-steal means that the cache (buffer) page updated by a transaction cannot be written to disk before the transaction commits. Force means that updated pages are written to disk when a transaction commits.
With No-steal, the checkpoint scheme that writes all modified main memory buffers to disk would not be able to write pages updated by uncommitted transactions.
With Force, once a transaction is done, its updates would be pushed to disk. If there is a failure during this, REDO is still needed; however, no UNDO is needed since uncommitted updates are never propagated to disk.
You might also like to view...
A decision can be made in a C# app with a(n) ______________.
Fill in the blank(s) with the appropriate word(s).
________ software reduces the size of a file by as much as 80% without affecting the data
Fill in the blank(s) with correct word
The monthly Calendar at the top of the To-Do bar is called the Date Selector.
Answer the following statement true (T) or false (F)
The programming term SDLC stands for ________.
What will be an ideal response?