Your knowledge about the subject is very good.... I always get questions that starts with why ? And you always give the correct and clear answer Thanks you sir
sir u are the best teacher i've ever seen . U have such amazing teaching skills that students leave with no doubts after seeing your video . I have been using ur channel for all my college exam subjects sir and i also recommend your channel to my fellow mates. U are great !
17 s exam h mere final year or Dbms mera 3sem m tha mujhe bilkul smjh ni ata tha aaj m lecture 80 tak phchne wala hu or is baar to aisa lgra h paper faad k aaunga sir, or operating system, assembly language, computer networks bhi aapse he pdh k Jane wala hu sir, Abb lgta h sbb back bhi clear ho jaengi achhr marks s, Thank you sir, You are providing free education to all. 😊😊🙏🙏🙏
@@shikharraj7350T2->T3 will also come in the precedence graph after performing view serializability...but still it will be a serializable schedule coz,it won't form any loop.
Sir I think there is an confusion at time3:25 because you said that if transaction is serialiaza le then it is consistent but sir it will be isolated. So, sir please check and share what is true , thankyou
9:55 while making graph, why the 2nd and third columns were not checked like we used to during conflct equivalent testing, here only 1st column was checked and then done? Does this happen in these scenarios when we assume a already series schedule then when making its graph we only check the first column?
I don't know if I am right or not, but I think only an assignment operation can be done in a blind write, as that does not depend on the previous value, that is why it is important that the last transanction (the last to update) must be the last in equivalent serial schedule. and if that is correct then the example given in this video is wrong
Sir you considered both the write operations as similar A-40 A-40 but if it is A-40 and A*3 then we won't be getting similar answers or if we take mathematical operators of different preference as per bodmas rule we'll get different answers on swapping their orders.Please explain this... @Gate Smashers
Hi please consider before scenario 1. T1's w(a) = a*10. 2.T2's w(a) = a+9. 3.T3's w(a) = a+5. a=10. Here the given schedule is not giving same final value of a as given by schedule T1T2T3. Guys if anyone finds answer please comment below.
00:02 Checking if a given schedule is conflict serializable using precedence graphs. 01:26 View Serializability determines if a schedule is conflict serializable 02:49 Absence of loops in a graph implies conflict serializability 04:22 View serializable method used for handling loops in serializability 05:44 Checking for conflict serializability in a serial schedule 07:14 A simple example to demonstrate view serializability. 08:41 View serializability ensures equivalent results despite possible conflicts. 10:00 View serializability provides additional insight into serializability beyond conflict serializability
8:40 If instead of substracting, we use multiplication for t1 and subtraction for t2, then they won't remain view equivalent. Can u elaborate on this one please.
I'm not getting it how T2 and T3 are supposed to decrement A by 40 if they haven't read the value of A first. Doesn't blind write mean that a transaction writes to a value without reading it? If T2: W(A) => A = A*3 and T1: W(A) => A = A-40 and T3: W(A) => A = A - 40, wouldn't changing order mess up the final result?
Read and write both are individual operations not connected , we can do any one at a time , write or Read both not compulsory to come together Write meaning changing the value and Read means only accessing or only reading
Better than my 2 weeks college lecture. Just 15 minutes of awesomeness!! Thank you so much sir for all these videos really helpful!!
I can bet nobody can explain this topic in such a simplest way. Thank you sir
U r one of the finest teacher i have ever scene bcoz this is my GATE time and u cleared each and every thing. Thank you so much for these videos...
clear hua?
@@surabhisonkar7920 r u also writing Gate 2022 ?
@@RR-iy1zm are u writing gate 22?
@@surabhisonkar7920 😂
@@surabhisonkar7920 same doubt bro
I don't know Hindi well but I can always count on you. Thank you, sir.
Tomorrow is my DBMS semester exam, wish me luck!
Jss mai h kya 😂😂😂
@kunal Gautam mera bhi hai , aktu 😂😂😂
@@atiqueahmed1667 KIET
@@ashishnehra5937 🙏👍
Hifi bro ..... Tomorrow is mine 😂😂
Your knowledge about the subject is very good....
I always get questions that starts with why ? And you always give the correct and clear answer
Thanks you sir
Best Explanation in the world 😍 as usual!! Thanks alot sir🙏🙏🙏🙏
Wow 👌 just amazingly explained.
Video is useful 👍
sir u are the best teacher i've ever seen . U have such amazing teaching skills that students leave with no doubts after seeing your video . I have been using ur channel for all my college exam subjects sir and i also recommend your channel to my fellow mates. U are great !
So nice of you
You teach so well sir😊
Great explanation sir thanks a lot
Also provide further vedio on view serializability and locking...
Did you find further video on view serializability
Sir.. U had told to upload more videos on view serializabilty... Plz upload
actually its a NP Complete problem so thats why sir might have not posted a video on that
@@jailohana9030 what is NP complete problem?
@@GauravSharma-gw7lb very difficult to solve?
@@xixnecroxix not very difficult , but has a huge time complexity....every np complete problem has a time complexity of 2^n
ua-cam.com/video/Ewzmv2jBlmM/v-deo.html
Thank you so much ❤your are the best teacher
Love from Pakistan 🇵🇰
best explanation on test for serializibility by far
17 s exam h mere final year or Dbms mera 3sem m tha mujhe bilkul smjh ni ata tha aaj m lecture 80 tak phchne wala hu or is baar to aisa lgra h paper faad k aaunga sir, or operating system, assembly language, computer networks bhi aapse he pdh k Jane wala hu sir, Abb lgta h sbb back bhi clear ho jaengi achhr marks s, Thank you sir, You are providing free education to all. 😊😊🙏🙏🙏
kya hua exam me?
best,you are the best teacher.
thank you varun sir...
Funnily you are the best teacher with the worst cameraman , thank you sir for your wonderful lectures
I think your channel is better for gate or other exam not for semister exam
Last m sir "thank u " bol rhe the
I was like "thanks to UUUU" ..MERA CONCEPT clear kr diya 😂😂😂 ....thanks to uuu😂😂❤
Are sir ji maja aa gya
Us bro us tomorrow is also my exam 😅
the only playlist that can save me from the college course!!!
Ek no sir... Tusi great ho
Amazing explanation sir !! The way you convey your knowledge is mind blowing
Very nicely and easily explained
sir! please upload VIDEOS ON LOCK PROTOCOLS and ONE MORE DETAIL VIDEO ON VIEW SERIALiZAbility
actually its a NP Complete problem so thats why sir might have not posted a video on that
@@jailohana9030 it is np-hard not complete
Really Awesome Sir...
haha not Indian but I managed to understand everything you said :) excellent work! thanks. (maybe add subtitles?)
Thank You.. Sure very soon
@@GateSmashers Sir can you pls add remaining part of view serializability,it is incomplete,and no other yt'rs explain properly.
awesome lecture sir
Sir kindly complete remaining view serializability part.
actually its a NP Complete problem so thats why sir might have not posted a video on that
Awesome Clear concept
Best explaination sir
Truly amazinggg😊😍
God bless you sir
Thank you sir 🙏🏻
Great teacher
At last T2 -> T3 will also come
But it wont be resulting in a cycle!
Will it be serializable or not???
It wont serialize
@@shikharraj7350 serializable
@@shikharraj7350T2->T3 will also come in the precedence graph after performing view serializability...but still it will be a serializable schedule coz,it won't form any loop.
Thank you so much 💓 💗 💛 💖 ☺️ ♥️
Thank You Sir .... please upload video on view serializability also.
Thank you..15 min me samaj agya..❤
Tera bhi kal DBMS h kya? 😂
@@ShubhamBarnwal03 na bhai amar ei Wednesday te 😆
Sooooooo good sir.😎👌
awesome sir , aslo we can check conflict equivalence by changing the posn of non conflict pairs
bhaisaab bhagwan ho aap.....
itni asanise kaise .......
chalo almost there ..
sir your way of teaching is just amazing
Completed every videos they r so awesome. Thnq so much sir ✌🏼🇮🇳
doubt sir at 10:52 in precedence graph why didn't check T2->T3 as write(A) and write(A) are conflict schedule pairs ??
T2->T3 hoga,but tabbhi loop nahi hoga
I am watching video in the exam hall after getting the paper 📜.
Clear explanation bro 👍👍
You teach great. Keep it up🤘
10/12/2024 DBMS exam
Same😂
1.30 pm exam he 3 am padhna start kia 😄
9/12/24
09/01/2025 DBMS
@@vanshtamta9448college bata?
Wonderful explanation...
Thankk you very Much Sir.........
Thanks Sir ...plz upload video on locking protocols..
Watching it before 1 hour of my exam 😅
Great sir👍
Thank You 😭😭
Sir I think there is an confusion at time3:25 because you said that if transaction is serialiaza le then it is consistent but sir it will be isolated. So, sir please check and share what is true , thankyou
Sir please make a video on VIEW SERIALIZABLE.. 🙏
Good job
Nice explanation
Thanku brother❤
excellent nice way of explaining
01/01/2025 DBMS exam 😢, A new day of the new year will begin with a DBMS exam. 😅🎉😅
😂😂 L.J UNIVERSITY WITH DIFFERENCE😂
US BRO US😢
9 ko hai bhai
@ bro, who said ?
Nice content...thank you!!!
Great
Thank you sir 🙏
Thanku sir 🙏🙏
Thanks Sir.
Thank you sir for such wonderful course ♥️♥️☺️☺️
Thanku so much sir ji
Sir pls solve out my confusion
thank u sir !!
9:55 while making graph, why the 2nd and third columns were not checked like we used to during conflct equivalent testing, here only 1st column was checked and then done? Does this happen in these scenarios when we assume a already series schedule then when making its graph we only check the first column?
I don't know if I am right or not, but I think only an assignment operation can be done in a blind write, as that does not depend on the previous value, that is why it is important that the last transanction (the last to update) must be the last in equivalent serial schedule.
and if that is correct then the example given in this video is wrong
Super
Sir you considered both the write operations as similar A-40 A-40 but if it is A-40 and A*3 then we won't be getting similar answers or if we take mathematical operators of different preference as per bodmas rule we'll get different answers on swapping their orders.Please explain this... @Gate Smashers
7:44 if the operations would have been A+=40 , A*=2, a+=10 then the out put would have been different
Operations area only addition and subtraction I think.
thank you so much for awesome explanation, sir please make video on data structure as my kvs exam is on 23 dec...
Hope you're graduated now🎉
Are you married ❤❤
Sir please upload more videos on view 🙏
Hi please consider before scenario
1. T1's w(a) = a*10.
2.T2's w(a) = a+9.
3.T3's w(a) = a+5.
a=10.
Here the given schedule is not giving same final value of a as given by schedule T1T2T3. Guys if anyone finds answer please comment below.
same question I have
addition is cumulative so that's why it worked but what about division and multiplication!!!
I guess it is non Seriealizable
t1-t3-t2 is the correct seq
Sir at 10:33 the values of conflict serializibilty it will form a loop since w-w also conflict
thnkk u so much sir ji.
00:02 Checking if a given schedule is conflict serializable using precedence graphs.
01:26 View Serializability determines if a schedule is conflict serializable
02:49 Absence of loops in a graph implies conflict serializability
04:22 View serializable method used for handling loops in serializability
05:44 Checking for conflict serializability in a serial schedule
07:14 A simple example to demonstrate view serializability.
08:41 View serializability ensures equivalent results despite possible conflicts.
10:00 View serializability provides additional insight into serializability beyond conflict serializability
amazing!!!!
Thank you
Thank you sir.....
8:40 If instead of substracting, we use multiplication for t1 and subtraction for t2, then they won't remain view equivalent. Can u elaborate on this one please.
Bro there can only be add or subtract in transaction point of view .
So there can't be multiplied
why lol@@kirtanvaja8848
sir plz upload the remaining parts of view serializable.
Can u plz add the video of view serializabilty.
Awesome explanation by the way. May u hit 1M subscribers in 2021.
How did you swap w(A) & w(A) in view serializability , as you taught you cannot swap conflicting pairs ?j at 9:11
Watching this 2 days before my final exam💀
Same bro sppu bolte
Playback speed 1.25x check it and save time
I'm not getting it how T2 and T3 are supposed to decrement A by 40 if they haven't read the value of A first. Doesn't blind write mean that a transaction writes to a value without reading it? If T2: W(A) => A = A*3 and T1: W(A) => A = A-40 and T3: W(A) => A = A - 40, wouldn't changing order mess up the final result?
agree
@@trikha23 I think, when T1 is writing that value will be there in the shared memory
@@trikha23 me to
Read and write both are individual operations not connected , we can do any one at a time , write or Read both not compulsory to come together
Write meaning changing the value and Read means only accessing or only reading
Tomorrow is my 4th sem exam thank you sir ❤
Are you single?
sir, please make some video on recovery and deadlock, your explanation is too good
Thanku p much sir ji
thank you for everything, sir. When will you upload he video for view serializability?
actually its a NP Complete problem so thats why sir might have not posted a video on that
Wish me luck Varun Sir Tomorrow is my exam🙂
Easiest Explanation