Page 201 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

Database Management Systems/Managing Database

Notes 8. The recovery manager, stores the modifications made onto a storage which does not react
to system failures. Such storage is called ..................................
9. ..........................analyses the buffer pool to identify the active transactions and dirty pages.

10. ............................ failure occurred sufficiently early during the transfer that the destination
block remains intact.

11.12 Review Questions

1. Define recovery.
2. Describe ARIES.
3. What do you mean by transaction failure?
4. Distinguish between system crash and disk failure.
5. How will you implement stable-storage? Explain.

6. Describe log based recovery in detail.
7. Distinguish between deferred database modification and immediate database modification
with the help of a suitable example.

8. Write short notes on:
(a) Log record buffering
(b) Database buffering

(c) Check points
9. Distinguish between volatile and non-volatile storage.
10. Explain remote backup system.

Answers: Self Assessment

1. software 2. log
3. RAID 4. Partial

5. Random Access Memory 6. virtual memory
7. magnetic disks or tapes 8. stable storage
9. Analysis phase 10. Total

11.13 Further Readings

Books C.J. Date, Introduction to Database Systems, Pearson Education.
Elmasri Navrate, Fundamentals of Database Systems, Pearson Education.

Martin Gruber, Understanding SQL, BPB Publication, New Delhi
Peter Rob & Carlos Coronel, Database Systems Design, Implementation and
Management, 7th Edition.

194 LOVELY PROFESSIONAL UNIVERSITY