#Transcation
#Transcation #Serializability #concurrency View serializability | View serializability in DBMS
In this video you will learn what is View serializability?
View Serializability
A schedule will view serializable if it is view equivalent to a serial schedule.
If a schedule is conflict serializable, then it will be view serializable.
The view serializable which does not conflict serializable contains blind writes.
View Equivalent
Two schedules S1 and S2 are said to be view equivalent if they satisfy the following conditions:
1. Initial Read
An initial read of both schedules must be the same. Suppose two schedule S1 and S2. In schedule S1, if a transaction T1 is reading the data item A, then in S2, transaction T1 should also read A.
2. Updated Read
In schedule S1, if Ti is reading A which is updated by Tj then in S2 also, Ti should read A which is updated by Tj.
3. Final Write
A final write must be the same between both the schedules. In schedule S1, if a transaction T1 updates A at last then in S2, final writes operations should also be done by T1.
Do like share comment and subscribe my channel.