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
A relationship set is a set of relationships of the similar type. For example, let consider the relationship among two entities sets course and student. Collection of all the in

Define instance and schema?  Instance:  Collection of  data  kept in the  data  base  at  a  particular  moment  is  known as an Instance of the database.  Schema: The o

What are partial, alternate,, artificial, compound and natural key? Partial Key: It is a set of attributes that can uniquely recognize weak entities and that are related to s

What are multiple inheritances? Multiple inheritances allow a class to inherit variables and methods from many super classes.

What is Oracle Process? Explain any four processes started by Oracle. Oracle Process is as follows: SMON: The System Monitor carries out a crash recovery while a crashed in

What is ODBC ? ODBC - Open DataBase Connectivity which is also denoted by ODBC enable the integration of SQL along with a common-purpose programming language. ODBC expose data

What is called remapping of bad sectors? If the controller detects that a sector is injured when the disk is initially formatted, or when an attempt is made to write the secto

1) Define 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 pict

The following relational database schema represents part of a simplified database used by a library: tblBook (BookID, Title, PublisherID, Category,Price) tblPublisher (Publishe

List the steps for converting state diagram to the code. a) Finding major control path b) Finding the conditional statements  c) Finding the loops  d) Finding error ro