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
Define the Wait for graph Ans: The wait-for-graph is a directed graph and consist of nodes and directed arcs; the nodes of the graph are active transactions. An arc of the grap

Differentiate between static hashing and dynamic hashing.  Ans: Static Hashing comprises the number of primary pages in the directory fixed. So, while a bucket is full, we requ

What is the difference between SQL Server 2000 complete and differential backups? A complete backup makes a copy of the whole database. A differential backup creates a copy of

It is mandatory that for every table in the LDB hierarchy there should exist one GET statement in the report. False.  It is not essential.

Have database built but having problems with some questions that go with the database

What are the various forms of data transparency? a) fragmentation transparency b) replication transparency c) location transparency

Explain Two phase locking protocol A transaction is consider as to follow the two-phase locking protocol if all locking operations precede the first unlock operation in the tra

Should I select imaging software that allows changes? An imaging system should not give features to edit or alter images. Images generally are formed as safe and secure records

When every condition appears with equality condition (=) only. c)   Natural join (denoted by R*S) When two join attributes have the similar name in both relations. (Tha

In case of entity integrity, the primary key may be declared? In a case of entity integrity primary key may be not Null.