Fuzzy reads (Non repeatable read)

Data System Architecture

Fuzzy reads (Non repeatable read)

About

Non repeatable or fuzzy read is a phenomena that occurs when a transaction rereads data it has previously read and finds that another committed transaction has modified or deleted the data.

Example

A user queries a row and then later queries the same row, only to discover that the data has changed.





Discover More
Data System Architecture
Phenomena - Data problem (Concurrency Problem/ Data Corruption)

Because of a race condition, when several transactions concurrently read from and write to a file, variable or database, the following data problems called phenomena can arise: The isolation...
Data System Architecture
Transaction - Isolation (Level|Degree) - (Locking Level ?)

Very early in the development of the transaction concept (ie lock concept), attempts were made to increase concurrency by providing weaker isolation level than the serialiable one. serializability defines...



Share this page:
Follow us:
Task Runner