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
Equi Join: A join in which the joining condition is based on equality among values in the common columns. Common columns show (redundantly) in the result table. Let us Consider th

Assume you are given a uniprocessor system with one gigabyte of memory and a 300 gigabyte disk. The OS on the machine has a demand paged virtual memory system with a local page rep

You are managing the following database system: • DBMS: Oracle 11g • OS: Sun Solaris • System architecture: Web-based application using ASP.Net • Purpose of Server: HR manage

Multilevel Index The Multilevel Index is a modification of the secondary level index system. In this system we might be use even more number of levels in case the table is eve

List any eight applications of DBMS. a) Universities b) Airlines c) Banking d) Credit card transactions e) Tele communication f) Sales g)Finance h) Manufac

System Design: An Object Oriented Approach Any software systems always try to change and evolve as technology and business rules evolve. The development of information systems

Question: Data Mining is the process of extracting knowledge hidden from large volumes of raw data. (a) Using a suitable example, illustrate how Data Mining can be useful t

What is meant by normalization of data? It is a process of examining the given relation schemas based on their Functional Dependencies (FDs) and primary key to achieve the prop

discuss the array implementation of a stack.

Data Control The data control mostly refers to commands that permit system and data privileges to be passed to several users. These commands are usually available to database admi