Transaction

Question

how view serializability ensures serial schedule??

i mean in view we leave many conflict like RW,WW,......we only talks about WR conflict and intial read and final write.

then how it ensurs serailizability??

Answer 1

Considering the three conditions that need to be held for schedules to be View Serializable.

The idea behind view equivalence is that as long as each read operation reads the result of same write operation in both schedules, the write operations of each transaction must produce same result.The Read operations are hence said to have the same view in both schedules.

The last condition (Final write) ensure that final write on each data item is same in both schedules, Thus leaving the database in same state in both schedules.