Durability-transaction , Database Management System

Durability: This property necessitates that once a transaction has committed, the changes made by it be never lost because of subsequent failure. Thus, a transaction is also a basic unit of recovery.

A transaction has many states of implementation. These states are displayed in Figure.

                                        2117_Durability-transaction.png

                                                             Figure: States of transaction execution

A transaction is started as a program. From the initial state as the transaction is scheduled by the CPU it moves to the Implement state, though, in case of any system error at that point it may also be gone into the Abort state. During the implement transaction changes the data values and database gone to an inconsistent state. On successful completion of transaction it gone to the Commit state where the durability feature of transaction makes sure that the changes will not be lost. In case of any error the transaction moves to Rollback state where all the changes made by the transaction are not done. Therefore, after rollback or commit database is back into consistent state. In case a transaction has been rolled back, it is started as a latest transaction. All these states of the transaction are shown in above Figure.

Posted Date: 3/11/2013 5:23:42 AM | Location : United States







Related Discussions:- Durability-transaction , Assignment Help, Ask Question on Durability-transaction , Get Answer, Expert's Help, Durability-transaction Discussions

Write discussion on Durability-transaction
Your posts are moderated
Related Questions
Data Definition Language It organises the data in the form of columns and rows. But what does the data field column of table accumulate? How do you describe it using SQL? Th

Submission Requirements All answers must be computer generated (including text and diagrams). The hand-in version must include a header page (or with sufficient space)

Explain the EXEC statement in SQL  Ans: All statements which start with EXEC SQL are embedded SQL database statements. High level languages such as C can be employed to write a

Law Associates is a large legal practice based in Sydney. You have been asked to design a data model for the practice based upon the following specification: The practice employs


Data Fragmentation "Fragmentation includes decomposing the data in relation to non-overlapping component relations". Why do we require fragmenting a relation?

can you please explain with the help of suitable example the difference between conflict equivalence and conflict serializability?

Explain view in RDBMS? View - A view is a relation (virtual rather than base) and could be used in query expressions, which is, queries can be written by using the view as a re

What are referential integrity constraints? A value that appears in single relation for a given set of attributes also appears for a particular set of attributes in another rel

Consider the following database containing five transactions. Let min_sup = 60%. Mine all frequent itemsets using Apriori and FP-growth algorithm. Compare the efficiency of the t