8.10 Serial Schedule and Non Serial Schedule in Transaction DBMS

[@KNOWLEDGEGATE_kg]

For complete DBMS, check out this video: kzbin.info/www/bejne/j4PRm3qbhsemfrM

[@Punktv-356]

Bkl you are not teaching you are just complicating things Jo padha tha wo bhi bhul gaya tere chutiya lecture dekh ke

[@imalinasahoo]

Exactly, I year ago, you uploaded this video and today I am studying these topics since I have the semester exams tomorrow. I must say that you have cleared all my concepts which my college teachers were never able to. Thanks Sanchit Sir, you are a true savior.

[@7franky7777]

Are you placed now

[@lifeisfun7391]

All teachers should watch this video and learn from this amazing man ! After watching these videos i realized that teachers can also be so good and anti boring ! I wish all teachers could teach like that . ......."Sir please also start making lectures for teachers on how to teach a subject"........

[@jayantjadhav9566]

probably best explanation on youtube of scheduling....

[@KNOWLEDGEGATE_kg]

Thanx a lot Jayant.. Keep following..

[@Anushka20037]

true even after 6 years still the best

[@chloekimball536]

YOU ARE A HERO SIR. THE WAY YOU TEACH WITH STORIES AND IN SIMPLE LANGUAGE MAKES MME RETAIN EVERYTHING

[@Ankit-we8ym]

No words other than awesome explanations.Thank you very much

[@KNOWLEDGEGATE_kg]

God bless you Ankit..

[@amritpalkaur5811]

I think my teacher frstly see your video, then explain us in class ... you r awesome sir

[@artattraction8728]

thankyou so much for awesome explanation 😊

[@KNOWLEDGEGATE_kg]

You are welcome.. Keep following & work hard..

[@jashanpreet.753]

Rev // har ek program transaction nahi hota, jo program atomic ho vo transaction hota hai // a set of instructions is a program, from a programmers perspective partial execution of a program is ok, but for the user it is not ok as user sees atomic result (as in case of transaction) // dbms ka konsa module atomicity ka dhyaan rakhta hai - transaction management component (ensures atomicity) // isolation doesnt refer to the physical isolation ki ek time pe ek hi cheez hogi, instead we can define it by saying // if a transaction is executing actually isolately (alone) or it is executing with a number of transactions but the result is same in both cases then we say that the transaction follows isolation // concurrency control component ensures isolation // durability - changes made should persist, taken care by recovery management component // benefit of partially committed - taaki aage koi dikkat aajaye toh we can easily rollback // we cannot rollback a committed transaction, however we can a write a new transaction to compensate the harm done by this transaction, such a transaction is called compensating transaction. // dirty read - uncomitted transaction ki value read karna // unrepeatable read - ek value ko 2 baar read kare aur dono baar value alag alag aaye // phantom read problem - can't read this variable now because this variable is now deleted // blind write - jab koi transaction kisi value ko read kiye bina usko write kare // serial schedule and non serial schedule // transactions ki koi bhi independent instructions aap miss nahi kr sakte, jitni hain utni execute hongi hi // context switching is allowed but ham kisi transaction ke andar ka sequential order change nahi kar sakte // serial - jab tak ek transaction pura khatam nhi hota tab tk dusra start nahi kar sakte. If we have n transactions then total different serial schedules we can design are n! // non serial - one or multiple context switches take place // In serial even if no concurrency - concurrency gurranteed (safe) // In non serial problem may occur (unsafe)

[@AARUSHIGARG-i3i]

thanks buddy

[@namanjain6153]

amazing sir, We believe that you are our savior in exam_time...thnks!!1

[@rajnikantsoni8808]

Sir thanks for nice explanation. Please upload videos about locks.

[@jaydalsaniya6986]

Thank u for sparing your precious time for us...

[@yatirathore9965]

Thankyou very very very much sir best explainations of every topic you are great...... very simple and straightforward love every vedio of yours litèrally 🎗

[@ayushmehta7083]

Thank You Got Some Good Help♥️♥️♥️

[@vishal-sg1np]

Thank you sir! You have explained it in so simple way😎😎

[@anshulthakur3806]

Sir, your smile is very cute :), and lectures are best as always

[@udubey2343]

