Lec-85: Why View Serializability is Used | Introduction to View Serializability | DBMS

[@mohitpandya_2228]

Better than my 2 weeks college lecture. Just 15 minutes of awesomeness!! Thank you so much sir for all these videos really helpful!!

[@kunalgautam8312]

Tomorrow is my DBMS semester exam, wish me luck!

[@atiqueahmed1667]

Jss mai h kya 😂😂😂

[@ashishnehra5937]

@kunal Gautam mera bhi hai , aktu 😂😂😂

[@kunalgautam8312]

@@atiqueahmed1667 KIET

[@kunalgautam8312]

@@ashishnehra5937 🙏👍

[@giriyaram281]

Hifi bro ..... Tomorrow is mine 😂😂

[@crackthegate6047]

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

[@surabhisonkar7920]

clear hua?

[@RR-iy1zm]

@@surabhisonkar7920 r u also writing Gate 2022 ?

[@AbsolutePain]

@@RR-iy1zm are u writing gate 22?

[@soubhagyabehera6730]

@@surabhisonkar7920 😂

[@shakuntalakamade]

@@surabhisonkar7920 same doubt bro

[@annmariageorge2209]

I don't know Hindi well but I can always count on you. Thank you, sir.

[@PradeepKumarIIITD]

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

[@22C115SHRIVAISALINILCK]

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 !

[@GateSmashers]

So nice of you

[@doesntknkw]

Us bro us tomorrow is also my exam 😅

[@sonalkumari6483]

Sir.. U had told to upload more videos on view serializabilty... Plz upload

[@jailohana9030]

actually its a NP Complete problem so thats why sir might have not posted a video on that

[@GauravSharma-gw7lb]

@@jailohana9030 what is NP complete problem?

[@xixnecroxix]

@@GauravSharma-gw7lb very difficult to solve?

[@asv520]

@@xixnecroxix not very difficult , but has a huge time complexity....every np complete problem has a time complexity of 2^n

[@anattempt3240]

kzbin.info/www/bejne/e6jdnqlon6efo68

[@prachipatil5996]

Best Explanation in the world 😍 as usual!! Thanks alot sir🙏🙏🙏🙏

[@abrarpawar745]

Sir kindly complete remaining view serializability part.

[@jailohana9030]

actually its a NP Complete problem so thats why sir might have not posted a video on that

[@khsprashanth]

sir! please upload VIDEOS ON LOCK PROTOCOLS and ONE MORE DETAIL VIDEO ON VIEW SERIALiZAbility

[@jailohana9030]

actually its a NP Complete problem so thats why sir might have not posted a video on that

[@kunalbabbar7399]

@@jailohana9030 it is np-hard not complete

[@Harpreetkaur-fd5fu]

Great explanation sir thanks a lot Also provide further vedio on view serializability and locking...

[@yogeshpalode6197]

Did you find further video on view serializability

[@ashwin_Naik.Cinematics]

At last T2 -> T3 will also come But it wont be resulting in a cycle!

[@shikharraj7350]

Will it be serializable or not???

[@karunbolli1873]

It wont serialize

[@RajuKumar-qt6xf]

@@shikharraj7350 serializable

[@you_tube7755]

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

[@pabusinghrathore4597]

Last m sir "thank u " bol rhe the I was like "thanks to UUUU" ..MERA CONCEPT clear kr diya 😂😂😂 ....thanks to uuu😂😂❤

[@susmasyangtan5536]

Wow 👌 just amazingly explained.

[@GauravSingh-wp6gx]

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. 😊😊🙏🙏🙏

[@Feelingsforever]

kya hua exam me?

[@hibamariam4405]

best explanation on test for serializibility by far

[@BhagatBhutale..]

Video is useful 👍

[@HMMMMMM-tw6ri]

Funnily you are the best teacher with the worst cameraman , thank you sir for your wonderful lectures

[@SrivatsaMalipatil]

the only playlist that can save me from the college course!!!

[@mansibhalla01]

best,you are the best teacher. thank you varun sir...

[@akhibhatt1862]

Very nicely and easily explained

[@shreyagawande4062]

Amazing explanation sir !! The way you convey your knowledge is mind blowing

[@Nitesh22upsc]

awesome sir , aslo we can check conflict equivalence by changing the posn of non conflict pairs

[@rati1962]

Thank You Sir .... please upload video on view serializability also.

[@AmitSharma-cx4ik]

Best explaination sir

[@rajeshpanwar4406]

Great teacher

[@sarthakgupta9858]

sir your way of teaching is just amazing

[@satyammaurya5503]

Are sir ji maja aa gya

[@Nora-lh3zs]

haha not Indian but I managed to understand everything you said :) excellent work! thanks. (maybe add subtitles?)

[@GateSmashers]

Thank You.. Sure very soon

[@lavishgarg5090]

@@GateSmashers Sir can you pls add remaining part of view serializability,it is incomplete,and no other yt'rs explain properly.

[@mightygerman]

Really Awesome Sir...

[@anuraghivare5875]

Thankk you very Much Sir.........

[@crazeeealgorithms3236]

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.

[@VikasSingh-yw3lp]

same question I have addition is cumulative so that's why it worked but what about division and multiplication!!!

[@shreeyagaikwad54]

I guess it is non Seriealizable

[@asifaziz9308]

t1-t3-t2 is the correct seq

[@aditi7563]

In books w(A) - w(A) is not marked

[@prathameshpatil5373]

Ek no sir... Tusi great ho

[@mrunalshende1663]

bhaisaab bhagwan ho aap..... itni asanise kaise ....... chalo almost there ..

[@SONUKUMAR-nw5kr]

