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
There are a number of possible solutions to the open ended brief. One of the simple ones is shown here without the PKs and FKs. It is important to think of how a number of tasks

Differentiate between static hashing and dynamic hashing.  Ans: Static Hashing comprises the number of primary pages in the directory fixed. So, while a bucket is full, we requ

10A.53 Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department. 10A.54 Code an Oracle Database trigger to allow the

Explain Object oriented Model ? Object Oriented Model - This model is based on the object-oriented programming language paradigm. It involves the features of OOP such as inhe

Strong entity set and weak entity set? Strong entity set and weak entity set: A strong entity set has a primary key. All tuples in the set are distinguishable through that key.

Explain Hashing techniques The hashing techniques can be categorized as: Static Hashing Techniques - In this method, the data can be viewed a collection of buckets, along with

Authorisation Authorisation is the culmination of the administrative policies of the organisation.  As the name shows, authorisation is a set of rules that can be used to verif

What is D command work in the respect of QBE? D: It is the command inside QBE to delete tuple(s) from the relation.

need a DBMS system on any data for assignment.

Which data manipulation command combines the records from one or more tables ? JOIN data manipulation command combines the records from one or more tables.