CheckPoints : - The checkpoint is a type of mechanism where all the previous logs are removed from the system and permanently stored in the storage disk. - The checkpoint is like a bookmark. While the execution of the transaction, such checkpoints are marked, and the transaction is executed then using the steps of the transaction, the log files will be created. - When it reaches to the checkpoint, then the transaction will be updated into the database, and till that point, the entire log file will be removed from the file. Then the log file is updated with the new step of transaction till next checkpoint and so on. - The checkpoint is used to declare a point before which the DBMS was in the consistent state, and all transactions were committed.
Bhaiya ..please update subtitles for your DSA videos. As I am not a native speaker of Hindi, I am relying on your subtitles for my preparation. Kindly please update subtitles from 72nd video of DSA
Bhaya thank you for great DSA series. Please bhaya make a full detail video on setup vs code please bhaya please 🙏🙏 kabse try kar raha huu bahat sara vdo dekh liya nehi hota he yar bhaya please 🙏🙏
secure storgae may be in file system format , which might raise many issues like data redundency and data inconsisty etc , and many of the times the stable storage is located in local storage which is agin an issue , these are few reasons why we are updating the DB pointer .i hope this helps !
Disk is basically your Hard drive / SSD where you permanently store stuff. RAM is Random Access Memory. RAM gives applications a place to store and access data on a short-term basis. It stores the information your computer is actively using so that it can be accessed quickly.
Bhaiya kya direct stack padh skte h linkee list na padhe..... Hmlog k collge m padha rhe h...3rd sem m..🤦🏻♂️🤦🏻♂️🤦🏻♂️🤦🏻♂️🤦🏻♂️kuch smjh nhi rha 🤦🏻♂️🤦🏻♂️
Sir, I have a doubt, You said that logs are written first and then operation performed. But what if commit log is written but before actual commit happens system crashes, then system restarts and sees the logs which is having commit, I think this can make problems....
CheckPoints :
- The checkpoint is a type of mechanism where all the previous logs are removed from the system and permanently stored in the storage disk.
- The checkpoint is like a bookmark. While the execution of the transaction, such checkpoints are marked, and the transaction is executed then using the steps of the transaction, the log files will be created.
- When it reaches to the checkpoint, then the transaction will be updated into the database, and till that point, the entire log file will be removed from the file. Then the log file is updated with the new step of transaction till next checkpoint and so on.
- The checkpoint is used to declare a point before which the DBMS was in the consistent state, and all transactions were committed.
Lectures was great.
I have been watching videos continuously but forgetting to like it, I think this will happens to everyone.
The best series ever 🔥🔥🔥..
agree👍👍
Is this DBMS playlist complete for interview preparation?
@@sahikhan3840 Is this DBMS playlist complete and sufficient for interview preparation?
@@softprob2838 yes! only for interview preparation not for college theory exams.
Very Concise and deeper understanding of DBMS according to placements. Thanks Bhaiya
Consistent rehna koi aapse sikhe❤️
Bhaiya ..please update subtitles for your DSA videos. As I am not a native speaker of Hindi, I am relying on your subtitles for my preparation. Kindly please update subtitles from 72nd video of DSA
"The Best" series ever🔥
Bhaya thank you for great DSA series. Please bhaya make a full detail video on setup vs code please bhaya please 🙏🙏 kabse try kar raha huu bahat sara vdo dekh liya nehi hota he yar bhaya please 🙏🙏
Thank you soo much vaiya.. 😊
Check point..done bhiya.. thank you ❤❤
What an explanation !
jai hind bhai about to complete this playlist🤘(very few playlist get chance being complete by me
Bhaiya moj kr diii..
Accha padhate hai @satishray
Excellent explanation
Loved the lecture!!!
Teaching style is really good💥
Maja aa gaya bhaiya....🚀💥😍
CheckPoint Done
Setting a Benchmark. 🎊
Check Point Done Bhayya !
amazing lecture series
How do we know the value 950 and 2050 in logs before calculations?
We read from database first
maine video puri dekhi
Kudos to this course
👍thanks to you brother.
Day13 done ✓
smjh aagya
thanku sir
Can I join ur recursion course now as well ...plz reply
15:23 if logs are secure in stable storage, then we can also store db there right ? data will never get lost
secure storgae may be in file system format , which might raise many issues like data redundency and data inconsisty etc , and many of the times the stable storage is located in local storage which is agin an issue ,
these are few reasons why we are updating the DB pointer .i hope this helps !
@@shantanuborade6560 thanks bro
It's expensive
Day 13 - Present Sir❤
Great lecture
smajh agya !
Can anyone tell what actually is difference between ram and disk when he says making changes at ram location and at disk location?
Disk is basically your Hard drive / SSD where you permanently store stuff. RAM is Random Access Memory. RAM gives applications a place to store and access data on a short-term basis. It stores the information your computer is actively using so that it can be accessed quickly.
@@x_mercury1386 ok thanks
Dear iski practical example using Database kab krwain gay?
great
Bhaiya checkpoint par video toh bana dete..
Bhaiya kya direct stack padh skte h linkee list na padhe.....
Hmlog k collge m padha rhe h...3rd sem m..🤦🏻♂️🤦🏻♂️🤦🏻♂️🤦🏻♂️🤦🏻♂️kuch smjh nhi rha 🤦🏻♂️🤦🏻♂️
linkedlist se kyo start kr rhe ho bro graph se start kr sakte ho😂
Yes, you can
Haa bro stack padh skte ho Babbar bhaiya ki Codehelp wle hi channel se👍
Consistency op ❤️
jai hind❤
Thanks Bhaiya ...!!
Bhaiya, Please next video me ek baar ye bta dena ki almost kitni videos or aayegi. Bcoz My placements are going on right now.
So what's the status of your placement brother?
placed??
Late Night ( 12 Am Morning) V Both are Hard Working 🫂
completed
Sir, I have a doubt, You said that logs are written first and then operation performed. But what if commit log is written but before actual commit happens system crashes, then system restarts and sees the logs which is having commit, I think this can make problems....
Through those log file it performs redo to maintain durability
Yar koi is playlist ke sare notes ek jagah krdo.....hr video me alag alag jake dekhne pd rahe h
It’s just a small effort :)
@@lakshaykumar7518 yes... but still 😅.....it would be convenient
checkpoints completed bhaiya
but bhaiya thora practical example ek do batana bad me on db
❣️❣️
need subtitle plzzzzzzzzz
1st view😅
Please tell when will this playlist complete
Tereko kya hain dekhna hain toh dekh warna nikal
@@ankitsaha675 terse mtlb
Placement season h pta to hona chaeye
Yess bro.
Get lost ankit
@@ayushuniyal2586 pata karke kya ukhar lega te? Course jaisa chal rha h waisa hi chalega, tere puchne se course jaldi khatam nhi hone wala h beta
@@ankitsaha675 bhai dimag khrab h ky thoda.
Mene kb kha jldi kro.
Just yei to pucha kb tk khtm hoga approx.
awesome
Hello sir
done 04/04/2024
1
next lecture kab ayega bhaiya???
swad++
17.04.2023
bhaiya aap pahle kuch or batate or phir kuch or bata dete ho confusion bahut hota hai issse
🐑🐑
thousandth like!