Transaction dbms self doubt

Question

T1	T2
R(A)
	W(A)
W(A)

IS THIS IS VIEW SERIALIZABLE?PLZ EXPLAIN

Comments

make polly graph

Not view serializable.

---

Picture please.

Answer 1

In given transactionsn, we can make polly graph by using First Read and Last Write, then merge both of them.

Comments

@Mk Utkarsh

please verify?

I have the problem with Polly graph, can you explain in more detailed?

---

Yes this is not view serializable because there won't be any serial schedule possible with Transaction T1 performing the first read also performing the final write (with two transactions T1 and T2).

Answer 2

If T1 first read then it also first write to removing cycle from precedence graph but that not possible so given schedule not view

Comments

Not view