8.16 Practice Problem on View Serializability

📝 Please message us on WhatsApp: wa.me/91800012...
💻 KnowledgeGate Website: www.knowledgeg...
📲 KnowledgeGate Android App: tiny.cc/KG_Offi...
➡ Do not miss our Bestseller Courses:
🔴 GATE Guidance-2025: www.knowledgeg...
🟠 GATE Guidance-2026: www.knowledgeg...
➡ Contact Us:
🟩 Whatsapp Chat: wa.me/91859512...
📞Call on: [phone]
🟦 Telegram Updates: t.me/kg_gate
🟩 Whatsapp Updates: www.whatsapp.c...
📧 Email: [e-mail]
➡ Our One Shot Semester Exam Videos: 👇
▶ Operating System: • Complete Operating Sys...
▶ DBMS: • Complete DBMS Data Bas...
▶ Computer Network: • Complete CN Computer N...
▶ Digital Electronics: • Complete DE Digital El...
▶ Computer Architecture: • Complete COA Computer ...
▶ Data Structure: • Complete DS Data Struc...
▶ Algorithm: • Complete DAA Design an...
▶ Software Engineering: • Complete Software Engi...
▶ Theory of Computation: • Complete TOC Theory of...
▶ Compiler: • Complete CD Compiler D...
▶ Discrete Maths: • Complete DM Discrete M...
➡ Free Subject-Wise Complete PlayList: 👇
▶️ DBMS: tiny.cc/kg_yt_DBMS
▶️ Operating System: tiny.cc/kg_yt_OS
▶️ TOC|Automata: tiny.cc/kg_yt_toc
▶️ Computer Networks: tiny.cc/kg_yt_CN
▶️ Digital Electronics: tiny.cc/kg_yt_D...
▶️ Compiler Design: tiny.cc/kg_yt_C...
▶️ Computer Architecture: tiny.cc/kg_yt_COA
▶️ Data Structure: tiny.cc/kg_yt_D...
▶️ Algorithms: tiny.cc/kg_yt_A...
▶️ Set, Relation, Function: tiny.cc/kg_yt_D...
▶️ Graph Theory: tiny.cc/kg_yt_g...
▶️ Group Theory: tiny.cc/kg_yt_g...
▶️ Proposition: tiny.cc/kg_yt_p...
#knowledgegate #GATE #sanchitjain
*********************************************************

[@KNOWLEDGEGATE_kg]

For complete DBMS, check out this video: kzbin.info/www/bejne/j4PRm3qbhsemfrM

[@nisharathod2945]

Someone give this guy an award, he's explaining us np problems with such an ease

[@SouvikSarkar]

Watching him since School Level to UG then also in PG and it will go on... Thank you sir for make our life easy. Teacher like you are needed more.

[@anshulthakur3806]

Ur way of teaching is awesome.. thode se waqt mein aap sbb kuch achese smjha bhi dete ho aur concept bhi crystal clear ho jata h. Thanks a lot sir :)

[@shriyahireholi7472]

i wish we had teacher like you in our university the way you explain things and logic is very good thank you sm :))))

[@yashpathak3534]

Hii , kaisi ho?

[@nikhilnagrale]

@@yashpathak3534 simp

[@Hxxligan]

@@yashpathak3534 abe chapri simp

[@KshitijSinghBisht]

@@yashpathak3534 bhai meri hi doosri id h, all good tm btao?

[@akshatsaxenaaslian1163]

Timestamps 02:20 - View serializability in DBMS 04:40 - View Serializability requires checking for view equivalency with all possible serial schedules. 07:00 - View equivalent schedules can be considered as view serializable if they are view equivalent with any serial schedule. 09:20 - The condition of initial reads in the first schedule being preserved in the second schedule. 11:40 - Final writes were performed by transaction T2 on both A and B. 14:00 - The given schedule is not conflict serializable. 16:20 - To check the view realizability, all possible serial schedules need to be examined and their view equivalency proven. 18:34 - View serializability is a theoretical topic with practical challenges in checking view equivalency.

[@KNOWLEDGEGATE_kg]

🔥Complete DBMS by Sanchit Sir: tiny.cc/DBMS_Sanchitsir_kg 🔥🔥All Computer Science Subjects by Sanchit Sir: tiny.cc/CSbundle_dbms_kg

[@mr_technogeek]

No wonder why u r the best teacher 🙏

[@KNOWLEDGEGATE_kg]

Thank you so much , For more courses and content, visit tiny.cc/yt_kgwebsite👍

[@784_lalatenduparija4]

