#View Serializability #DBMS

Question

I know that this is Conflict serializable and i know all schedules which are Conflict serializable are also view serializable

But still wanted to know what is the view serializable sequence?

Answer 1

Well, clearly all the transactions are reading the initial value of A, so w.r.t. READing any transaction can come to first position

BUT

the last Write on B is from T₄, so T₄ must be last.

This gives (any combination of T₁ T₂ T₃)  $\rightarrow$  T_{4 .}

Comments

I know the rules to check view serializability but initial read is happening on A and final write is on B.does that ok while checking for conditions?

---

Have a look, edited !