8.16 Practice Problem on View Serializability

[@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.

[@KNOWLEDGEGATE_kg]

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

[@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?

[@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 :)

[@imprakrut]

Are you also watching this one day before your exams?

[@avinandanbanerjee9568]

jisko neta banna hai, bana do!

[@uddiptasarma3936]

On the morning of my exam!!

[@copyrightscansuckit9624]

Uddipta Sarma 1 hours before exam

[@utkarshumang7565]

high five

[@alterdanish]

2 days

[@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.

[@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 !!

[@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 !

[@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

[@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

[@SHASHANKRUSTAGII]

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

[@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

[@007KHURANA]

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

[@junaidshaikh3597]

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

[@skarthikreddy938]

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

[@kislaykumar9123]

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

[@gaurav45098]

standing ovation . Great Sir.Thanks a lot.

[@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

[@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.

[@piyush-A.I.-IIT]

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

[@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

[@VaaniChannel]

Very nice explanation sir 🙏

[@devikat1010]

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

[@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.

[@ayushaggarwal4714]

What difference does the bliend write make for view serializability?

[@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😍

[@prakharsingh1329]

Great Explanation .

[@KNOWLEDGEGATE_kg]

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

[@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

[@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..

[@sonalisatpute9799]

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

[@sonalisatpute9799]

@@JatinGupta thank you for the ans ..

[@werstrugglers1170]

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

[@KNOWLEDGEGATE_kg]

I am uploading topicwise.. Keep following..

[@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 😄

[@demonalpha0493]

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

[@ayushiagarwal528]

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

[@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 !!

[@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

[@sandeepbhat8933]

Wonderful teaching

[@marinag1877]

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

[@anuragkumargupta7506]

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

[@gholapakshay6443]

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

[@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 !!

[@yogeshrawat5095]

Great explanation !!

[@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.

[@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

[@AkashKumar-ym4gu]

Sir u are the best..🙏🙏

[@aidenfrost845]

you are such an amazing person. Life saviour for students

[@samratyadav6421]

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

[@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.

[@debayanbiswas9332]

plz upload video on polygraph..!!

[@malhartrivedi8365]

Pls uploaded video on deadlocks and to solve the deadlocks

[@abhishekbandulwar364]

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

[@syedarbaz3781]

Great explanation

[@demonking7900]

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

[@rukhsarperween4794]

sir plz make video on phase locking protocol plzzzzz

[@ichchhashrivastava5667]

Plzzzz sir upload concurrency control before net exam plz

[@Ankit-we8ym]

Best explained

[@KNOWLEDGEGATE_kg]

Thanx a lot Ankit for continuosly following & commenting..

[@narendraparmar1631]

Dhanyavad sir ji😆

[@ankitathakur5989]

Thanku so much sir ji

[@parshchoradia9909]

Understood Sir!

[@KNOWLEDGEGATE_kg]

Good! keep learning👍

[@bikramroy8772]

Thank you so much for this video...

[@youngboys7342]

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

[@shivanisharma2572]

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

[@jagmohanagrawal7636]

Nice explanation

[@shadabiakram5283]

Very nice sir

[@KNOWLEDGEGATE_kg]

Thanks man..

[@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?

[@madhavjain1039]

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

[@AmitSharma-zf8tz]

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

[@khileshkumar8796]

sir plz upload B and B++ tree

[@meenakshisamg1554]

👍👍thanks sir for such nice effort

[@invincible9971]

Sir what is Serialization in DBMS??

[@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

[@vipingautam1257]

Thank you sanchit sir :)

[@aditysharma2302]

sir make video on B and B+ Tree

[@KNOWLEDGEGATE_kg]

Yes Aditya will make that soon..

[@aditysharma2302]

thanks sir

[@americanSlayer]

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

[@srimoyeekundu97]

Sir please upload on compiler design

[@dulaferndz5152]

Can u pls exlplain such things in english also..

[@himanshuraj6852]

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

[@Yagamilight19383]

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

[@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.

[@preethamm.n1161]

Awesome 🌹🇮🇳🇮🇳

[@idrispatel7139]

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

[@NaveenKedia]

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

[@naincypriya7017]

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

[@vinitraj6268]

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

[@happysharma457]

thanks sir

[@KNOWLEDGEGATE_kg]

You are welcome..

[@siddhartharoy5263]

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

[@rishabhnegi479]

awesome

[@jayeshsonawane5610]

Love you man

[@python9657]

My book says there is method of labeled precedence graph

[@blackking3414]

Nice Sachin Don International

[@amrapaliwaghmare2761]

thanks sir...

[@prafullaraichurkar4369]

your videos work like a charm!

[@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!

[@utkarshpathak9491]

sir pls explain polygraph

[@BonerPauler]

majorly complex

[@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

[@samriddhijain1651]

Is this playlist enough for GATE and interviews? Also can anybody share their notes for these videos? It'd be a great help!!!

[@harshshah9962]

Yess sure !! Np but how can I share them??

[@samriddhijain1651]

@@harshshah9962 how about sharing the drive link?

[@harshshah9962]

@@samriddhijain1651 okay I will share it here ! Right now i am making notes of it so wait for few minutes 😄

[@harshshah9962]

@@samriddhijain1651 drive.google.com/file/d/19MUL1Qy9lCEzCkO8aGyyIYCuVJojIPjL/view?usp=drivesdk

[@samriddhijain1651]

@@harshshah9962 Thanks a lot! Have you made notes for other videos as well?