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.
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.
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.
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
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.
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 ?
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: ua-cam.com/video/zkACt4NYkU4/v-deo.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?
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. :)
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.
It is a great video. Thanks for a wonderful explanation.
This is the best tutorial I have ever seen
This is amazing. Thanks for the amazing tutorial.
Excellent is word!! Hats off... & Thanks
Excellent video! I have read about in memory dbs but this video simplified a lot of concepts for me - thank you!
This is such an informative video. Thank you!
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!!, Great video.
Excellent :)
Thanks for the awesome vdo!
Extremely helpful. Thank you for making this video!
Great video. Thanks for covering this topic in depth and comparing it with relational database.
Awesome 🔥
awesome explanation
Thank you. Nice explanation.
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.
Very very good man
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
As usual, super great video. Thank you so much !!!!! seriously, bro!
Aerospike uses LSM tree and btrees to index the SSTables. Their architecture did not mention about AVL trees.
awesome Naren !!!
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.
Nice video
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.
6:05 what file is used? Are you saying "Vol" file?
WAL (Write Ahead Log) file
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 ?
Hi nice sir can take a video about memsql it is going to be game changer in IT ...
Thanks
Nice
Good
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 UA-cam
Sir can you recommend books for system design please sir.
Data Intensive applications by Martin Klepmann
@@aslamshaik718 Martin Kleppmann
@@eugnsp Thanks for correcting.
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
AVL is one the implementations of BST
Make a system design video on LinkedIn
sir make a video on how whatsapp web works??
pls maintain continuity
Now NVRAM is available- Intel Optane.
Sir your videos are awesome. But sounds are too low.
use headphones
Next up: sql engine
NASA
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:
ua-cam.com/video/zkACt4NYkU4/v-deo.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. :)