8.19 Strict Schedule in DBMS

📝 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 Plus-2025: www.knowledgeg... ➡ Contact Us: 👇 🟩 Whatsapp Chat: wa.me/91859512... 📞Call on: [phone] 🟦 Telegram Updates: t.me/kg_gate 🟩 Whatsapp Updates: www.whatsapp.c... 📧 Email: [e-mail] ➡ 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
*********************************************************

[@KNOWLEDGEGATE_kg]

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

[@KNOWLEDGEGATE_kg]

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

[@vishalkumarchoudhary9433]

Sir.. bachaalo hme.. further videos upload kr do ON concurrency control techniques , multilevel index , B-trees , SQL , relational algebra Please sir... Sir, abhi half DBMS baki h for GATE...

[@premprakash8220]

sir,please upload a video on locking protocol .....please..................... because there is examinations in my university

[@swetankpandey999]

Kitne number aaye bro

[@koyalakondalalithsaicharan132]

😂😂

[@rupshree1833]

Sir you are just awesome I missed transaction and concurrency control topic during offline classes , I tried to cover this topic with reference book and your class notes,but still I was less confident confident . Now I am very much confident that I can solve any question in transaction. Your way of teaching skills is very good specially your correlation with suitable example . Kudos to you sir 🙂💪

[@KNOWLEDGEGATE_kg]

Thanks a lot dear Rupshree for your valuable feedback, all the best, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@abhishekkalburgi6839]

Your videos are just awesome , please post the remaining videos as soon as possible as we have our exams coming. 2 phase locking and Timestamp ordering algorithms , please post this lecture videos soon

[@KNOWLEDGEGATE_kg]

Thanx buddy.. will upload soon.. Keep following..

[@ManishSingh-kb9rt]

same query of mine too.

[@tarunsharma2102]

Sir you haven't uploaded yet, please make videos on remaining topics.....we're eagerly waiting for your videos.

[@railwayslovergames2378]

@@KNOWLEDGEGATE_kg sir...please when will you upload??? we are egaerly waiting??? Respect Sir!!!

[@anshurajput8025]

thnq so much sir, i watched all 62 videos and have gained satisfactoy knowledge of dbms..

[@RajveerSingh-zg9vd]

Thank you so much for explaining this much easily with easy examples ...❤❤

[@KNOWLEDGEGATE_kg]

You are welcome Rajveer! Keep learning & supporting! Do visit our website www.knowledgegate.in for more amazing videos & contents👍😊

[@merepapa350]

Sir U really have great teaching skills... Thank u very much sir for teaching us free of cost

[@chetanarya4189]

Thanks a lot sir . Please cover ER diagram topic and include more gate questions. Thanks in advance.

[@lifeisfun7391]

we really appreciate your work Sir , please try to cover as much dbms as possible for GATE .

[@ramdigitaleducation4908]

Thank You@Sir....................Your are doing the noblest work....Keep up it

[@amitmathur1909]

Thank you sir. All these videos are very very good, it clears all my doubts and improve my understanding a lot.

[@pranavsaxena4861]

Sir @ 2:48(Schedule S1), what if T2 fails after commitment of T1, won't it create problem, as T1 is writing value made by T2 to main Database. When T2 will rollback, it will seem that T2 has not done any work, but the value made by T2 will be there in main Database.

[@realbaniya]

@Pranav i totally agree with you, moreover i think it's an example of LOST UPDATE problem. But I guess he just wants to highlight a scenario wherein blind write can be present in cascade-less schedules.

[@timetogrow1306]

Sir plz ,plz plz plz plz plz upload video's on locking protocol , timestamp protocol ... This is really very useful for gate student ..

[@RaviSingh-yf6jd]

Sanchit bhai aap jaisa koi nahi sikhata

[@LearnWithAmarjeet]

You are the best sir ... Mera dbms bHuT clear ho gya aapke video se ..!! Pr er diagram or sb topic ko cover kijiYe sir please please...!! Thanks for your videos🙏🙏

[@anitathakur4590]

Thank u sir all DBMS videos are superb

[@KNOWLEDGEGATE_kg]

You are welcome.. Keep following..

[@NishaSharma-nd1dk]

Thanks sir g

[@K_Pant]

sir awesome explanation i salute you. one request please make videos on log based recovery and protocol designing(time stamp,2 phase locking etc) as soon as possible. thanku sir.

[@AIGeneratedSongs1]

you are amazing ,sir ,I watched your videos two times and never get bored for a single minute, thanks

[@preethamm.n1161]

Last diagram is awesome sir total concept is included int it Awesome sir🌹🌹🌹🇮🇳🇮🇳

[@sushmitaraj6948]

