recategorized by
3,081 views

3 Answers

4 votes
4 votes

This problem is called dirty read and it is due to this incorrect result is obtained

Uncommitted Dependency (Dirty Read)

Uncommitted dependency occurs when a second transaction selects a row that is being updated by another transaction. The second transaction is reading data that has not been committed yet and may be changed by the transaction updating the row.

For example, an editor is making changes to an electronic document. During the changes, a second editor takes a copy of the document that includes all the changes made so far, and distributes the document to the intended audience. The first editor then decides the changes made so far are wrong and removes the edits and saves the document. The distributed document contains edits that no longer exist, and should be treated as if they never existed. This problem could be avoided if no one could read the changed document until the first editor determined that the changes were final.

Answer:

Related questions

2 votes
2 votes
1 answer
1
2 votes
2 votes
2 answers
2
go_editor asked Jul 6, 2016
2,749 views
What is Granularity?The size of databaseThe size of data itemThe size of recordThe size of file