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 the subsequent relations RENTER(rno, fname, lname, address, tel_no, pref_type, max_rent) VIEWING(rno, pno, date, comment) PROPERTY_FOR_RENT( pno, street, area ,city,

List the types of authorization. A) Read authorization B) Write authorization C) Update authorization D) Drop authorization

Explain the integrity constraints: Not Null,  Unique, Primary Key with an example each. Is the combination 'Not Null, Primary Key' a valid combination. Justify. Not Null - Shou

please i request for your assistance in developing a case-based online phone repair

Defining Internal Classes and Operations When we enlarge algorithms, new classes can be added to the store intermediate results. A complex operation could be looked at, as a c

Consider the relation schemas as follows. works (person name, company name, salary); lives (person name, street, city); located in(company name, city); managers (person name

difference between internal schema and external schema in DBMS

What are the types of reference?explain it with suitable examples? Object oriented language given the ability to refer the object attribute of the type can be referred to the s

Whta is the advantage of the database management approach? The advantage of the database management approach is data is integrated and can be accessed by multiple programs.

Describe the statement in SQL which allows to change the definition of a table? In SQL Alter statement is used to allow the changes the definition of a table.