In Memory databases internals for system design interviews
HTML-код
- Опубликовано: 28 июн 2024
- This video is about the Inmemory db or realtime db or Main memory databases, its importance, performance characteristics, design and use cases.
#realtimedatabase #databseinternals #howdatabasesworks
#microservice #learnmicroservices #totorialssystemdesign #microservicestutorials
#systemdesigntips #systemdesign #computerscience #learnsystemdesign #interviewpreperation #amazoninterview #googleinterview #uberinterview #micrsoftinterview
awesome.
Cleared many interviews, got offers. Many thanks to Master Narendra.
I appreciate your efforts to teach us! Awesome video. I especially like that you focus not only on design examples but on fundamental things and patterns also. These are much more helpful to become confident on the interview.
Great video. Thanks for covering this topic in depth and comparing it with relational database.
Extremely helpful. Thank you for making this video!
This is amazing. Thanks for the amazing tutorial.
Awesome!!, Great video.
Excellent video! I have read about in memory dbs but this video simplified a lot of concepts for me - thank you!
Thanks for the awesome vdo!
It is a great video. Thanks for a wonderful explanation.
Excellent is word!! Hats off... & Thanks
As usual, super great video. Thank you so much !!!!! seriously, bro!
This is such an informative video. Thank you!
Thank you. Nice explanation.
Awesome 🔥
awesome explanation
This is the best tutorial I have ever seen
Very very good man
Excellent :)
Great talk Narendra! The way you presented make it very easy to understand! I like it a lot!
can you make a video on how on the Ad bidding system design. I think there will a lot things going in those systems. In this video you covered some part, but it would really help if you can go in more details.
awesome Naren !!!
Nice video
I feeling like, to be a system designer you have to know everything, like you have to be a Full Stack Developer, DevOps and everything
That's why it's the best
Nice video, but I think there is a mistake. 7:49 WAL is file which is stored on disk and is used for recover from failures. In your example it should be in RDBMS/Disk table.
Nice
Good
Aerospike uses LSM tree and btrees to index the SSTables. Their architecture did not mention about AVL trees.
Hi nice sir can take a video about memsql it is going to be game changer in IT ...
Make a system design video on LinkedIn
Hey thanks for the wonderful video, It could be really great if you can suggest some books to newbies
Datenbankenlearnen.de (material both in German and English)
Try also 'CMU Advanced Database Technologies' on RUclips
1) How does WAL handle concurrent updates. Could there be a scenario where 2 conflicting updates are applied in different order in inmemory database and the backup database
2) what happens if the update in the in memory database succeeds but the write to the WAL fails ?
AVL is one the implementations of BST
Naren, what is the diff between Distributed cache and real time DB. Is it that, in real time DB, you have a query language and a cache you dont have SQL but need to write your own APIs
Yes. RTDB provides all features of database, where as cache is just a key value pair. Not built for persistence but you can configure to persist.
pls maintain continuity
Naren, what is the reason for using AVL for in memeory. Why not just a tree structure? The why would be helpful
If you use normal tree then there are chances of it to get skewed which will increase the complexity. Since AVL balances itself, it prevents tree to get skewed and thus maintains the logarithmic complexity.
sir make a video on how whatsapp web works??
Not able to get what is advantage of using AVL rather than B+, can anybody please help?
can you suggest some books? much appreciated...
I think some knowledge is covered in DDIA: www.amazon.com/Designing-Data-Intensive-Applications-Reliable-Maintainable/dp/1449373321
Sinse then RDBMS doesn't use WAL? ... Good effort overall
he did say RDBMS also use WAL at 19:47
Sir can you recommend books for system design please sir.
Data Intensive applications by Martin Klepmann
@@aslamshaik718 Martin Kleppmann
@@eugnsp Thanks for correcting.
6:05 what file is used? Are you saying "Vol" file?
WAL (Write Ahead Log) file
Now NVRAM is available- Intel Optane.
NASA
Sir your videos are awesome. But sounds are too low.
Next up: sql engine
Hi!
Great video as usual!
Thank you for sharing this info with the community!
However I am missing how the process of "compaction" is done in a efficient manner:
ruclips.net/video/zkACt4NYkU4/видео.html
We have the WAL file and I understood that appending at the end is very efficient.
But how will it work compaction on this file?
It's an offline process, iterating over records and compressing/ purging them. These can be trigerred based on time/events.
This video just wrong at so many different levels. People please refrain from watching such toxic videos
Abhi - Naren doesn't have any intention to teach us wrong things but at the same time he can't be perfect. So please correct his understanding and help viewers if you really care. :)