Describe the basic steps involved in recovery, Database Management System

Question:

One of the tasks a database management system must perform is to ensure that the data is still intact in the face of software and hardware failure. This task is known as recovery.

(a) Describe the three basic steps involved in recovery.

(b) Describe the three types of failure in a database system. Support your answer with appropriate example.

(c) Explain in details how you would recover from all the three types of the failure described above.

Posted Date: 11/16/2013 2:53:50 AM | Location : United States







Related Discussions:- Describe the basic steps involved in recovery, Assignment Help, Ask Question on Describe the basic steps involved in recovery, Get Answer, Expert's Help, Describe the basic steps involved in recovery Discussions

Write discussion on Describe the basic steps involved in recovery
Your posts are moderated
Related Questions
What functions does a data dictionary perform? In a (DBMS)data management system, the principal functions performed by the data dictionary are Management of data defini

One-to-many : An entity in A is related with any number of entities in B. An entity in B is related with at the most one entity in A. Example: Relationship between faculty and d

Define Hash files organization a. Hashing includes computing the address of a data item by calculating a function on the search key value.   b. A hash function h is a functi

Function requirement as given: 1> manage fans and likes and followings those information from facebook. twitter. google+ and linkedin etc 2> Organize the clients from email m

Write short notes on transaction state? A transaction may not always complete its implementation successfully such a transaction is termed aborted A transaction must be in o

Explain about database system structure? Storage manager Authorization and integrity manager Transaction manager File manager Buffer manager Storage manager

Determine the Derived attribute to avoid re-computation Each class box consists of an ordered list of attributes and operations, each represented as a next string. We can find

how to solve the C type problems?

WRITE SHORT NOTES ON INDEX STRUCTURE OF FILES? There are two basic parts of indices 1.   Ordered indices 2.   Hash indices Every technique must be evaluated on the bas

Explain recovery process after system failure using checkpoint. Ans: Checkpoint scheme or method is an extra component of the log based recovery system. This scheme is used to