Data Normalization vs Denormalization - Which is better when ?

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

КОМЕНТАРІ • 44

  • @Mark-wi9ov
    @Mark-wi9ov 2 роки тому +19

    I may not have money to donate but I will not skip ads for every video i watch in your channel. Great video! 😊

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

      Thanks Marky that means a lot man thankyou 🙏🙏☺️

  • @musafirq
    @musafirq 4 місяці тому +1

    Very intuitive way to explaining things. it will help data people to remember this by the shop example. teaching by example is the only way to teach effectively.

  • @nickgogan6654
    @nickgogan6654 2 роки тому +7

    Thank you for the video! I’d like to also put forward document-based db’s like MongoDB as as a sweet spot between traditional RDBMS and NoSQL db’s (like the wide-column store you described in the denormalized scenario). Mongo data models are typically more denormalized than not, and it can ingest millions of writes/sec without issue

    • @Ikilledthebanks
      @Ikilledthebanks 9 місяців тому

      Until you have to ingest all that deeply nested crap into a relational database

  • @user-jm3gh7gy2n
    @user-jm3gh7gy2n 13 днів тому

    nice

  • @sateeshreddy3313
    @sateeshreddy3313 2 роки тому +3

    Nice Explanantion i have learnt about DATA ENGINEERING by watching your videos, I truly appreciate your work...Keep Making Videos!!!!!

  • @KAJlogic
    @KAJlogic 5 місяців тому +3

    Is Normalized = better write performance
    De-Normalized = better read performance
    always true or a rule of thumb?
    So, I have been exploring efficiency increases in normalizing sometimes due to better indexing performance. Is it possible to actually increase read efficiency by normalizing and allowing better indexing?

  • @srutipatnaik7194
    @srutipatnaik7194 Рік тому +1

    Thank you for this video. Simple and Easy to follow!

  • @Ikilledthebanks
    @Ikilledthebanks 9 місяців тому +1

    This is great, thank you very much

  • @jenbac.s1858
    @jenbac.s1858 Рік тому +1

    Thank you for this clear explanation.

  • @petebell271
    @petebell271 3 місяці тому

    AMAZON DB2 --- Best example for DENORMALIZATION Data

  • @jayanth1376
    @jayanth1376 2 роки тому +2

    👌👌👌

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

    Very nice explanation. Really interesting facts and explanation . Easy to understand and remember. You really make IT interesting as you say. This is not only for this - rather for all your videos . Thanks a lot for spreading knowledge .

  • @bluerays5384
    @bluerays5384 Рік тому +1

    well explained Sir..Thank you..

  • @BA-ve7xp
    @BA-ve7xp 10 місяців тому

    great video thank you

  • @gauravmishra8994
    @gauravmishra8994 Рік тому +1

    Awesome video

  • @sammedpatil3907
    @sammedpatil3907 Рік тому +1

    nice explanation sir...

  • @twinkletiwari8820
    @twinkletiwari8820 2 роки тому +2

    👏👏👏

  • @techkid358
    @techkid358 2 місяці тому

    thannks man

  • @thegrinchCAPO
    @thegrinchCAPO 2 роки тому +1

    Great video I’ve been watching for a while and I’ve learnt so much thanks a lot your a amazing teacher never stop

  • @payalkhedkar1869
    @payalkhedkar1869 6 місяців тому

    Thanks 😊

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

    finished watching

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

    Nice Explain Sir, Thank You

  • @narinderthapa3204
    @narinderthapa3204 2 роки тому +1

    Superb🙏

  • @Rhysee473
    @Rhysee473 2 роки тому +3

    Great video 🤙🏽

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

    Very well explained, thank you.

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

    Thank you buddy ..... 😊

  • @sidneymikalgrey
    @sidneymikalgrey Рік тому +1

    New fan. I like your style.

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

    Brilliantly explained

  • @amansdav
    @amansdav Рік тому +2

    Sir, why is write easy in a Normalized DB? Any example, pls? Thanks for your video. 🙏

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

      Read this 👉 link.medium.com/K7ivyOiTsxb

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

    Great video!!

  • @hp0806
    @hp0806 9 місяців тому

    Can we say Denormalization process is followed by normalization ? Instea of which is better

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

    Good stuff for beginners, obviously every aspect could not be covered in a limited timeframe.

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

    Topic starts from 1:28

  • @shalakakarkare8495
    @shalakakarkare8495 2 роки тому +2

    Can you pls explain SDWAN concepr

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

      thanks for suggestion

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

    Video starts at @1:08

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

    sir meinay ek banday ka mobaile apnay wifi say connect kia hay ab wo appna mobaile hotspot on kar kay dosro ko internet deta hay .mein cahta hon wo net istemal karay leken hotspot kam nakaray. is ka koye settings ho to mera help karay. mehrobani hoge