The second step of the sharp checkpoint recovery procedure is as follows: The log is scanned forward from the checkpoint. The after-images in all update records are used to update the corresponding items in the database. Assuming a locking concurrency control in which locks are held until commit time, show that the updates can be performed in either of the following orders:
a. As each update record is encountered in the forward scan, the corresponding database update is performed (even though the update records for different transactions are interleaved in the log).
b. During the forward scan, the update records for each transaction are saved in volatile memory, and the database updates for each transaction are all done at once when the commit record for that transaction is encountered during the forward scan.
a. Because that is the order in which the operations took place.
b. Because the transactions can be serialized in commit order
You might also like to view...
You can check the readability of a document by displaying readability____________________based on your document's average number of syllables per word and words per sentence.
Fill in the blank(s) with the appropriate word(s).
The date (Sobell, page 62) utility displays the date and time. Write and exe- cute a shell script that displays the date and time, the name of your home directory, and the value of your PATH variable.
What will be an ideal response?
Describe multisource agreements (MSA), including where it is used in a network, and why it is needed.
What will be an ideal response?
“____________________-based training” refers to any instruction delivered via the Web.
Fill in the blank(s) with the appropriate word(s).