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
Create table employee and enter employee data in SQL? Consider the following relational schemas: EMPLOYEE (EMPLOYEE_NAME, STREET, CITY) WORKS (EMPLOYEE_NAME, COMPANYNAME, SAL

What is data independence? Data Independence: Techniques which permit data to be changed without affecting the applications in which procedure it. There are two types of data

Compare wait-die deadlock prevention scheme with wait-wound scheme   Ans:  Wait-Die Scheme  a) Based upon a nonpreemptive technique.  b) If Pi requests a resource present


Farmer Bob, Farmer Jane and Farmer Jose run a cow farming co-op. For every cow they keep the cow’s name, age (or date of birth), breed and numbered plastic ear tag. The each of t

wrie a report on whether a BSc n information systems develops the skills required by employers in Database administration

what is specialization?

need requirement analysis for database management of stock market


assume we have the following apllicationthat model sccer team the games they play and the players inv each teamin the design we want to capture