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

Explain the concept of generalization and aggregation in E_R diagrams. Give one example for each one of them? Generalization: Consider extending the entity set account throug

What are the three data anomalies that are similarly to take place as a result of data redundancy?  Can data redundancy be completely eliminated in database approach?  Why or why n

Creating a view: A query can be embedded within the CREATE VIEW STATEMENT A query can have complex select statements containing join, groups and sub- queries A quer

The External or View Level The external or view level is the highest level of abstraction of database. It gives a window on the conceptual view, which permits the user to see

Examine about the Behavioural Diagrams  The main objective of behavioural diagrams is to visualize, specify, construct and document dynamic aspects of a system. The interactio

Assume that you are responsible for selecting a new DBMS product for Sohar Hospital

Explain data abstraction? Data abstraction Data abstraction is a methodology in which enables us to isolate how a compound data object is utilized from the details of how it is

What is DAG? The class-subclass relationship is shown by a directed acyclic graph.eg: employees can be temporary or permanent. We might be create subclasses temporary \and perm

What are the failures of Controlling Events Between Objects  Failure Unintentional termination of system. Several possible causes: failure of system hardware, o