Hello Sir Good Evening I have a question is their any 6.10 video that is missing here ? Or its a numbering mistake for video no allocation?🤔 Please provide me Answer Sir

[@jayachowdhary7769]

thanks a lot sir....I am preparing for rpsc programmer exam... and your videos are just awesome...

[@harjinder466]

When the programer vacancy are comming

[@RohIt_bhopali]

great content, such easy to relate scenarios.

[@parulverma9882]

The bestest teacher in the universe 🙏

[@yuvrajyadav8861]

amazing sessions sir.....

[@KNOWLEDGEGATE_kg]

Thanks a lot dear Yuvraj, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@optimizer_____2420]

just superb explanation

[@DeepakThakur-zm2bw]

sir dbms part 6.10, 6.11 missing hai, plz upload the video.

[@mrno345]

Can someone tell the nme of the topic

[@xxboxerxx95]

@@mrno345 yae hi toh suspense hai!!

[@westworld4553]

Great way of explanation

[@xyz-pc3tl]

Thanks a lot sir God bless you 🙏🙏🙏🙏

[@OmitA25]

awesome explanation

[@rupshree1833]

Kudos to your work . You are amazing sir 🙏

[@KNOWLEDGEGATE_kg]

Thank you so much 😀 Keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@DURGESHKADAM]

thank you

[@pranaygupta5845]

Sir, I have a doubt As the processor executes only one instruction, then the time taken by Transaction T1 and T2 in the case of both serial schedule and non-serieal schedule should be same as the InstructionCount(T1) + InstructionCount(T2) is constant for both the schedules. If this is the case then what is the benefit of non-serial schedule over serial schedule

[@jha_jprabhat]

While it's true that the total instruction count may remain the same in both schedules, the benefit of a non-serial schedule lies in concurrency and potentially improved system performance.

[@cosmic_voyager_]

Sir,for S1,n is number of transactions but in S2 n(i) is the number of instructions in i th transaction. Am I right sir?

[@39_ganesh_ghodke98]

Great Explanation👍

[@KNOWLEDGEGATE_kg]

Glad you liked it @Ganesh😍keep supporting & stay connected👍 Do visit our website www.knowledgegate.in for more amazing videos & contents

[@NishaSharma-nd1dk]

Thanks sir g

[@SaiDharahasReddyIndrakanti]

sir how is a non serial schedule efficient than serial won't the total time for executing t1 and t2 transaction be same in both cases and moreover won't t2 slow down the commit of t1 in non serial case because it could have happened earlier

[@deepakpandey2100]

Thank You 😊

[@KNOWLEDGEGATE_kg]

You are welcome..

[@priyankaupadhyay3663]

Mujhe nhi lgta koi bhi in sir se jyada acha pdha skta he....apki video dekh kr itna confidence ara h 😊😊😊😊🎉🎉🎉

[@KNOWLEDGEGATE_kg]

Glad you liked the content dear @priyankaupadhyay3663, thanks for watching. Stay connected for more upcoming videos & content😍

[@artattraction8728]

plz clear the difference between concurrent, parallel and simultaneously??

[@bhavya5508]

Manisha's Art Gallery concurrently means to execute bith t1 and t2 together..n that can b done in 2 ways by 1) interleaving 2) parallel processing

[@artattraction8728]

+Bhavya Arora thanku for ur ans. but clear my doubt tht. interleaving done with single processor and parallel done with multiprocessor. am i right?

[@bhavya5508]

Manisha's Art Gallery exactly right :)

[@artattraction8728]

+Bhavya Arora thankyou😊😊

[@drasian115]

Thanks a lot sir

[@KNOWLEDGEGATE_kg]

You are welcome..

[@rpkumawat8879]

Where is 6.10

[@RaviSingh-yf6jd]

Thanks sir

[@shaifaliagarwal1749]

explanation is up to mark sir

[@KNOWLEDGEGATE_kg]

Thank you, Keep Watching !!

[@abhishekkumar-os5zk]

concurrency nahi hai to concurrency guaranteed hai.... woh what a thought ....

[@aradhanasaxena8561]

All time favourite😍😍

[@brilliantboy8147]

Sir, aap please SQL me video banaye ...

[@gunjanbaunthiyal582]

