Discuss how the log file (or journal) is a fundamental feature in any recovery mechanism. Explain what is meant by forward and backward recovery and describe how the log file is used in forward and backward recovery. What is the significance of the write-ahead log protocol? How do checkpoints affect the recovery protocol?
What will be an ideal response?
Log file contains before and after-images of updates to the database. Before images can be used to
undo changes to the database (i.e. perform backward recovery); after-images can be used to redo
changes (i.e. perform forward recovery).
Write-ahead log protocol ensures that log records are written before the corresponding write to the
database. Thus, if the system fails before the write occurs after the log record has been written but
before the write to the database, the system can recover using the information in the log file.
Log file also contains a checkpoint record, which can speed up the time for recovery following a
failure.
You might also like to view...
Which of the following is NOT true about how Twitter works?
A) Tweets are like short text-only blog posts made to the Twitter site. B) Twitter works much like a blogging service but with restrictions on what can be posted. C) A tweet feed can be viewed on a follower's computer or on all mobile phones. D) People who subscribe to a given user see a feed of a user's tweets, much as a subscriber to a blog sees a feed of blog posts.
To change the orientation of slides or handouts, open the Slide ____ dialog box. In the Orientation section of the dialog box, click the Portrait or Landscape options buttons in the Slides or Notes, Handouts, & Outline sections.
A. Review B. Design C. Size D. Orientation