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 !
@@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.
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. 😊😊🙏🙏🙏
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
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'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
Sir, as you said in the video that there will be another detailed video on view serializability. But there is none on this playlist. Please provide one as the concept was not properly discussed here. You just made a random schedule, S_prime and showed they are view equivalent. But there is no explanation on how this schedule came. Also, in the T_1 txn on S_prime schedule, value of A is different compared to S schedule. Then how can it be finally serializable?
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
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.
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.
Hi Sir , I have not found any lecture releated to strict recoverability and view serializablilty in detail .You have told in lecture that we would see these topic in next lecture however I did not find it.Could you please give me link?
At 5:45 you just swap position of adjacent pair W(A) of T1 and W(A) of T2. But this is a conflict pair. And positions of these two cant be changed as per CONFLICT EQUIVALENT SCHEDULE. Please clear this doubt.
Better than my 2 weeks college lecture. Just 15 minutes of awesomeness!! Thank you so much sir for all these videos really helpful!!
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
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 😂😂
I don't know Hindi well but I can always count on you. Thank you, sir.
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
Us bro us tomorrow is also my exam 😅
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
ruclips.net/video/Ewzmv2jBlmM/видео.html
Video is useful 👍
Wow 👌 just amazingly explained.
You teach so well 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 !
So nice of you
Best Explanation in the world 😍 as usual!! Thanks alot sir🙏🙏🙏🙏
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?
Are sir ji maja aa gya
best explanation on test for serializibility by far
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
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
Great explanation sir thanks a lot
Also provide further vedio on view serializability and locking...
Did you find further video on view serializability
Thank you sir 🙏🏻
Very nicely and easily explained
awesome lecture sir
best,you are the best teacher.
thank you varun sir...
Really Awesome Sir...
Ek no sir... Tusi great ho
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.
God bless you sir
Best explaination sir
Awesome Clear concept
Last m sir "thank u " bol rhe the
I was like "thanks to UUUU" ..MERA CONCEPT clear kr diya 😂😂😂 ....thanks to uuu😂😂❤
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?
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
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
the only playlist that can save me from the college course!!!
Truly amazinggg😊😍
Great teacher
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.
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
Thank You Sir .... please upload video on view serializability also.
Amazing explanation sir !! The way you convey your knowledge is mind blowing
Thank you so much 💓 💗 💛 💖 ☺️ ♥️
Wonderful explanation...
awesome sir , aslo we can check conflict equivalence by changing the posn of non conflict pairs
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?
bhaisaab bhagwan ho aap.....
itni asanise kaise .......
chalo almost there ..
Clear explanation bro 👍👍
Sooooooo good sir.😎👌
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
Sir, as you said in the video that there will be another detailed video on view serializability. But there is none on this playlist. Please provide one as the concept was not properly discussed here. You just made a random schedule, S_prime and showed they are view equivalent. But there is no explanation on how this schedule came. Also, in the T_1 txn on S_prime schedule, value of A is different compared to S schedule. Then how can it be finally serializable?
Thankk you very Much Sir.........
Thanks Sir ...plz upload video on locking protocols..
Thank You 😭😭
Thank you..15 min me samaj agya..❤
Tera bhi kal DBMS h kya? 😂
@@ShubhamBarnwal03 na bhai amar ei Wednesday te 😆
sir your way of teaching is just amazing
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
Still doubt in View serializibility? What is it?
Great sir👍
You teach great. Keep it up🤘
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.
Thanku sir 🙏🙏
Thanku brother❤
excellent nice way of explaining
Thank you sir 🙏
thank u sir !!
Thanks Sir.
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
Completed every videos they r so awesome. Thnq so much sir ✌🏼🇮🇳
Thank you
Thanku so much sir ji
How did you swap w(A) & w(A) in view serializability , as you taught you cannot swap conflicting pairs ?j at 9:11
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
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 ❤❤
Watching it before 1 hour of my exam 😅
Sir please make a video on VIEW SERIALIZABLE.. 🙏
Nice explanation
Playback speed 1.25x check it and save time
Nice content...thank you!!!
Tomorrow is my DBMS semester exam 😅
Good job
Great
Super
Thank you sir for such wonderful course ♥️♥️☺️☺️
I am watching video in the exam hall after getting the paper 📜.
ruclips.net/video/FJteasXARxg/видео.html -> for second part of view serializability 🙂
Sir at 10:33 the values of conflict serializibilty it will form a loop since w-w also conflict
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
thnkk u so much sir ji.
Thank you sir.....
In books w(A) - w(A) is not marked
sir plz upload the remaining parts of view serializable.
sir, u said that we can swap only if the instructions are non conflicting. but here u have swapped the conflicting instructions w(A) and w(A).
Thanku p much sir ji
Hi Sir , I have not found any lecture releated to strict recoverability and view serializablilty in detail .You have told in lecture that we would see these topic in next lecture however I did not find it.Could you please give me link?
sir pls add videos on view serializability
Can u plz add the video of view serializabilty.
Awesome explanation by the way. May u hit 1M subscribers in 2021.
Sir pls solve out my confusion
thank you,sir
amazing!!!!
Sir please upload more videos on view 🙏
At 5:45 you just swap position of adjacent pair W(A) of T1 and W(A) of T2. But this is a conflict pair. And positions of these two cant be changed as per CONFLICT EQUIVALENT SCHEDULE.
Please clear this doubt.
Bro we can't change in conflict serializability
Here it fails
So we use view serializability
We just swap by view in order to check