Lec-82: Introduction to Serializability | Transactions Concurrency and Control | DBMS

👉Subscribe to our new channel: / @varunainashots
Serializability is the classical concurrency scheme. It ensures that a schedule for executing concurrent transactions is equivalent to one that executes the transactions serially in some order. It assumes that all accesses to the database are done using read and write operations.
► Database Management System(Complete Playlist):
• DBMS (Database Managem...
Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
• Design and Analysis of...
►Computer Architecture (Complete Playlist):
• Computer Organization ...
► Theory of Computation
• TOC(Theory of Computat...
►Artificial Intelligence:
• Artificial Intelligenc...
►Computer Networks (Complete Playlist):
• Computer Networks (Com...
►Operating System:
• Operating System (Comp...
►Structured Query Language (SQL):
• Structured Query Langu...
►Discrete Mathematics:
• Discrete Mathematics
►Compiler Design:
• Compiler Design (Compl...
►Number System:
• Number system
►Cloud Computing & BIG Data:
• Cloud Computing & BIG ...
►Software Engineering:
• Software Engineering
►Data Structure:
• Data Structure
►Graph Theory:
• Graph Theory
►Programming in C:
• C Programming
►Digital Logic:
• Digital Logic (Complet...
---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
► Subscribe to us on KZbin: / gatesmashers
►Subscribe to our new channel: / @varunainashots
► Like our page on Facebook: / gatesmashers
► Follow us on Instagram: / gate.smashers
► Follow us on Instagram: / varunainashots
► Follow us on Telegram: t.me/gatesmash...
► Follow us on Threads: www.threads.ne...
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:
Email us at: [e-mail]
#Serializability#DBMS#freeEducationGATE

[@rutvaydhami367]

I usually dont comment on the videos. But i had to appreciate your efforts and your time to teach us sir! I am really glad to have a teacher like you! much appreciated sir ! Thank you for your kindness

[@GateSmashers]

Thank you

[@watchlistsclips3196]

@Julius Devin Hello scammer .seeing this message for 9th time in another youtube video.Same copy of the message.

[@bhuppidhamii]

Dhami-Dhami Bhai Bhai

[@bikdigdaddy]

upkaar kardia comment krke aapne

[@rushikeshjadhav1414]

I literally hate reading the PPT's and I thank you from my botom of heart for this video series as a result I am going score good marks again !

[@ShubhamGupta-mx2hn]

I am from ECE and these playlists are really helping me out to know about CSE !

[@nitishsah1060]

Same bro 🤜

[@hritijrana1409]

nah, u r far from CSE and reality.

[@with.shahid7884]

Guys having exam tomorrow 🙌

[@anamikakhare_official]

koi nii hh 😂😂😂

[@savitadixit5217]

Yess

[@ayushnamdev2415]

Today budd

[@sv798]

Ha kl hai ata kuch b ni ab playlist opn hue hai 😂😂

[@comedyadda7269]

Subha endterm ha 🙂😁

[@LIFE_OF_COPYWRITER]

You are awesome in 1.75x speed too...😎 I just love to see all my syllabus topic😄 aj bhut pdhai kr li dophar se rat tk thnkuh sir

[@coconutoil2196]

Meri exam hee kya hoga kya pata😒😒

[@vanshagrawal3056]

I am so glad that we have teachers like u! It's almost my semester end and I didn't know anything... this playlist helped me out so much. Thankyou sir!

[@sumitmorya5721]

Wo bolte hai na ki frnds ki bate Dil Orr dimak me directly jati hai wese hi ap Jo Hume pdate ho wo sb sida mind me jata hai 😍😍🤩🤩😍🤩😍

[@nehasheth3680]

Best DBMS videos on youtube!

[@goodboy8157]

Hello

[@shortsomething3010]

​@@goodboy8157 bhai ladki ka chakkar chod dooo plz

[@maybepriyansh9193]

your transaction videos convey the idea of it so well without just harping on the methods to get the answer but actually get the logic of it.

[@DeepakGupta-ky8mp]

Every day i am watching videos from this channel and every day i see increase of thousands of subscribers, that the power of great teacher.

[@aadarshpathak3314]

I can clearly see your efforts gone into making these videos sir... kisi kisi videos mein you were actually sweating but still you were teaching, it clearly shows your love towards your passion.. That's commendable sir.. Hat's Off!

[@BigyanChap]

Bhai, now that you have proved your teaching skill is amazing, you have very huge responsibility of making videos on every topic in CS.

[@MahreenSyed]

agreed!

[@shounaksarkar5229]

This Man is a perfect example of how much knowledgeable you become if you do your Engineering Course Properly without excuses

[@shairali9617]

Love you man tomorrow is my presentation I visit Manny website but cant understand but after see this video i feel too good that's a very easy topic now for me Watching at 1 Am

[@abhaypatel787]

Sir aapke padhane ka tarika 1 no hai Mere friend Rahul Sen and Rahul Kurmi to aapke fan ho gye Thank you sir ❣️

[@Rohit_15]

rahul prajapati bhi

[@asmrdimple]

Tq so much sir... 🤗U have clearly explained Each nd every topic of DBMS... One day before my exam I found thiz channel.... From bottom of my heart I'm very much thankful to you sir . It helped me a lot fr my exam🌟

[@pusaikumarm9165]

Tomorrow is my end sem and and like before also I clear my doubts here ...tnqs sir

[@coconutoil2196]

End sem😭😭😭😒😒😒

[@coconutoil2196]

Kese Gaye fir exams🤔

[@iamViratVerma]

Sir, well explained! ❤ Mere najar baar baar aapke doolo pr ja rhe theee 💪 ache maintain kr rakhe h aapne - 🤣🤣

[@FAIZANKHAN-jo9bb]

Easy language and excellent method of teaching

[@faizanahmed5243]

U saved my DBMS course!!

[@harsh-alashi]

Varun Sir doing God's work

[@harsh-alashi]

Made my day sir ji... Thank you

[@gauthamalva8701]

I'm having exams tomorow.Thank You sir...Regards from Karnataka

[@GateSmashers]

All the best

[@coconutoil2196]

​@@GateSmashers sir mere exams he😭😭

[@bismahartgallery7201]

Thank you sir bcz of your lectures ,I am going to score 4 gpa in my finals In Sha Allah❤

[@abhireshray8331]

Great Work Sir!!!!! You are my idle.

[@team94gaming39]

Sir hamari teacher pehle aap. Ke.videos se Padhke hum ko padhati hai fir bhi unka Samaja nhi aata isliye aap se hi padhta hu thanks sir❤for your best teaching

[@SriRamDasariChandra]

Great explanation, good sound quality and I see your passion for explaining stuff for future generations. Kudos to you brother.

[@sharanyak5095]

Great explanation sir

[@Suniyedekhiye]

Great teaching Sir thank you so much Sir

[@sumitmorya5721]

Sir really you are amazing 😍 and different from whole world 📚 your teaching method 👌👌👌👌👌👌👌👌👌👌👌 love you sir/bhaiya 🙏

[@kailashchand4215]

good teaching and easy language

[@monsworld6967]

sir u are great teacher ,love u ,,,from bangladesh

[@radiagulzan]

this is perfect teaching. Thank you so much!

[@SudhanshuAjit]

bahut acha samaj aata hai bhayia apka padhaya hua thank you so much

[@AdityaGW]

I am Passing Each Engineering semester only because of this MAN.. 🙏🙏

[@prakharsrivastav9416]

sir you are doing a great job such a wonderful explanation.

[@pluviophile762]

Tum bht mast kam krta h varun bhai

[@maverick0042]

Tomorrow is my exam great 👍 to be here.......

[@06ankita]

Best explanation..!!💫

[@gajendrawagadre4481]

Tq so much sir for good explaination.

[@bozainumaanalikhan2496]

Gate smasher + chatgpt great combo Any one agree with me

[@naamkaengineerhoon2587]

Pranam sirji... One of the best ❤✨

[@saadansari898]

Bhai,excellent teaching Please make more videos

[@youtubefanclub1595]

Kal exam hai or mujhe ajj rat ko yad aya ki padhna hai MOYEEE MOYEE HO GA ABB KAL TOOO 😮😮

[@Sam0fficial]

Thank you So Much 🥰💓

[@isirujay5129]

I'm from Sri lanka.. please add English subtitle for this valuable videos...

[@swatisuslade4855]

Best teaching ....thank you so much ..sir

[@davidallam4671]

Superb

[@prithvirohira1372]

Thank you so much sir !

[@VikasDube-gf2fy]

Guys Before 2-3 hours of exam 😅❤

[@ritaraniagrawal474]

Sir aapki sbhi videos bhut achchhi h aapka padaya aasani se samjh aata h Per kuchh topic per aapke videos nhi mil pate for ex recovery database

[@Karan_Rana]

Bht badiya sir 💗

[@harpreetdeol1750]

Thank you sir 🙏 bottom of heart👍🏻👍🏻

[@sarveshkhire415]

Wonderful explanation

[@dhaneshpt8641]

Thank you....

[@saptarshichattopadhyay8234]

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

[@abdulraheem1264]

Sir...ur effort for making us understand the stuff is gracious 😍😍😘😘

[@manishvlog240]

Bhai aapse hi padh ke ja rha huu .. Aapki dua chahiye bhai pass hone ke lia.. You are the graet 🔥❤️🙏

[@cmboutique3570]

Thank you so much sir

[@Bazriya-p1f]

Exam khtam hone k baad..... present plz 🙋☺️......

[@pratyushbhardwaj9202]

00:00 Serializability is an important topic in database transactions. 01:10 The given schedule is a serial schedule. 02:18 Understanding serial and serializable schedules 03:27 The given schedule is a parallel schedule with a loop 04:33 Understanding serializable schedules 05:47 There are two ways to achieve serializability: conflict serializable and view serializable. 07:01 Parallel schedule can be made serializable in 6 ways 08:13 Serializability means finding a serial clone of a parallel schedule.

[@samcreations1395]

Which ai you use?

[@keerthi7658]

I usually don't comment on KZbin videos but for the first time i felt I should do. The way u teach is awesome and very clear concept

[@gulnazshamsi981]

Thnks sir for making hlpful videos for us ..

[@RanjeetSingh-yh4ki]

best Explaination

[@VaibhavPawar-s7f]

Sppu DBMS exam tomorrow

[@narenbalus5611]

you are a life saver

[@dhaneshasalekar821]

Best explanation 👍👌

[@aminanisarahmad5815]

Very good method .....from pakistan🇵🇰

[@rakhithakur9415]

Consider the following schedule: SCHEDULE: r1(P), w2(P), r3(P), r1(Q), r4(R), w2(Q), r1(S), w3(S), r4(S), w4(Q), w5(Q), w5(R) Is this given schedule conflict serializable? If yes, prepare a precedence graph and write the order of execution for transactions? How to solve this question?

[@aryanmishra7310]

Sir if a schedule is serializable then does that mean that we will convert the parallel schedule to serial actually? If yes then how will we get the benefits of parallel schedules and how will be get rid of drawbacks of serial schedules?

[@jamespottex5197]

Very simple explanation keep it up sir

[@Missiionnn360]

Great way as usual 👍👍

[@bhargavi1164]

sir can u upload the remaining topics of transactipn management and storage and indexing concepts can u uplod these concpts also sir

[@chandunn8403]

Well explained sir 😁 thank you so much

[@trilokinathji31]

Hi Sir, I have not found any video releated to strict recoverability and how view serializable schedule works.Could you please help me to get it?

[@vijaysinghal3539]

Thank u sir U clear my concept

[@rakeshkumargupta6754]

Strict schedule wala topic per video bana dijiye please please... Sir

[@mr.gamertech9]

ASSALAM.U.ALAIKUM Thanks SIR ALLAH PAK BLESS YOU ALL AMEEN

[@sumitranjanjhaaa]

Today is my exam of DBMS at 2pm MDU HARYANA 😢😢😢

[@aduandrewtat]

very nice thaks alot heartly bro

[@rachnaar2054]

Where's the video of strict Cascadeless schedule? Pls provide link.

[@criminal12886]

Thankyou sir

[@snapcast]

00:01 Serializability is crucial for database transactions. 01:11 Introduction to Serializability 02:18 Understanding serializability in transaction execution 03:24 Understanding the difference between serial and parallel schedules. 04:32 Checking serializability of parallel schedule 05:43 Serializability is determined by conflict serializable and view serializable methods. 06:59 Understanding serializability in parallel schedules 08:14 Serializability means finding a serial clone of a parallel schedule.

[@viral_video_ayana]

Thankyou sir

[@palvisoni1806]

sir aap kis college mein professor ho? You teach so well.

[@GauravKumar-ok1yp]

If you use English then completely use in English .By the way sir is youTuber not a professor

[@lalianschool6806]

best punjabi teacher 👌

[@vishakapahuja8540]

Hats off to you sir..!

[@ishitavarma2414]

Guys having exam in one hour 🙌🏻

[@techvenom102]

Same 😂

[@viswasdumpala6]

Same

[@rajneeshroy4538]

Please make a video on difference between serial schedule and serializable schedule

[@Manish-qt2bp]

One doubt. Why to do serializable if we have moved from serial schedule to parallel schedule.

[@fahimbakshi6374]

Grate video 👍

[@GATE-xd9iq]

0:11 ---> 100% , also came in 2019

[@TuneTube312]

thankyou sir

[@aditikhedkar8514]

your ideos are amaxing!

[@ladlikhatoon4994]

😭😭 How can you be so good😭💘

[@mdaniquzzaman8120]

Very helpful 👌

[@prachishukla6991]

Please make a video for timestamp 2 phase locking etc it's very hard to understand without u sir

[@rajeevrajput_fitness1608]

sir aapki wajah se mere 4th semester me tafl ,operating system me 70+ aaye hai thanks a lot sir for this wonderful youtube channel i always support you sir may god givesyou happiness🥰

[@RehanKhan-ln6db]

Our 5th me L lagne Wale hai n 😅😅

[@MRDAM-zn4qf]

sir sorry to interrupt, but as i've seen your lecture on Scheduels, you've mentioned that In a serial schedule transactions execute one by one after they committ. So just a doubt, did you forget to write commit after w(A) or it can be executed without commit?

[@brajeshmohanty2558]

tomorrow i have exam and i have to complete upto lec no. 93 hahaha and its 12:00 am already. let's go 2X🔥🗿

[@sajansekhu8785]

thnkk u so much ji...God bless u...

[@VinayYadav-qf3kp]

thank you sir ....