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
A table joined with itself is called ? A table joined with itself is known as self join table. Normal 0 false false false EN-IN X-NONE X-NONE

What is meant by object-oriented data model? The object-oriented paradigm is based on encapsulation of data and code related to an object in to a one unit, whose contents are n

Which language has presently become the defacto standard for interfacing application programs along with relational database system? The language which has recently become the

Multiple-mode locks : It offers two locks: exclusive locks and shared locks. But why do we require these two locks? There are a lot of transactions in the database system that neve

What are the difference between clustered and a non-clustered index? A clustered index is a special type of index that reorders the way records in the table are physically stor

How the time stamps are implemented Use the value of the system clock as the time stamp. That is a transaction's time stamp is equivalent to the value of the clock when the tra

What are the Objectives of object design After going through this unit, you could be able to: explain steps of object design; discuss algorithms that reduce costs;

Draw an ER diagram for company''s database schema

how to solve the C type problems?

Is it mandatory to declare all the tables in Report by the key word tables for all the tables that exist in the structure of LDB, and are being explained in the Database part of LD