Chapter 19, Problem 8PE

Explanation of Solution

Ensuring certain actions are not rolled back:

• The ARIES recovery scheme will flush pages continuously without even waiting for the checkpoint. It makes use of Log Sequence Numbers (LSN) for implementation.
• Once a transaction allocates a page to a relation, they should not be undone even when the transaction is rolled back as other transactions might have stored records on the same page...