Awesome Clear concept

[@asitkumarsahu5211]

Thanks Sir ...plz upload video on locking protocols..

[@akbarmirza4983]

Thank You 😭😭

[@priyafoujdar4877]

thank you so much for awesome explanation, sir please make video on data structure as my kvs exam is on 23 dec...

[@rolln1157]

Hope you're graduated now🎉

[@movieout5868]

Are you married ❤❤

[@smrjt9102]

Completed every videos they r so awesome. Thnq so much sir ✌🏼🇮🇳

[@khushbukushwah4991]

Thank you

[@shreyashachoudhary480]

Great

[@saptarshichattopadhyay8234]

Thank you so much 💓 💗 💛 💖 ☺️ ♥️

[@nayanjadhav4672]

Playback speed 1.25x check it and save time

[@sabihafirdous1345]

Sir please make a video on VIEW SERIALIZABLE.. 🙏

[@baljeetkaur0120]

Wonderful explanation...

[@manpreetkaur-lx9ci]

Thanks Sir.

[@himanshutripathikecstudent39]

thank u sir !!

[@ankitathakur5989]

Thanku so much sir ji

[@atleticoderojo]

Thank you..15 min me samaj agya..❤

[@ShubhamBarnwal03]

Tera bhi kal DBMS h kya? 😂

[@atleticoderojo]

@@ShubhamBarnwal03 na bhai amar ei Wednesday te 😆

[@dineshrockzz4428]

Truly amazinggg😊😍

[@jishuadhikary4644]

Tomorrow is my DBMS semester exam 😅

[@Infinityrush11]

Watching it before 1 hour of my exam 😅

[@PratimaYadav-bg3ug]

Thanku sir 🙏🙏

[@ujjwalparashar3461]

Thanku brother❤

[@abhijeetmishra3795]

I am watching video in the exam hall after getting the paper 📜.

[@AbhishekKumar-wp4cs]

Thank you sir 🙏

[@ankitathakur5989]

Thanku p much sir ji

[@sangdilbiswal30]

7:44 if the operations would have been A+=40 , A*=2, a+=10 then the out put would have been different

[@musicmysoul6060]

Operations area only addition and subtraction I think.

[@MuhammadAfzal-pl2sp]

Good job

[@udaymore8061]

Thank you sir.....

[@sujan.g5022]

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

[@gajendrawagadre4481]

Sooooooo good sir.😎👌

[@abhaypatel787]

Nice explanation

[@prithiviraj5848]

Clear explanation bro 👍👍

[@yjyoti1486]

Great sir👍

[@sahilsharma7013]

One more video on view serializability is required to fully understand concept

[@twinklegarg1413]

Sir pls solve out my confusion

[@subashsingla6086]

excellent nice way of explaining

[@animationcrust1993]

Thank you sir for such wonderful course ♥️♥️☺️☺️

[@anickkhan]

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?

[@pranavgupta7343]

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

[@Angela-Gee]

sir plz upload the remaining parts of view serializable.

[@anirudhatalmale5575]

Easiest Explanation

[@sajansekhu8785]

thnkk u so much sir ji.

[@ananaygupta1559]

Can u plz add the video of view serializabilty. Awesome explanation by the way. May u hit 1M subscribers in 2021.

[@phenomgkt7975]

You teach great. Keep it up🤘

[@ParthTheMehta]

besttt

[@nibir24]

thank you,sir

[@kajalpawar7771]

Sir please upload more videos on view 🙏

[@Jaishreeram23060]

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

[@akshaygupta1331]

sir pls add videos on view serializability

[@codeincamp]

sir, please make some video on recovery and deadlock, your explanation is too good

[@riyavora8775]

Nice content...thank you!!!

[@happycoding5163]

amazing!!!!

[@MayankVerma048]

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?

[@trikha23]

agree

[@abhijeetchauhan4111]

@@trikha23 I think, when T1 is writing that value will be there in the shared memory

[@harshalvijaywargiya8092]

@@trikha23 me to

[@rachana__bod9555]

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

[@arjushaikh8268]

Watching this 2 days before my final exam💀

[@gauravborse7895]

Same bro sppu bolte

[@mvenkataadityaprakash9485]

Sir at 10:33 the values of conflict serializibilty it will form a loop since w-w also conflict

[@kshitizjaiswal6870]

First of all A = A-10 is not a write operation it is any READ->WRITE operation because first old value will be read and then new value will be written. So here example whould be of a blind write for example A= Val Hence your example is faulty @Gate Smashers kindly check this

[@palaksud825]

Sir please add some more videos that are entirely about view equivalence ..please

[@arghyadeepmandal4458]

kzbin.info/www/bejne/fHvXlpSpjaaFrsk -> for second part of view serializability 🙂

[@14tajmohammadansari39]

❤

[@abhijeetchauhan4111]

thank you for everything, sir. When will you upload he video for view serializability?

[@jailohana9030]

actually its a NP Complete problem so thats why sir might have not posted a video on that

[@janjua815]

👍

[@Nagasuhas_M]

sir please make a video about triggers by the way nice explanation following all your videos thank you

[@arnavchauhan9637]

doubt sir at 10:52 in precedence graph why didn't check T2->T3 as write(A) and write(A) are conflict schedule pairs ??

[@soumyajitsamanta3310]

T2->T3 hoga,but tabbhi loop nahi hoga

[@rupshanandy8687]

Tomorrow is my 4th sem exam thank you sir ❤

[@movieout5868]

Are you single?

[@shalujain29_07]

Wish me luck Varun Sir Tomorrow is my exam🙂

[@rahulroy9785]

detailed video of view serializability needed........i have my exam day after tomorrow XD