Lec-85: Why View Serializability is Used | Introduction to View Serializability | DBMS

Two schedules are said to be conflict equivalent if all the conflicting operations in both the schedule get executed in the same order. If a schedule is a conflict equivalent to its serial schedule then it is called Conflict Serializable Schedule.

0:00 - Introduction
0:25 - Check Conflict Serializable
4:39 - View Serializable

► Database Management System(Complete Playlist):

Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
►Computer Architecture (Complete Playlist):
► Theory of Computation
►Artificial Intelligence:
►Computer Networks (Complete Playlist):
►Operating System:
►Structured Query Language (SQL):
►Discrete Mathematics:
►Compiler Design:
►Number System:
►Cloud Computing & BIG Data:
►Software Engineering:
►Data Structure:
►Graph Theory:
►Programming in C:
►Digital Logic:

---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:

#ViewSerializability#DBMS#GATE#UGCNET

[kunalgautam]

Tomorrow is my DBMS semester exam, wish me luck!

[annmariageorge]

I don't know Hindi well but I can always count on you. Thank you, sir.

[prachipatil]

Best Explanation in the world 😍 as usual!! Thanks alot sir🙏🙏🙏🙏

[Harpreetkaur-fdfu]

Great explanation sir thanks a lot
Also provide further vedio on view serializability and locking...

[Niteshupsc]

awesome sir, aslo we can check conflict equivalence by changing the posn of non conflict pairs

[mansibhalla]

best, you are the best teacher.
thank you varun sir...

[asitkumarsahu]

Thanks Sir ...plz upload video on locking protocols..

[shreya_sengarr]

You cannot swap W(A) from T1 and W(A) from T2 since it fulfills all the conditions for conflicting operations and conflicting operations cannot be swapped.

[aayushpuri]

I am watching videos 4 hours before the paper.😂😂

[sayakhaldar]

If W(A) in T2 -> A = A*2
then changing the position of W(A) will not give the same result. Is view serializability dependent on the operations we perform on W(A)?

[deepinsighter]

What if transaction 1 fails? How it will be equivalent? could you pls explain...

[bhargavramgmailcomram]

Bro plz make a vedio about two phase locking, time stamping method, u r vedios r very help full for me tq u

[SnehaSneha-puhu]

Hello sir.Please complete view serializability topic.

[sarveshkhire]

Sir please upload Detailed video on view serializability

[rupshanandy]

Tomorrow is my 4th sem exam thank you sir ❤

[Stdpoint-ug]

Sir क्या write write का swapping हो सकता है

[matrixlnmi]

What is scheduled, is API which is one thread can be consider as scheduled which consists of one transaction?

[sharmaluckey]

Still waiting for the video on view serializable

[mohdabdulmuqtadir]

Sir when we are checking view serializability u have swap the position in t1 and t2 respectively but u have told in conflict equivalent video that conflict pairs cannot swap their positions but here u have swap the position so how is that possible

[arjitsharma]

Sir per hum ye dusra s kaise bnayenge ..ye jo aapne dusre s mein w(a) ki jagah interchamge kr di t1 aur t2 mein ye kaise ho gya ..jabki w(a) aur w(a) to adjacent conflicting pairs hain ....to ye dusra s kaise nikaal diya aapne ...aur jab tak hum ye dusra s nhi nikaal payenge tab tak hum view serializability check hi nhi kr payenge...sir please answer