at 3:05 you said that it is a conflict serializable but actually r(a) in T1 is followed by w(a) in T2, and the 3rd prpperty is not satisfied

[@arjitsingh5816]

exactly

[@saumitrapathak6416]

2:59 confilict to hoga na??? R(a) and W(a) of T1 with W(a) of T2???

[@TheSarthak425]

Thank you sir!

[@madhusaivemulamada3556]

Simply Superb

[@harshdeep6281]

2:55 sir it is not conflict serializable, as there are two write operation working on the same variable of different transaction

[@bhargavramreddykodakandla792]

It is conflict serializable, as no loops are formed.Order T2 after T1

[@ShivamShiv007]

Too grateful to you sir.... Sir, humble request to you to also upload videos on locking procedure.... Thanks

[@saimaajaz4564]

BEST TEACHER EVER...ALLAH bless u sir

[@KNOWLEDGEGATE_kg]

Thank you :) Visit www.knowledgegate.in for more content & courses !!

[@shivampal1]

Thanks for such awesome lectures sir. Please upload more videos related to topic. Thanks in advance.

[@niteshkusagar3666]

sir your lecturers really helped me a lot in understanding dbms by well.

[@supriyasony5774]

Awesome videos.... Thank you so much sir... Plz upload video on lossless lossy and dependency preserving decomposition... Only u can explain in simplest way.....

[@bongmou2845]

Great explanation .. Thank you sir..looking forward to next videos..

[@anshulthakur3806]

Perfect explanation :)

[@SagarGupta-sx3qo]

Sir your lectures are really good. thank you for that. But i think your playlist is not arranged properly or topicwise. Please arrange it and keep all the videos of a topic at single place.

[@KNOWLEDGEGATE_kg]

Thank you Sagar.. I am in the process of sorting the playlist language & topic wise.. Soon both will be completed..

[@SagarGupta-sx3qo]

Okay sir, thanks for replying. And sir please upload complete videos on dbms and os as soon as possible.

[@purvikadel5902]

Your videos are awesome!! Please upload more videos of upcoming topics :)

[@rishabhnegi479]

awesome.....also im 1000th person to like ur video :)

[@adityajain8255]

First of all thanks sir, for the lucid lectures. Would you mind uploading the videos on concurrency control techniques?

[@mdajaz7520]

At what time could you start relational algebra Sir please, we really need it

[@KNOWLEDGEGATE_kg]

In the process but may take some time..

[@kanchivarshney3479]

I hope u soon complete the series of dbms especially b n b+ trees n the part of writing schedules sir... Hoping...

[@arohisingh1045]

Respect...🙏🙏🙏

[@indranathroy7905]

Sir your videos cleared all my doubts and concepts please upload locking protocols

[@Ankit-we8ym]

Thanks a lot .

[@KNOWLEDGEGATE_kg]

You are welcome..

[@krishnakantkumar7777]

thank you sir...yours explaination is super..!! :)

[@biplabroy1406]

As per the diagram if a schedule is strict then it is also casecadeless. But as per logic if a schedule is casecadeless then it is strict also. Because casecadeless removes only blind read and strict removes both. Please reply Sir.

[@anuragkumargupta7506]

awsm vedio dear sir . thank you sir

[@murthazashaik3934]

thanks sir now onward ur name is knowledge bahubali

[@ShaliniSingh-xc5rn]

Thanku sir

[@swamypediredla]

thanks sir, but syllabus is not completed yet, remaining topics are there like key constraints , locking protocols......etc

[@Rocking_Rudransh]

Hi sir I have watched all the video of dbms till this video I am unable to find the videos regarding transaction designing protocols. Can you please help me to cover these topics...

[@shivkrishna9917]

Sir video upload kriye aage ke pls 🙏🙏... Apke videos ki help se hi engineering ho rhi h.... 13 december se main semester h

[@dishamukre3665]

Sir could you pleaae add data mining and computer networks videos as well. We have them this sem and there is no proper source/videos. Your lectures are superb and it has helped me A LOT. Please help me this sem too :)

[@gyanendrasinghpanwar7751]

sir pls upload the remaining topic. u r beyond awesome

[@adrishmitra9809]

Please upload videos on 2 phase locking , time stamping and the remaining topics of transaction.

[@AkashSingh-zh6cf]

Sir pls upload two phase locking and time stamping..ASAP ,we need it badly..

[@sudhanshurohila3260]

Dear Sir, Your video is very good, awesome . How much time requir to post remaining video of the DBMS

[@kshitijsrivastava6148]

Sir please do upload further video.

[@chakshujain7557]

Sir, Is 'S1' schedule a recoverable schedule because I am confused about how the system will recover if there is a failure just after 'C1' commit?

