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
Consider a database application that deals with an Employee relation with information such as SIN, name, data of birth (DOB), and DID (the ID of the department at which the employe

Define the step - Rearranging the Execution Order for Efficiency As we know that algorithm and data structure are closely related to one another, but data structure is conside

Design a gennalization and specialization hierarchy for an automobile sales company

Objectives differentiate DDBMS and conventional DBMS; Describe Network topology for DDBMS; Describe the concepts of horizontal and vertical fragmentation; Descr

Describe the difference between a one-to-many and a many-to-many relationship. Which logical data structures comprise one-to-many and which comprise many-to-many relationship?

Example - ALTER TABLE emp MODIFY (empno NUMBER (7));

Project Description: Hi I'm seeking someone to make my dBase application work. I know it's not a 'modern' language but it's what I know. I have written an order program and I ne

Define access time. Access time is the time from when a read or write request is issued to when data transfer starts.


What are the authentication modes in SQL Server? How can it be changed? Windows mode and Mixed Mode - SQL and Windows. To alter authentication mode in SQL Server click Start, P