You took very easy examples but it was perfectly explained. Thank you so much.

[@KNOWLEDGEGATE_kg]

Thanks Lalatendu.. Am glad it was helpful.

[@vaidik03]

Thank you so much sir. Along with learning about this topic, I am also learning the way you explain things. You have a great power of explaining tough concepts in an easy way. Thanks once again.

[@KNOWLEDGEGATE_kg]

Thank you dear for your generous words 😍😍 keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents !

[@sonalisatpute9799]

I watch your complete playlist of transactions control .....I was dammed good🔥....I wish I could attempt your offline class

[@KNOWLEDGEGATE_kg]

Thanks a lot Sonali..Keep learning and supporting !! Do visit our website www.knowledgegate.in for more courses and contents !!

[@samarthgupta4069]

Hearty ❤️ Thank you sir...I have so much confusion and was in trouble from so much of time but after watching this video,It helps me a lot... Thank you so much again

[@KirtanPatel552]

Thank you sir, Your language and method is perfectly Understandable................

[@KNOWLEDGEGATE_kg]

Most welcome dear❤Keep learning & supporting! Stay connected for more amazing videos & upcoming contents 👍😊You can also check out our CS bundle course for complete preparation of Computer Science subjects, sharing course link below: www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science

[@imprakrut]

Are you also watching this one day before your exams?

[@avinandanbanerjee9568]

jisko neta banna hai, bana do!

[@Uddipta_Sarma007]

On the morning of my exam!!

[@copyrightscansuckit9624]

Uddipta Sarma 1 hours before exam

[@utkarshumang7565]

high five

[@alterdanish]

2 days

[@SHASHANKRUSTAGII]

Ravindra Babu sir has given us different method which is more easier. I am happy I have purchased it

[@gaurav45098]

standing ovation . Great Sir.Thanks a lot.

[@007KHURANA]

your videos have really been helpful..plz upload SQL and ER diagram videos...thank you

[@ColoursOfMySoul]

Plz sir 🙏 , uplaod concurrency control topic, locks, granting of locks, timestamps,deadlock, detection and recovery,security integrity violtion. Authorization,views.

[@KNOWLEDGEGATE_kg]

will upload them soon..

[@imprakrut]

When?

[@shashankkumar3138]

@@KNOWLEDGEGATE_kg SIR UR BST TEACHER .... BUS SAARE TOPICS UPLOAD KAR DO.....YE TOPICS BHI.....APRIL END SE PHELE SIR.....PLZZZ

[@kislaykumar9123]

Sir your video really changed my life....May you achieve a great success and good life

[@junaidshaikh3597]

Awesome sir It will be more better if u take 2,3 practice examples

[@VaaniChannel]

Very nice explanation sir 🙏

[@devikat1010]

sir...all your videos are the best...upload more topics

[@pratikshpatel5227]

I think there is an error on the First Example. The First Example shouldnt state that Schedule is View Serializable based on the following reasoning: 1st we know that the Conflict Serializable = no AND 2nd we know that the Blind Write = No so 3rd we know that the schedule = Not View Serializable

[@gibraanjafar1669]

They are Conflict Equivalent actually

[@salimkhan9577]

first time samjh aaya h sir ,thank you soo much

[@KNOWLEDGEGATE_kg]

Most welcome ❤ keep learning & supporting! You can also check out our course for all Computer Science subjects, sharing the link below: www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science

[@prakharsingh1329]

Great Explanation .

[@KNOWLEDGEGATE_kg]

Thanks a lot Prakhar.. keep learning. Do visit our website www.knowledgegate.in for more courses and contents.

[@URKCSJOMINJOSE]

Thank you for the amazing explanation!

[@KNOWLEDGEGATE_kg]

You're very welcome! Keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses and contents !!

[@funkyspin2506]

Salute your efforts sir

[@KNOWLEDGEGATE_kg]

😀 Glad you liked it, Please review our new app tiny.cc/yt_KgApp . Your review will help new audience to trust us 😄

[@sahilthite01]

Extremely good explanation 💯

[@KNOWLEDGEGATE_kg]

Glad you think so @Sahil! keep supporting & stay connected👍 Do visit our website www.knowledgegate.in for more amazing videos & contents😍

[@yogeshrawat5095]

Great explanation !!

[@AkashKumar-ym4gu]

Sir u are the best..🙏🙏

[@abhishekshivgan1884]

Thank you very much 🙏

[@KNOWLEDGEGATE_kg]

You're most welcome Abhishek.. Keep learning and supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@nishantnimbalkar1522]

