Data Normalization vs Denormalization - Which is better when ?

Поділитися
Вставка
  • Опубліковано 2 січ 2025

КОМЕНТАРІ • 46

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

    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 8 місяців тому +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.

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

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

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

    Awesome video

  • @BA-ve7xp
    @BA-ve7xp Рік тому

    great video thank you

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

    nice explanation sir...

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

    Thank you for this clear explanation.

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

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

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

    Superb🙏

  • @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 Рік тому

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

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

    Thank you man! It was a helpful video for my coming interview! Subscribed + Liked! 🤙🏼

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

    very well explained man

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

    well explained Sir..Thank you..

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

    Great video 🤙🏽

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

    Nice Explain Sir, Thank You

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

    Thank you buddy ..... 😊

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

    Brilliantly explained

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

    Thanks 😊

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

    finished watching

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

    👌👌👌

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

    New fan. I like your style.

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

    Great video!!

  • @sambitmahapatra1553
    @sambitmahapatra1553 22 дні тому

    ❤❤❤❤❤

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

    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 .

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

    thannks man

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

    nice

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

    👏👏👏

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

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

    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?

  • @petebell271
    @petebell271 7 місяців тому

    AMAZON DB2 --- Best example for DENORMALIZATION Data

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

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

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

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

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

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

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