In Memory databases internals for system design interviews

Поділитися
Вставка
  • Опубліковано 22 гру 2024

КОМЕНТАРІ • 64

  • @kumarc4853
    @kumarc4853 3 роки тому +4

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

  • @KlgPalpatin
    @KlgPalpatin 4 роки тому +11

    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.

  • @MuhammedBasil
    @MuhammedBasil 2 роки тому

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

  • @lofmaan
    @lofmaan 3 роки тому

    This is the best tutorial I have ever seen

  • @RajanKumar-ol2qf
    @RajanKumar-ol2qf 3 роки тому +2

    This is amazing. Thanks for the amazing tutorial.

  • @chankibiswas532
    @chankibiswas532 3 роки тому

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

  • @ramwisc1
    @ramwisc1 4 роки тому +1

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

  • @carlaludgate6597
    @carlaludgate6597 3 роки тому

    This is such an informative video. Thank you!

  • @Wei-up2jn
    @Wei-up2jn 3 роки тому

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

  • @NavneetVermalivefree
    @NavneetVermalivefree 4 роки тому +6

    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.

  • @Miguel-ym2rr
    @Miguel-ym2rr 4 роки тому

    Awesome!!, Great video.

  • @mauricioroldanramirez821
    @mauricioroldanramirez821 Рік тому

    Excellent :)

  • @ragdoll2324
    @ragdoll2324 4 роки тому

    Thanks for the awesome vdo!

  • @euv921
    @euv921 3 роки тому

    Extremely helpful. Thank you for making this video!

  • @AnirudhNain
    @AnirudhNain 4 роки тому +2

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

  • @PiyushSingh-vx7bx
    @PiyushSingh-vx7bx 4 роки тому +1

    Awesome 🔥

  • @venkateswaran8752
    @venkateswaran8752 4 роки тому

    awesome explanation

  • @souravkar4867
    @souravkar4867 4 роки тому

    Thank you. Nice explanation.

  • @danieldziubecki3939
    @danieldziubecki3939 4 роки тому +5

    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.

  • @rahuljain070817
    @rahuljain070817 4 роки тому

    Very very good man

  • @castkro3223
    @castkro3223 4 роки тому +10

    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

  • @大盗江南
    @大盗江南 4 роки тому

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

  • @saidattathallam
    @saidattathallam 3 роки тому +1

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

  • @aneksingh4496
    @aneksingh4496 4 роки тому

    awesome Naren !!!

  • @dataguy7013
    @dataguy7013 4 роки тому +3

    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
      @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.

  • @ThinkSoftware
    @ThinkSoftware 4 роки тому

    Nice video

  • @dataguy7013
    @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
      @madeehak696 4 роки тому +5

      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.

  • @9fxhrlif9er
    @9fxhrlif9er 4 роки тому

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

  • @vishalgupta-tw4yt
    @vishalgupta-tw4yt 2 роки тому

    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 ?

  • @SumanAmara
    @SumanAmara 4 роки тому

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

  • @subee128
    @subee128 4 місяці тому

    Thanks

  • @babukotha2010
    @babukotha2010 4 роки тому

    Nice

  • @शिवसैनिक-1
    @शिवसैनिक-1 4 роки тому

    Good

  • @eshwarkolluru7132
    @eshwarkolluru7132 4 роки тому

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

    • @Pifagorass
      @Pifagorass 4 роки тому +1

      Datenbankenlearnen.de (material both in German and English)

    • @Pifagorass
      @Pifagorass 4 роки тому

      Try also 'CMU Advanced Database Technologies' on UA-cam

  • @techcare466
    @techcare466 4 роки тому +1

    Sir can you recommend books for system design please sir.

    • @aslamshaik718
      @aslamshaik718 4 роки тому +5

      Data Intensive applications by Martin Klepmann

    • @eugnsp
      @eugnsp 4 роки тому

      @@aslamshaik718 Martin Kleppmann

    • @aslamshaik718
      @aslamshaik718 4 роки тому

      @@eugnsp Thanks for correcting.

  • @nalamda3682
    @nalamda3682 2 роки тому

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

  • @Hmm1298-8
    @Hmm1298-8 4 роки тому

    can you suggest some books? much appreciated...

    • @bryannie3656
      @bryannie3656 4 роки тому +3

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

  • @Pifagorass
    @Pifagorass 4 роки тому +1

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

    • @StoicCoder_
      @StoicCoder_ 3 роки тому +1

      he did say RDBMS also use WAL at 19:47

  • @aleksey6325
    @aleksey6325 3 роки тому

    AVL is one the implementations of BST

  • @modulus4873
    @modulus4873 4 роки тому

    Make a system design video on LinkedIn

  • @jivanmainali1742
    @jivanmainali1742 4 роки тому

    sir make a video on how whatsapp web works??

  • @abhaytiwari6411
    @abhaytiwari6411 4 роки тому

    pls maintain continuity

  • @anujsfavouritesongs
    @anujsfavouritesongs 4 роки тому

    Now NVRAM is available- Intel Optane.

  • @pritamghosh270
    @pritamghosh270 4 роки тому

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

  • @stoneshou
    @stoneshou 4 роки тому

    Next up: sql engine

  • @faizanfareed9076
    @faizanfareed9076 4 роки тому

    NASA

  • @hqdevelopers3697
    @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:
    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?

    • @siddharthbhattacharya380
      @siddharthbhattacharya380 4 роки тому

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

  • @abhiuser4260
    @abhiuser4260 3 роки тому

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

    • @jyotheeswarareddyjerrimadu4183
      @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. :)