Sir in the first example there was no blind write still you proved the schedule as view serializable.

[@gibraanjafar1669]

Also it is Conflict Equivalent , so no need to check for View equivalency .

[@harshshah9962]

Bro we check for blind write if the schedule is not conflict equivalent. But if the schedule is conflict serializable then it's already view serializable and no need to check for blind write.

[@AntaroopGhosh]

Hello sir there is a shortcut/technique to find if a schedule is view serializable, the technique is polygraphs. With the help of this we do not need to check that non serial schedule with all the serial schedules.

[@Ankit-we8ym]

share the knowledge as much as possible

[@KNOWLEDGEGATE_kg]

Yes Ankit My main aim is that only.. I try to share that as much as possible & it is a continuos process it will go on..

[@suryanshukushwaha2792]

13:34 main point

[@sandeepbhat8933]

Wonderful teaching

[@aidenfrost845]

you are such an amazing person. Life saviour for students

[@piyush-A.I.-IIT]

we can use dependency graph. i learnt it on GateVidaylaya website.

[@abhishekbandulwar364]

Very helpfull sir,enjoyed as well as lerned a lot...thank you sir🙏🙏🙏

[@ayushaggarwal4714]

What difference does the bliend write make for view serializability?

[@SudhirKumar-ly9wz]

Thank you so much sir ☺️🙏

[@KNOWLEDGEGATE_kg]

Most welcome dear! Keep learning & supporting! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊

[@mihirsheth9918]

Very helpful video. Thanks.

[@werstrugglers1170]

Sir plz upload iit tricky question for 2018. And thankyou sir it is very helpful

[@KNOWLEDGEGATE_kg]

I am uploading topicwise.. Keep following..

[@shyanu]

Hello sir actually m preparing for LIC AAO ( IT) and I follow your videos starting from 1 march , actually my question is where to study I mean which book I preferred for theory actually my background electronic and communication engineering . please suggest sir

[@muhammedmuhsink5062]

finally I got the correct explanation thank you

[@KNOWLEDGEGATE_kg]

Glad it helped!😍Keep learning & stay connected for more amazing contents👍😊 You can also check out our course for all Computer Science subjects, sharing the link below: www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science

[@jashanpreet.753]

if no blind write then it is not view serializable but if blind write exists then we need to check. koi view serializable tab hota hai jab vo kisi serial view ke saath view equivalent ho.

[@bikramroy8772]

Thank you so much for this video...

[@anuragkumargupta7506]

sir please make vedioes on concurrency control and dead lock.🙏🙏🙏🙏

[@syedarbaz3781]

Great explanation

[@Ankit-we8ym]

Best explained

[@KNOWLEDGEGATE_kg]

Thanx a lot Ankit for continuosly following & commenting..

[@sonalisatpute9799]

Dependency graph and precedence graph are same or different.... please reply asap tommorrow I have exams

[@sonalisatpute9799]

@@JatinGupta thank you for the ans ..

[@marinag1877]

Sir please plz make videos on networking..preparing for Net exam..it will be very helpful

[@meenakshisamg1554]

👍👍thanks sir for such nice effort

[@ankitathakur5989]

Thanku so much sir ji

[@demonalpha0493]

Sir can you please make videos on locking and deadlocks please sir🙏🏼🙏🏼🙏🏼🙏🏼🙏🏼

[@narendraparmar1631]

Dhanyavad sir ji😆

[@shadabiakram5283]

Very nice sir

[@KNOWLEDGEGATE_kg]

Thanks man..

[@jagmohanagrawal7636]

Nice explanation

[@parshchoradia9909]

Understood Sir!

[@KNOWLEDGEGATE_kg]

Good! keep learning👍

[@ayushiagarwal528]

can you also explain some ques like finding number of view or conflict equivalent schedule or recoverable schedules?

[@preethamm.n1161]

Awesome 🌹🇮🇳🇮🇳

[@youngboys7342]

Kya ek shedule m ek s jayada view equivalent shedule ho skte hai

[@samratyadav6421]

Sir har possible sechdul ke liye match krna hoga kya jab Tak hum dono ko view equivalent proof nahi kar pate hai

[@happysharma457]

sir please explain to find number of conflict serializable

[@prabhattiwari9275]

Through precedence graph u can find

[@ashutoshvaish867]

@@prabhattiwari9275 usse order pata chalta hai bhai

[@vipingautam1257]

Thank you sanchit sir :)

[@rukhsarperween4794]

sir plz make video on phase locking protocol plzzzzz

[@happysharma457]

thanks sir

[@KNOWLEDGEGATE_kg]

