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
By which techniquesTransaction processing is associated? Transaction processing is associated by producing detail, summary, or exception reports and recording a business activi


Which operator is used to compare a value to a list of literals values that have been specified? BETWEEN operator is used to compare a value to a list of literals values that h

Concurrency issues Data integrity: Threads accessing same object need to be synchronized, such as: banking account. Deadlock: One or more threads in system are perman

What is known as sequential file organization? In the sequential file organization, the records are kept in sequential order, according to the value of a "search key" of every

Express the properties of Strings? Strings can be case sensitive (or not) which can change the outcome of string operations. You can evaluate whole strings \ just part

(1)     Insert into PERSON Violated constraint: - Key constraint Reason: - Primary key 1 already exists in PERSON. Dealing: - DBMS could ask the user to provide valid PER

Create centralized relational database using Top down method- Construction of Logical Model: Translation EERD into Relational Schema: Use the 8 steps algorithm of converting EERD

You will be analysing a set of financial data of your choice. It is not necessary to collect any primary data of your own, and publicly available secondary data will be sufficient

what are the reasons having variable length records