Database

Question

1. W1(x),R2(x),W1(x),commit2,commit1

2. W1(x),R2(x),W1(x),commit2,Rollback1

Are these schedules view serializable ??

Comments

to my knowledge, while testing serializability we do not consider Commit/Rollback.

---

Both are not serializable so it is not view serializable.

Serializable  i)initilal reads and updated reads and final writes done by transactions are should be same.

In both transactions initial reads are not same T2 reads a data item which is updated by T1.