Dirty Read

Question

Correct me where i am wrong if i am wrong Please :)

Dirty Read means Reading the data of uncommited transaction.

For removing the Dirty read we should always read after the transaction which wrote X commits , this is the only way to remove dirty read rt ?

T1            T2

r(x)

w(x)

Commit

                   r(x)

Above Shown is The Only way of removing the Dirty read rt ?

My doubt is its very similar to the Solution of Cascadeless.

Comments

Let's start with Cascading Rollback: A single transaction abort leads to a series of transaction rollback.
Now,
-What is the main cause of cascading rollback?
Ans - DIRTY READ: reading an output of an uncommitted transaction 
 So, How can we avoid cascading rollback?
Here comes CASCADELESS SCHEDULE: Schedule S is CASCADELESS if Tj reads a data item written by Ti, the COMMIT operation of Ti appears before the READ operation of Tj.

---

Thats right thanks

Answer 1

Soumya said right.