Backward recovery (undo), Database Management System

Backward Recovery (UNDO):In this system the uncommitted changes made by a transaction to a database are undone.  Instead the system is reset to the last consistent state of database that is free from any errors.

 

                1420_Backward Recovery (UNDO).png

Posted Date: 3/12/2013 5:11:00 AM | Location : United States







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

Write discussion on Backward recovery (undo)
Your posts are moderated
Related Questions
Consider entity type Employee with attributes empNumber (this is unique), empName, and the year when he/she was hired. An employee can either be a technical employee, a marketing e

Define blocks? The database system resides eternally on non-volatile storage, and is into fixed-length storage units known as blocks.

Which data manipulation command combines the records from one or more tables ? JOIN data manipulation command combines the records from one or more tables.

Retrieve the S&S In-Chapter Database (in Microsoft Access format) from the text's Web site (or create the tables in Table 4-5 in a relational DBMS product). Write queries to answer

Multi-Key File Organisation In this part, we will introduce two basic file Organisation schemes that permit records to be accessed by more than one key field, therefore, allowi

what is the need of a log in dbms

Convert the following ER - diagram (Entity Relationship Diagram) into a relational database (the primary keys are underlined):       Ans:  The relational database schema f

Define data conversion? Helpful to load data into temporary staging tables. Then can write SQL code to do much of data processing. SQL code is simpler and faster to write than

What is meant by object-oriented data model? The object-oriented paradigm is based on encapsulation of data and code related to an object in to a one unit, whose contents are n

Update Anomaly : This anomaly is occurred due to data redundancy. Redundant information makes updates more complex since, for example, varying the name of the instructor of MCS-014