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
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

You are required to write a report which evaluates two of the following issues in relation to your case study database: a. Security issues b. Performance issues c. Backup

coventions for displaying an ER schema as ER diagram

Process of Adjustment of inheritance During object design, inheritance is readjusted by rearranging classes and operations, and abstracting common behaviour.

How many physical thing?

Improved availability: The data in a distributed system may be replicated so that it is at more than one site. Thus, the failure of a node or a communication link does not necessar

What is a candidate key? Minimal super keys are known as candidate keys.

Design an EER schema for the following application and translate the EER schema into relational schemas (and constraints). It is possible that some requirements cannot be captured

Describe the difference between a one-to-many and a many-to-many relationship. Which logical data structures comprise one-to-many and which comprise many-to-many relationship?