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.

Computer Science & Information Technology

You might also like to view...

________ is a free presentation tool that you can use to create and share interactive reports and presentations

A) Microsoft Sway B) Microsoft Azure C) Microsoft SharePoint D) Microsoft Account

Computer Science & Information Technology

What section for the main body of a form displays records and usually contains all the bound controls?

A. Form Header B. Page Header C. Page Footer D. Detail

Computer Science & Information Technology