Explain howthe commit of a transaction is implemented within the logging system.
What will be an ideal response?
When a transaction commits, it writes a commit record to the log. If it aborts, it rolls back its updates and then writes an abort record to the log. Using these records, the backward scan can record the identity of transactions that completed prior to the crash, and ignore their update records as they are subsequently encountered. If, during the backward scan, the first record relating to T is an update record, T was active when the crash occurred and must be aborted.
A transaction is committed if and only if its commit record has been successfully appended to the log.
You might also like to view...
How can you treat the junction between two separate surfaces?
What will be an ideal response?
________ are those people or entities who are effected by the operations of a business
Fill in the blank(s) with correct word
Two spaces between sentences is now considered common practice in typed documents
Indicate whether the statement is true or false
A self-created digital signature will enable you to verify that a presentation has not been changed on the computer on which you have saved the presentation
Indicate whether the statement is true or false