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
State about the Tables- DBMS Data is stored in columns and rows (much like a spreadsheet -main difference is how data is organised). Every row in a table is known as a record

Explain Transaction manager and their work? Transaction Manager: Ensure the database remains in a constant (correct) state despite system failure, and in which concurrent trans

gyan gurukul is a software company that provides software related solution.


Cardinality of Relationship One-to-One Only one entity of the first set is linked to only one entity of the second set. E.g. A teacher teaches a student. Only one teacher

Define single valued and multivalued attributes. Single valued attributes: attributes with a single value for a particular entity are known as single valued attributes. Mult

Creating views with check option : This option limits those updates of data values that cause records to go off the view. The following instance tells this in more detail: Examp

Draw an EER diagram that captures the "is-a" hierarchy of students in another simple database. The database captures both the "basic" information (say, student ID and student name)

Question 1 What is data mining? Write Data Mining applications Question 2 What is OLAP? Write the benefits of OLAP Question 3 What is Business Intelligence? Explai

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