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
I need an ERD created for any original database(can be on anything). It needs to be 3NF. I then need all the CREATE STATEMENTS, INSERT STATEMENTS(anything you can think of as long

what is er digram given that example of hospital,bank and library er digram.

Objectives  After reading this unit you should be able to: Explain storage of databases on hard disks; Discuss the execution of various file Organisation techniques;

To delete a particular column in a relation which command is used ? To delete a particular column in a relation ALTER command is used.

Define According to the levels of abstraction, the schema at the intermediate level is called  Ans: As per to the levels of abstraction, the schema at the intermediate level is

a.  Construct a query around any one of the functional divisions you made in 4a such that if executed in the distributed design of 4 would require reconstruction of at least two ho

Consider the 1ollowin8 relation: CAR SALE (Car_id, Option_type, Option_listprice, Sale_date, Option_discountedprice) This relation refers to options installed in cars (e.g., crui

Multilevel Indexing Scheme Consider the indexing scheme where the address of the block is consider in the index for each record, for a little file, this index would be little a


The Form input elements are:             Reporter name                                                text type input             Password