You are welcome..

[@gholapakshay6443]

Sanchit sir does this DBMS tutorial also applicable for Distributed DBMS.? please let me know sir ?

[@jayashriipatil]

What if S and S1 are view quivalent and S and S2 are not view equivalent? Then what about S? Is S is view equivalent or not?

[@malhartrivedi8365]

Pls uploaded video on deadlocks and to solve the deadlocks

[@AmitSharma-zf8tz]

sir last example conflict serializable nii tha to uske all 6 serial schedule mai kaise convert kr skte hai?

[@madhavjain1039]

is w(a) changes a value in t1 even before commit so that in t2 r(a) see the updated value ?

[@Sid-nl1yi]

sir in first question there is no blind write, then how can it be view serializable?

[@KNOWLEDGEGATE_kg]

Dear @Sid, before blind write, we should check whether the schedules are conflict serializable or not. In the first question, both schedules are conflict serializable. Hence, they become view serializable automatically.

[@debayanbiswas9332]

plz upload video on polygraph..!!

[@ichchhashrivastava5667]

Plzzzz sir upload concurrency control before net exam plz

[@nisargsheth9841]

at 8:00 "b ne hi initial read kiya" should be replace with "T1 ne hi initial read kiya." BTW thanks for great lectures!

[@demonking7900]

Anyone watching on the day of exam ? I mean before 2 hours of exam

[@idrispatel7139]

T1 R(a) W(a) Commit T2 R(a) W(a) Sir, In this schedule how many initial read and final write

[@jayeshsonawane5610]

Love you man

[@shivanisharma2572]

Sir software engineering kahan se karna chahiye ?? Pls upload videos

[@himanshuraj6852]

Sir , I just wanted to know why there is lack of good teachers in INDIA.

[@mayuribhandari2224]

I have a doubt... While checking view serializability if in a transaction after final write there exist some read operation, will it effect view serializability??? plz reply

[@nikhilsoni470]

sir honest review dunga samjhaya apne bilkul sahe hai but request hai point to point samjhya kro kuch chezen aap flow main etni bol dete ho ki woh confusion create kr deti hai and kuch aise bhi log hai jinko DBMS ka "D" bhi nahe ata hai but they are trying hard to understand this topic un logon main se ek main bhi hun... main apko slow bolne k liye nahe keh raha hun woh apka nature hai usko aap hi handle kr sakte ho.. mene yeah vedio 3 4 bar dekhi kyun ki apki over knowledge or fast bolne ki speed ne mujhe confuse kr diya tha..

[@KNOWLEDGEGATE_kg]

Thanks Nikhil for the feedback.. We will consider it.

[@nikhilnagrale]

kuch bhi ! mai 2x mai dekhta hahaha

[@NaveenKedia]

sir in first example no blind write but it is view serializable .. how ??

[@americanSlayer]

11:50 It doesn't contain BLIND WRITE...then how it is only view equivalent

[@shrawanideshmukh6356]

It is already conflict serialized as it has no deadlock ..so it tells that is is view serializable also ...if it would have been not conflict serializable then blind write would matter

[@aditysharma2302]

sir make video on B and B+ Tree

[@KNOWLEDGEGATE_kg]

Yes Aditya will make that soon..

[@aditysharma2302]

thanks sir

[@rishabhnegi479]

awesome

[@amrapaliwaghmare2761]

thanks sir...

[@skarthikreddy938]

Now i realize how stupid i am wasting a lot of time understanding what my teacher taught instead of just watching these videos

[@Yagamilight19383]

Can someone explain how the first schedule is conflict serializable? If we draw a graph, won't we get a cycle ?

[@dulaferndz5152]

Can u pls exlplain such things in english also..

[@invincible9971]

Sir what is Serialization in DBMS??

[@siddhartharoy5263]

What will be the output if I do that 132 order ?

[@prafullaraichurkar4369]

your videos work like a charm!

[@naincypriya7017]

Sir,how in 1st example it is conflict serializable?

[@vinitraj6268]

Make precedence graph and u will see that there is no cycle

[@khileshkumar8796]

sir plz upload B and B++ tree

[@srimoyeekundu97]

Sir please upload on compiler design

[@pragyan_14]

thanks sir

[@KNOWLEDGEGATE_kg]

You're welcome. Keep learning, supporting & stay connected for more upcoming content👍

[@blackking3414]

Nice Sachin Don International

[@anupamadebnath5160]

I have confusion on VS when there will be more than 3 write operations like w1(x), w2(z),w3(y),w2(y)..how to arrange them