[@chakshujain7557]

I think I understood it, i.e, whenever a transaction enters into commit or abort state then whatever value a data item has in the local buffer is overwritten in the database. Kindly correct me if I am wrong.

[@rachnagoyal3853]

Sir plz upload a video on ER diagram,b tree ,b+ tree and as well as gate questions related to this topic...

[@ashurawat6752]

Soo....gud teaching sir........Sir plz upload videos on locking protocols

[@Ankit-we8ym]

Please continue DBMS series

[@Shailesh_Pratap_Singh]

Sir please upload videos about locking ,2 phase locking, granularity,log based recovery ,deadlock Afterall you are awesome

[@manojprajapati444]

Sir please upload locking video I'm waiting so much because your way of teaching is so good . Thank you sir

[@dhruvildalal5899]

sir really nice videos

[@timetogrow1306]

Sanchit sir ... Your video are so awesome , .... But sir you are not upload concurrency control protocols video ... plz upload sir this is very beneficial for me .. and all gate students ... plz sir

[@DexterousGirl]

Please upload videos on locking protocol

[@cherrywakesandbakes6366]

Hello sir, have you made videos on concurrency control techniques? I couldn't find them pls help

[@thenameisavi]

sir aapne s3 ko strict bataaya but aapki definition ke according s3 strict nahi hai

[@gouravgosain8733]

good video

[@anooptomar3342]

Sir, please add videos on B and B+ trees along with gate questions.

[@manavgarg5000]

sir agar koi schedule view serilalizable hai to kya vo consistent hoga please reply krdo sir please ?

[@sumanpatnala9064]

ya it will be consistent.

[@madmax2442]

yes, because a view serializable schedule is equivalent to a serial schedule which is consistent

[@mukulbansal8269]

👍

[@krutarthkhatri5243]

Plz upload locking protocol and time stamp protocol

[@shayanyousuf6689]

Thankuu soo much sir your video's are awesome...i want to meet u sir ...

[@yashsinha511]

sir,please upload a video on protocols and next part of transactions.

[@swatichandra9893]

Sir plz upload videos on time stamping and 2-phase locking protocols

[@edge6755]

Sir when u uplaoad remaining topics of database i.e lock base;2phase locking

[@VisualEscapes1]

Sir please upload videos on concurrency control, locking protocols

[@manveesoni3571]

Sir, can you please upload the lectures on two phase locking protocol and time-stamp locking protocol.

[@chhabralovish]

Sir aagey ki videos???? Please upload it sir

[@akshaydwivedi935]

Please upload lectures on 2 pl and timestamp protocol. urgent need .

[@Ankit-we8ym]

Please take lecture on 2 pl and timestamp protocol .

[@Coolnaruto212]

Thanks sir

[@KNOWLEDGEGATE_kg]

You are welcome Rohit! Keep learning & supporting! Do visit our website www.knowledgegate.in for more amazing videos & contents👍😊

[@adityalodhi4023]

SIR ,plz upload a video on locking protocols.

[@yamisharma4879]

Sir plz locking protocol and ER diagram video..... Plz sir

[@samyaktjain698]

Sir, Please make video on locking protocol....🙏

[@hardikgarg3424]

sir please upload videos on protocol designing .

[@TOP10-f5x9c]

sir ne kaha ki cascadless h to strict hoga pr s1 cascadless h aur strict nahi can anyone explain??

[@madmax2442]

he said it the other way round.. strict is more restrictive than cascadeless

[@rajatgupta6043]

sir plz upload lectures on locking protocol

[@milanjain.2564]

Sir pls aap concurrency control techniques and log based recover and its type per vedio for University exam bna dijiye plz sir

[@shivakumarkore3871]

Sir, What about concurrency control in transactions? Pls upload.

[@kunalsingh5794]

sir , please upload video on computer network

[@ninadylan4649]

please upload 2-phase locking protocol

[@prasantkumar3845]

Protocol designing where is sir. pls upload. Half knowledge is sin.......

[@prasantkumar3845]

Sir please complete the topic ,Half glass of water is not sufficient for thrist..

[@sumantopal558]

190 likes 0 dislikes....only sancit can do!!

[@shivankgarg1692]

Sir please iss topic k aage ki videos upload kr dijiye

[@somamondal6850]

Sir please make videos on log based recovary and check point

[@nimratveerkaurbahia3814]

Sir.. concurrency control techniques ka lecture bhi de do.. thanqq

[@aakashyadav3873]

Sir please upload videos on locking protocols and timestamp

[@RaviKumar-ww1tb]

Sir please upload the transaction protocol videoes

[@antaraghosh6512]

Sir please upload protocols and other part of this chapter....