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
Derived horizontal fragmentation: Some applications may include a join of two or more relations. If the relations are stored at dissimilar locations, there may be a major overhead

Assume that you are responsible for selecting a new DBMS product for Sohar Hospital

What is a block and a block number? A block is a contiguous sequence of sectors from a single track of one platter. Every request specifies the address on the disk to be refere

Problem: (a) Briefly explain the ‘Hierarchical Database Model' using appropriate diagram. (b) List and briefly describe five potential benefits of the database approach comp

A use case diagram giving a pictorial overview of user requirements and brief use case descriptions. As the case study contains only an outline of a business scenario, you will als

Describe Application programming interface? Application Programming Interface - Commercial SQL implementations take one of the two primary techniques for involving SQL in a p

Update or Modify operation alters the existing values. If these operations alter the value that is the foreign key also, the only check need is the similar as that of the Insert op

A super key is an attribute or set of attributes used to recognize the records uniquely in a relation. For instance, in the Relation PERSON defines earlier PERSON_ID is a super

Explain the concept of generalization and aggregation in E_R diagrams. Give one example for each one of them? Generalization: Consider extending the entity set account throug

Explain the Fundamental concepts of object-orientation Software developers, data base administrators (DBAs) need to be familiar with fundamental concepts of object-orientation.