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
What is property - properties of a database ? It is an integrated collection of logically related records. It consolidates separate files into a common pool of data records and

coventions for displaying an ER schema as ER diagram

Convert the following ER - diagram (Entity Relationship Diagram) into a relational database (the primary keys are underlined):       Ans:  The relational database schema f

These are designed to reduce the effects of a database failure and make sure a database is restored to a consistent state if a failure does arise. Manual backup/restore utilities n

Database Recovery And Security Introduction In this part we will introduce two main issues relating to database management systems. A computer system suffers from dissi

Define query optimization. Query optimization refers to the process of search the lowest -cost method of evaluating a given query.

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict


What are the functions of an accumulator? The accumulator is the register associated with the ALU operations and sometimes I/O operations. It is an integral part of ALU. It hol

What is a heterogeneous distributed database? In a heterogeneous distributed database, dissimilar sites may use different schemas, and dissimilar dbms s/w. The sites may not be