In Memory databases internals for system design interviews

Рет қаралды 39,423

Күн бұрын

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

Пікірлер: 63

@KlgPalpatin 3 жыл бұрын

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.

@kumarc4853 2 жыл бұрын

awesome. Cleared many interviews, got offers. Many thanks to Master Narendra.

@AnirudhNain 4 жыл бұрын

Great video. Thanks for covering this topic in depth and comparing it with relational database.

@ramwisc1 3 жыл бұрын

Excellent video! I have read about in memory dbs but this video simplified a lot of concepts for me - thank you!

@RajanKumar-ol2qf 3 жыл бұрын

This is amazing. Thanks for the amazing tutorial.

@euv921 3 жыл бұрын

Extremely helpful. Thank you for making this video!

@MuhammedBasil 2 жыл бұрын

It is a great video. Thanks for a wonderful explanation.

@user-oy4kf5wr8l 4 жыл бұрын

As usual, super great video. Thank you so much !!!!! seriously, bro!

@chankibiswas532 2 жыл бұрын

Excellent is word!! Hats off... & Thanks

@Miguel-ym2rr 3 жыл бұрын

Awesome!!, Great video.

@carlaludgate6597 2 жыл бұрын

This is such an informative video. Thank you!

@NavneetVermalivefree 4 жыл бұрын

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.

@ragdoll2324 3 жыл бұрын

Thanks for the awesome vdo!

@souravkar4867 4 жыл бұрын

Thank you. Nice explanation.

@PiyushSingh-vx7bx 3 жыл бұрын

Awesome 🔥

@Wei-up2jn 3 жыл бұрын

Great talk Narendra! The way you presented make it very easy to understand! I like it a lot!

@venkateswaran8752 4 жыл бұрын

awesome explanation

@lofmaan 2 жыл бұрын

This is the best tutorial I have ever seen

@castkro3223 3 жыл бұрын

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

@tonysolomonik 2 жыл бұрын

That's why it's the best

@mauricioroldanramirez821 8 ай бұрын

Excellent :)

@rahuljain070817 4 жыл бұрын

Very very good man

@aneksingh4496 3 жыл бұрын

awesome Naren !!!

@danieldziubecki3939 3 жыл бұрын

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.

@ThinkSoftware 4 жыл бұрын

Nice video

@saidattathallam 3 жыл бұрын

Aerospike uses LSM tree and btrees to index the SSTables. Their architecture did not mention about AVL trees.

@sourabha2009 4 жыл бұрын

Good

@babukotha2010 3 жыл бұрын

Nice

@SumanAmara 3 жыл бұрын

Hi nice sir can take a video about memsql it is going to be game changer in IT ...

@dataguy7013 4 жыл бұрын

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

@TechDummiesNarendraL 4 жыл бұрын

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.

@eshwarkolluru7132 4 жыл бұрын

Hey thanks for the wonderful video, It could be really great if you can suggest some books to newbies

@Pifagorass 4 жыл бұрын

Datenbankenlearnen.de (material both in German and English)

@Pifagorass 4 жыл бұрын

Try also 'CMU Advanced Database Technologies' on KZfaq

@dataguy7013 4 жыл бұрын

Naren, what is the reason for using AVL for in memeory. Why not just a tree structure? The why would be helpful

@madeehak696 4 жыл бұрын

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.

@vishalgupta-tw4yt Жыл бұрын

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 ?

@modulus4873 4 жыл бұрын

Make a system design video on LinkedIn

@aleksey6325 2 жыл бұрын

AVL is one the implementations of BST

@Hmm1298-8 4 жыл бұрын

can you suggest some books? much appreciated...

@bryannie3656 4 жыл бұрын

I think some knowledge is covered in DDIA: www.amazon.com/Designing-Data-Intensive-Applications-Reliable-Maintainable/dp/1449373321

@abhaytiwari6411 4 жыл бұрын

pls maintain continuity

@nalamda3682 Жыл бұрын

Not able to get what is advantage of using AVL rather than B+, can anybody please help?

@Pifagorass 4 жыл бұрын

Sinse then RDBMS doesn't use WAL? ... Good effort overall

@StoicCoder_ 3 жыл бұрын

he did say RDBMS also use WAL at 19:47

@9fxhrlif9er 3 жыл бұрын

6:05 what file is used? Are you saying "Vol" file?

@piyushdosi3986 3 жыл бұрын

WAL (Write Ahead Log) file

@jivanmainali1742 3 жыл бұрын

sir make a video on how whatsapp web works??

@techcare466 4 жыл бұрын

Sir can you recommend books for system design please sir.

@aslamshaik718 4 жыл бұрын

Data Intensive applications by Martin Klepmann

@eugnsp 4 жыл бұрын

@@aslamshaik718 Martin Kleppmann

@aslamshaik718 4 жыл бұрын

@@eugnsp Thanks for correcting.

@anujsfavouritesongs 3 жыл бұрын

Now NVRAM is available- Intel Optane.

@stoneshou 4 жыл бұрын

Next up: sql engine

@faizanfareed9076 4 жыл бұрын

NASA

@pritamghosh270 4 жыл бұрын

Sir your videos are awesome. But sounds are too low.

@aneksingh4496 3 жыл бұрын

use headphones

@hqdevelopers3697 4 жыл бұрын

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: kzfaq.info/get/bejne/sNFxdtdls7_PhWg.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?

@siddharthbhattacharya380 3 жыл бұрын

It's an offline process, iterating over records and compressing/ purging them. These can be trigerred based on time/events.

@abhiuser4260 3 жыл бұрын

This video just wrong at so many different levels. People please refrain from watching such toxic videos

@jyotheeswarareddyjerrimadu4183 3 жыл бұрын

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. :)