What is a recoverable schedule nd cascadeless schedule ?

[@rupshree1833]

Here part 6.10 is missing Or numbering problem please rectify it .

[@KNOWLEDGEGATE_kg]

Dear Rupshree, for complete course on DBMS, please click on the link below: tiny.cc/DBMS_Sanchitsir

[@aimanalmesbahi7247]

Please sir speak in English in your next videos so we can understand what you say , because you have followers from many different countries . Thanks in advance .

[@anitapudurkar1752]

kon kon 1.5x speed ya usse jyaada ke speed se dekhta hai sir ke videos woh like kare😂

[@ankitkumaryadav1682]

2.5x se dekhte h

[@rajdoshi6781]

11:12 what is the value of n here?

[@harshaleechordiya]

Sorry sir . but i cannot find the 6:10 part .....where can i find it

[@souvikdutta3567]

Sir please upload lock based protocol related videos

[@adityatyagi898]

12:42 to 12:45. To err is human. Anyway I want to be like him.

[@malhartrivedi8365]

Sir pls make videos on deadlock system

[@badriram5649]

No one cares about those who don.t know Hindi ... Why cant people teach in English? This guy teaches everything in detail from scratch. But since i don't know Hindi I cant follow what he is telling.. :(

[@mohammedarafatlone]

Take your Duolingo classes

[@NirazanShrestha]

Is it necessary that a serial schedule must start from T1 ?

[@shalini1235]

no

[@VishalSingh-er2bl]

No he said that too

[@nitimangwani]

where is 6.10?

[@asitkumarsahu5211]

Plz upload vdo on toc...

[@KNOWLEDGEGATE_kg]

Already uploading & will upload more..

[@imyours777]

@@KNOWLEDGEGATE_kg sir two phase locking and stamp protocol nhi padhaya aapne :/ :(

[@ManishaPatel-hr6dg]

Sir Computer architecture ke video's please

[@architjindal908]

Sanchit Sir, iss video me kaafi gusse me lg rhe hai..Isn't it?

[@vinayaksharma-ys3ip]

[@shahulrahman2516]

great

[@KNOWLEDGEGATE_kg]

Thank you, keep learning & following😊

[@asitkumarsahu5211]

Same vdo uploading sir

[@Ankit-we8ym]

No big deal watch it again,you will feel better.

[@KNOWLEDGEGATE_kg]

The language must be different buddy..

[@KNOWLEDGEGATE_kg]

hahaha.. can think it this way also..

[@computerscienceresearchcen1480]

Ravula sir se acha padhate he aap dbms

[@sandeepmishra3972]

Are 6.10 nhi hai kya

[@abhinavs03]

abe hota to tujhe dikhta na?

[@surajsaha4845]

Bhai tu itna tez kaise h😮

[@sandeepmishra3972]

😁😁😅bhai aisa hi hu

[@tanshaisaxena]

Bhai bhut teez hai yrr tuu😍😍😍mtlb pt usha fail!!

[@surajsaha4845]

@@sandeepmishra3972 bhaukaal h bhai ka 🤩

[@akshitarawat1970]

I dnt understand permutations and combination part of this video

[@vermamanoranjan53]

Hiii

[@hkumar2610]

Sir please topic repeat mat kijiye ....other subject or remaining topic me lecture post kijiye

[@KNOWLEDGEGATE_kg]

Sab karenge upload.. Repeat nai kar rahe hain.. Abhi Hindi me hain..

[@KNOWLEDGEGATE_kg]

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

[@ImHinduu]

ek chhote topic ko itna bdaa kr diya........

[@Luna6537er]

am ı the only one who couldnt understand the things that he is saying because of his accent? :D

[@optimizer_____2420]

if you directly watching this then you might be only one.

[@AvinashSingh-bk8kg]

Agree with@optimizer___

[@ankitathakur5989]

Thanku so much sir ji

[@adityatyagi898]

12:42 to 12:45. To err is human. Anyway I want to be like him.

[@RahulKumar-zv6pp]

Where is 6.10 ??

[@kuldeepgngwr2096]

Where are 6.10

[@09faizan]

Thankyou very much sir

[@KNOWLEDGEGATE_kg]

Most welcome dear.. keep learning and supporting !!