Unrepeatable reads-problems of concurrent transactions, Database Management System

Unrepeatable reads: Assume T7 reads X twice during its implementation. If it did not update X itself it could be very disturbing to see a dissimilar value of X in its next read. But this could occur if, among the two read operations, another transaction modifies X.

 

T7

T8

Assumed value of

X=2000

T7

T8

READ X

 

2000

 

 

UPDATE X

 

3000

READ X

 

3000

 

 

Therefore, the inconsistent values are read and results of the transaction may be in fault.

 

Posted Date: 3/12/2013 1:50:06 AM | Location : United States







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

Write discussion on Unrepeatable reads-problems of concurrent transactions
Your posts are moderated
Related Questions
Analyzing Association Traversal Association Traversal shall be understood properly for the association design explanation.  Analyzing association traversal means analyzing tra

i am not clear with the climetic condition of the north indian plain. can u plz explain it for me

The advantages of a database management system (DBMS) include :- Data integrity and elimination of duplication.

What are the two approaches to store relations in distributed database? a) Replication b) Fragmentation

Explain the concept of Modeling With Objects A model is a conceptual representation of a specification, design or system from a particular point of view. A modelling language

what is attribute is attribute inheritance in dbms?

Explain the EXEC statement in SQL  Ans: All statements which start with EXEC SQL are embedded SQL database statements. High level languages such as C can be employed to write a

Super keys of a relation can have extra attributes. Candidate keys are minimal super key, i.e. such a key have no extraneous attribute. An attribute is known as extraneous if even

as a customer service employee explain five measures you would recommend to make even a displeased students patronize the school canteen

How persistent programming languages differ from traditional programming languages? Database languages vary from traditional programming languages in that they directly manipul