Isolation or independence-transaction , Database Management System

Isolation or Independence: The isolation property shows that the updates of a transaction should not be visible till they are committed. Isolation assurance that the progresses of other transactions do not affect the outcome of this transaction. For instance, if another transaction that is a withdrawal transaction which withdraws an amount of Rs. 5000 from X account is in progress, While commits or fails, should not affect the outcome of this transaction. Only the state that has been study by the transaction last should verify the outcome of this transaction.

 

 

Posted Date: 3/11/2013 5:22:01 AM | Location : United States







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

Write discussion on Isolation or independence-transaction
Your posts are moderated
Related Questions
Ask Write the SQL code that will create the table structure for a table named EMP _1. This table is a subset of the EMPLOYEE table. The basic EMP_1 table structure is summarized in

Define the Query optimisation The query parser commonly generates a standard initial tree to correspond to an SQL query, with no doing any optimization. Such type of a canonica

Explain the concept of Modeling With Objects A model is a conceptual representation of a specification, design or system from a particular point of view. A modelling language

State the process of Rearranging Classes and Operations The various, yet similar operation of different classes can be slightly modified thus that they can be covered by a sin

Define upgrade and downgrade? It gives a mechanism for conversion from shared lock to exclusive lock is called as upgrade. It gives a mechanism for conversion from exclusive

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

how to implement mid square hashing?

1. Will you advise that your organization uses open source software and why? 2. Why is it important for business managers to have a basic understanding of the software development

it can be possible to create any table without primary key