Dirty reads-problems of concurrent transactions, Database Management System

Dirty Reads: T10 reads a value which is updated by T9. This update has not been committed and T9 aborts.

T9

T10

Value of x old value =

200

T9

T10

UPDATE X

 

500

 

 

READ X

 

500

ROLLBACK

 

200

?

Here T10 reads a value that is updated by transaction T9 that has been aborted. Therefore T10 has read a value that would never exist in the database and hence the trouble. Here the difficulty is primarily of isolation of transaction.

 

Posted Date: 3/12/2013 1:51:39 AM | Location : United States







Related Discussions:- Dirty reads-problems of concurrent transactions, Assignment Help, Ask Question on Dirty reads-problems of concurrent transactions, Get Answer, Expert's Help, Dirty reads-problems of concurrent transactions Discussions

Write discussion on Dirty reads-problems of concurrent transactions
Your posts are moderated
Related Questions
Q.1 Briefly discuss the different layers of ANSI SPARC architecture. Ans: The three layers of ANSI SPARC architecture are like this: 1. Internal view is at the lowest leve


How is Oracle used in PL/SQL? Define the features of process and how they are defined? PL/SQL - PL/SQL is Oracle's procedural language (PL) superset of the Structured

List the internal controls that should be in effect solely because a EDP system is employed, classifing them as (1) Those controls pertaining to input of information and (2) All ot

Question : (a) Data mining is one of the best ways to analyse data and using software method, hidden and unexpected patterns and relationships in sets of data can be extracte

In a Hierarchical model of data records are organized ? In the hierarchical model of data records are organized as Tree structure.

What is 2NF? A relation schema R is in 2NF if it is in 1NF and every non-prime attribute A in R is fully functionally dependent on primary key.

1. Design the logic, using a looping structure, for a program that outputs every even number from 1 through 25 along with its square and cube. 2. Mr. Sanchez owns 12 apartme

Physical Records These are the records that are stored in the secondary storage devices. For the database relation, physical records are the group of fields kept in adjacent me

An instance of relational schema R (A, B, C) has distinct values of A including NULL values. then A is a candidate key or not? If relational schema R (A, B, C) has distinct val