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.

Computer Science & Information Technology

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).

Computer Science & Information Technology

________ software reduces the size of a file by as much as 80% without affecting the data

Fill in the blank(s) with correct word

Computer Science & Information Technology

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)

Computer Science & Information Technology

The programming term SDLC stands for ________.

What will be an ideal response?

Computer Science & Information Technology