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
what is attribute is attribute inheritance in dbms?

what problems are raised by the database? why is it so controversial? why is data quality an issue?

In a job interview with a branch manager of a bank that operates in multiple Canadian provinces and the Yukon, you learn that all of the information is captured in real time in a s

Let us first describe the term relationships. What Are Relationships? A relationship can be defined as: A set of associations or connection, or A rule for communic

Question 1 Explain the functions of the following Storage Manager Buffer Manager Transaction Manager 2 Discuss about system catalog in a relational DBMS 3

What are the differences among MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()? Mysql_fetch_object returns the result from the database like objects while mysql

I need help with data warehousing and business intelligence course project about designing a data warehouse for a jewelry company that does not have one

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

What is Stored Procedure? A stored procedure is a named group of SQL statements that have been previously formed and kept in the server database. Stored procedures accept input

Write short note on Events Events consist of inputs, interrupts, decisions and actions performed by any external device or users. Every event always has a sender and receiver.