8.16 Practice Problem on View Serializability
Вставка
- Опубліковано 19 жов 2024
- 📝 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: +91-8000121313
🟦 Telegram Updates: t.me/kg_gate
🟩 Whatsapp Updates: www.whatsapp.c...
📧 Email: contact@knowledgegate.in
➡ 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
*********************************************************
For complete DBMS, check out this video: ua-cam.com/video/YRnjGeQbsHQ/v-deo.html
Someone give this guy an award, he's explaining us np problems with such an ease
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.
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 :)
i wish we had teacher like you in our university the way you explain things and logic is very good thank you sm :))))
Hii , kaisi ho?
@@yashpathak3534 simp
@@yashpathak3534 abe chapri simp
@@yashpathak3534 bhai meri hi doosri id h, all good tm btao?
You took very easy examples but it was perfectly explained. Thank you so much.
Thanks Lalatendu.. Am glad it was helpful.
No wonder why u r the best teacher 🙏
Thank you so much , For more courses and content, visit tiny.cc/yt_kgwebsite👍
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.
Thank you dear for your generous words 😍😍 keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents !
I watch your complete playlist of transactions control .....I was dammed good🔥....I wish I could attempt your offline class
Thanks a lot Sonali..Keep learning and supporting !! Do visit our website www.knowledgegate.in for more courses and contents !!
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
Plz sir 🙏 , uplaod concurrency control topic, locks, granting of locks, timestamps,deadlock, detection and recovery,security integrity violtion. Authorization,views.
will upload them soon..
When?
@@KNOWLEDGEGATE_kg SIR UR BST TEACHER .... BUS SAARE TOPICS UPLOAD KAR DO.....YE TOPICS BHI.....APRIL END SE PHELE SIR.....PLZZZ
your videos have really been helpful..plz upload SQL and ER diagram videos...thank you
Are you also watching this one day before your exams?
jisko neta banna hai, bana do!
On the morning of my exam!!
Uddipta Sarma 1 hours before exam
high five
2 days
Thank you sir, Your language and method is perfectly Understandable................
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
Awesome sir
It will be more better if u take 2,3 practice examples
Ravindra Babu sir has given us different method which is more easier. I am happy I have purchased it
standing ovation . Great Sir.Thanks a lot.
Sir your video really changed my life....May you achieve a great success and good life
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
Now i realize how stupid i am wasting a lot of time understanding what my teacher taught instead of just watching these videos
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
They are Conflict Equivalent actually
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.
we can use dependency graph. i learnt it on GateVidaylaya website.
first time samjh aaya h sir ,thank you soo much
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
sir...all your videos are the best...upload more topics
Very nice explanation sir 🙏
Sir in the first example there was no blind write still you proved the schedule as view serializable.
Also it is Conflict Equivalent , so no need to check for View equivalency .
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.
Great Explanation .
Thanks a lot Prakhar.. keep learning. Do visit our website www.knowledgegate.in for more courses and contents.
What difference does the bliend write make for view serializability?
Sir har possible sechdul ke liye match krna hoga kya jab Tak hum dono ko view equivalent proof nahi kar pate hai
Dependency graph and precedence graph are same or different.... please reply asap tommorrow I have exams
@@JatinGupta thank you for the ans ..
Sir please plz make videos on networking..preparing for Net exam..it will be very helpful
Sir plz upload iit tricky question for 2018. And thankyou sir it is very helpful
I am uploading topicwise.. Keep following..
can you also explain some ques like finding number of view or conflict equivalent schedule or recoverable schedules?
Sanchit sir does this DBMS tutorial also applicable for Distributed DBMS.? please let me know sir ?
Sir can you please make videos on locking and deadlocks please sir🙏🏼🙏🏼🙏🏼🙏🏼🙏🏼
Thank you for the amazing explanation!
You're very welcome! Keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses and contents !!
Extremely good explanation 💯
Glad you think so @Sahil! keep supporting & stay connected👍 Do visit our website www.knowledgegate.in for more amazing videos & contents😍
🔥Complete DBMS by Sanchit Sir: tiny.cc/DBMS_Sanchitsir_kg
🔥🔥All Computer Science Subjects by Sanchit Sir: tiny.cc/CSbundle_dbms_kg
Very helpfull sir,enjoyed as well as lerned a lot...thank you sir🙏🙏🙏
sir please make vedioes on concurrency control and dead lock.🙏🙏🙏🙏
you are such an amazing person. Life saviour for students
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.
Very helpful video.
Thanks.
share the knowledge as much as possible
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..
Wonderful teaching
Great explanation !!
Salute your efforts sir
😀 Glad you liked it, Please review our new app tiny.cc/yt_KgApp . Your review will help new audience to trust us 😄
sir please explain to find number of conflict serializable
Through precedence graph u can find
@@prabhattiwari9275 usse order pata chalta hai bhai
Sir software engineering kahan se karna chahiye ?? Pls upload videos
sir last example conflict serializable nii tha to uske all 6 serial schedule
mai kaise convert kr skte hai?
finally I got the correct explanation thank you
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
Thank you very much 🙏
You're most welcome Abhishek.. Keep learning and supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!
Kya ek shedule m ek s jayada view equivalent shedule ho skte hai
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?
Sir u are the best..🙏🙏
Thank you so much for this video...
Great explanation
Dhanyavad sir ji😆
Thank you so much sir ☺️🙏
Most welcome dear! Keep learning & supporting! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊
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
is w(a) changes a value in t1 even before commit so that in t2 r(a) see the updated value ?
In the first example...there is no blind write then how it is view serializable ?
sir plz make video on phase locking protocol plzzzzz
Best explained
Thanx a lot Ankit for continuosly following & commenting..
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
Pls uploaded video on deadlocks and to solve the deadlocks
plz upload video on polygraph..!!
Plzzzz sir upload concurrency control before net exam plz
Very nice sir
Thanks man..
Thanku so much sir ji
Nice explanation
Understood Sir!
Good! keep learning👍
T1
R(a)
W(a)
Commit
T2
R(a)
W(a)
Sir, In this schedule how many initial read and final write
👍👍thanks sir for such nice effort
Can someone explain how the first schedule is conflict serializable? If we draw a graph, won't we get a cycle ?
Sir , I just wanted to know why there is lack of good teachers in INDIA.
sir in first question there is no blind write, then how can it be view serializable?
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.
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..
Thanks Nikhil for the feedback.. We will consider it.
kuch bhi ! mai 2x mai dekhta hahaha
Thank you sanchit sir :)
Can u pls exlplain such things in english also..
Awesome 🌹🇮🇳🇮🇳
Sir what is Serialization in DBMS??
sir make video on B and B+ Tree
Yes Aditya will make that soon..
thanks sir
Anyone watching on the day of exam ?
I mean before 2 hours of exam
Sir,how in 1st example it is conflict serializable?
Make precedence graph and u will see that there is no cycle
sir in first example no blind write but it is view serializable .. how ??
thanks sir
You are welcome..
Sir please upload on compiler design
sir plz upload B and B++ tree
Love you man
your videos work like a charm!
thanks sir...
awesome
What will be the output if I do that 132 order ?
at 8:00 "b ne hi initial read kiya" should be replace with "T1 ne hi initial read kiya."
BTW thanks for great lectures!
My book says there is method of labeled precedence graph
Is this playlist enough for GATE and interviews? Also can anybody share their notes for these videos? It'd be a great help!!!
Yess sure !! Np but how can I share them??
@@harshshah9962 how about sharing the drive link?
@@samriddhijain1651 okay I will share it here ! Right now i am making notes of it so wait for few minutes 😄
@@samriddhijain1651 drive.google.com/file/d/19MUL1Qy9lCEzCkO8aGyyIYCuVJojIPjL/view?usp=drivesdk
@@harshshah9962 Thanks a lot! Have you made notes for other videos as well?
Nice Sachin Don International
Could you please explain how you drew the serial schedule?