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
Explain the functions of data manager? Functions of Data Manager : - Convert operations in user's queries coming directly through query processor or indirectly in an applicatio

Architectural standard: Designation : Architect , Consultant Job Profile : As a part of Oracle Fusion Middleware at Satyam, I am involved with Presales, Delivery, A

Define the terms   i) DDL   ii) DML   DDL: Data base schema is specified by a set of definitions expressed by a special   language known as a data def

tell me the functionality,advantages and disadvantages of student database

Question : (a) Differentiate between database integrity and database security (b) Database security involves measures to avoid loss of privacy and loss of confidentiality. D

Define a property that is not a property of transactions? Ans: Concurrency is not a property of transactions

what is entity in database system?

Explain Stand Alone Query Language in details? Stand alone Query Language - The query language that can be used interactively is known as stand alone query language. It does no

Problem: (a) Given the following relation: Stats(Name,Sex,Children, Occupation, Salary, Tax, Audits) Write SQL code to define the following security constraints: (i) User

List out various user authorization to modify the database schema. a)  Index authorization b)  Resource authorization c)  Alteration authorization d)  Drop authorizat