Forward recovery (redo), Database Management System

Forward Recovery (Redo):In this system the committed changes made by a transaction are reapplied to a previous copy of the database.

 

                       2216_Forward Recovery (Redo).png

In simpler words, when a definite error in a system is detected, the recovery system creates an accurate assessment of the state of the system and then creates the appropriate adjustment based on the anticipated results - had the system been error free.

One thing to be well-known is that the Undo and Redo operations must be idempotent, i.e., implementing them several times must be equivalent to implementing them once.  This characteristic is needed to guarantee correct behaviour of database even if a failure happens during the recovery process.

Depending on the above discussed recovery system; various types of recovery methods have been used. Though, we define the most important recovery schemes used in most of the commercial DBMSs.

Posted Date: 3/12/2013 5:14:47 AM | Location : United States







Related Discussions:- Forward recovery (redo), Assignment Help, Ask Question on Forward recovery (redo), Get Answer, Expert's Help, Forward recovery (redo) Discussions

Write discussion on Forward recovery (redo)
Your posts are moderated
Related Questions
Data Independence This brings us to our next topic: data independence. It is the property of the database which tries to make sure that if we make any change in any level of sc

sql is relationally complete-justify

Describe the nested-loop join and block-nested loop join.   Ans:   The block nested- loop join algorithm is as described below:     for every block B r of relation R do beg

Define the Attribute Inheritance The attributes of a higher level entity set are inherited through a lower level entity set made by specialization-generalization hierarchy. Nam

What is Cardinality Ratio? Cardinality Ratios - The cardinality ratios for relationship kinds specifies the maximum number of relationship instances in which an entity can pa

#quesDefine a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pi

Differentiate between natural join and outer join? Natural join is a binary operator which is written as (R * S) where as R and S are relations. The output of the natural join

MySQL Database Merge Project Description: I have two databases, I need merge the data of one database into another Work to be done online right now. Payment can be done

Define Two phase commit Two phase commit: To make sure atomicity, all the sites where a transaction is being executed must agree on the final outcome of the execution. The tran

There are three main sources of utilities and applications for a DBMS: a. Vendor applications and utilities are given for working with or maintaining the database, and generally