Explain By Example: OLTP vs OLAP

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

КОМЕНТАРІ • 61

  • @KARTHIKEYANRE-tn4cz
    @KARTHIKEYANRE-tn4cz 2 роки тому +4

    I have been through lot of videos for OLAP, OLTP and Warehouse , but ended with this example and ended my loop of search because of this END = "Explain by Example". Thanks!!

  • @yousefomairi8899
    @yousefomairi8899 Рік тому +9

    I am lucky that i found your channel in youtube
    Thank you for the easy and non-boring explain you make 💙

  • @ayappakn1073
    @ayappakn1073 Рік тому +3

    Amazing!!, never thought OLTP and OLAP concepts could be explained like this!! It was so much fun watching this video Thank you!!

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

    this video is insanely underrated!

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

    Great example, now I know the terms for things I've been using and doing for years.

  • @enrique-zarate4594
    @enrique-zarate4594 Рік тому

    4:50 is where my mind finally made “click”. Amazing video.

  • @KenLaw-fu7wh
    @KenLaw-fu7wh Рік тому +1

    You are the nature explainer and thanks for kind sharing!!

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

    Thanks, very easy to understand. Makes a lot of sense now!

  • @Alex-UK369
    @Alex-UK369 2 роки тому +4

    Super well explained. Thanks a lot 🙏🙂

  • @pubgcalling2000
    @pubgcalling2000 6 місяців тому +3

    I don't learn about olap but I learn about data ware house and database 😅

  • @dansinn
    @dansinn 6 місяців тому +1

    Very well explained, 3:55 is my favourite part

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

    That's a great example. Very clear and informative.

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

    Could you do videos on statistics

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

    Wow, this is very very nice. Thanks a lot I now have a far better understanding.

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

    Your video is amazing. UA-cam is hard but you genuinely sound pleasant and present like a professional. Please don't stop. Hope to see you be big some day.👌

  • @SahilKashyap64
    @SahilKashyap64 2 роки тому +5

    🙏Thank you, you made it so easy to understand. Now I can easily explain these terms to my collegues.

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

    Very nice explanation, thanks for sharing. I wonder what software you used to draw the beautiful explanation.

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

    Amazing explanation, thank you!

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

    Crystal clear explanation. Thanks alot 😊

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

    wow you have a great way of delivering information in a very clear way, thank you!

  • @sandyboxer5
    @sandyboxer5 7 місяців тому +1

    shit!!!! after looking and understanding with your example , i realised how dumb im lolll.. thanks i was confused with both of the names however i got it now...keep rocking , good content and its really creative idea to have a youtube cHannel like this which helps to understand information as "piece of cake" ofcourse the credit is your ideology.. good luck for your future plans

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

    Eeeeee
    Dat was soo good
    Simply explained with examples
    Thank you alot ☺

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

    Thanks, I understand the topics well

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

    I’m stuck very confused. Is the only difference where they search for the data? Do one from a database with current quick information and the other a data warehouse with more in depth and broadly sought after reasoning for the answer?

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

      OLTP is at the transaction grain. Is primarily used for applications and operations.
      OLAP is analytic and is aggregated for creating analytical reporting such as KPI or metric dashboards so is at a categorical level.
      OLTP DB might say these are all the transactions from this store and have a row for each sale.
      An OLAP Data-warehouse would say last month we sold X number of this product. It might only have a row for each products monthly total.

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

    Thank you 🙏🙏🙏

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

    U r so good at explaining 👍

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

    Thank you.

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

    Very clear explanation....

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

    amazing example. Many thanks!!1

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

    this is awesome i just subscribed

  • @Khushi-lm9pr
    @Khushi-lm9pr 2 роки тому +1

    SOOOOO SOOOO GOOD , THANKYOU

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

    Very clear , Thank you

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

    Lifesaver💙

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

    Excelente..👍👍👍

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

    I'm your 400th sub 🙂

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

    awesome explanation - very clear!!!

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

    Wotta a great video! Found a treasure:))

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

    so good!

  • @j.r.9966
    @j.r.9966 Рік тому

    This is great - thank you

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

    Thank you...very clear explanation

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

    Good voice and explanation...

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

    wonderful

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

    thank you so much.

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

    Thank you so much

  • @Mahmoud-ys1kt
    @Mahmoud-ys1kt 2 роки тому +1

    sehr gut danke

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

    Nice explanation

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

    5:55 is the part that I really want to hear !!!!

  • @quanhoang68679
    @quanhoang68679 5 місяців тому

    thanks a lot for this stuff

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

    REALLY HELPFULL

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

    Great video thank you

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

    Great!!!

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

    Really nice explained.

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

    U r amazing
    Thx❤

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

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

    i liked, thx

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

    Thanks i am more con now

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

    🤍🥰

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

    Your life history could have been ignored.

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

    What a stupid example