Concurrent Transaction and Inconsistent Retrieval

Inconsistent retrieval: This occurs when more than one result of the same problem came out when the same object is read more than once. For example,  a transaction T1 is reading the value of the quantity, and transaction T2 is updating the data at the same time. Now, if T1 will be made to read the value, a different value will be read as it has been updated by T2. Thus fuzzy read anomaly is taking place.



Share this paper
Top