DATABASE SYSTEMS

Maximum number of the pages: 3 pages summarize your discussions

1. Discuss the types of failure that may occur in a database environment. Explain why it is important for a multi-user DBMS to provide a recovery mechanism.
2. 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?
3. Compare and contrast the deferred update and immediate update recovery protocols. Briefly discuss the process of query optimization

Discuss the types of failure that may occur ina database environment. Explain why it is important for a multi-user DBMS to provide a recovery mechanism.

 

Solution: