OLAP vs OLTP

Поделиться
HTML-код
  • Опубликовано: 26 ноя 2024

Комментарии • 43

  • @longn.8804
    @longn.8804 Год назад +21

    In my opinion, this is one of the most comprehensive videos on the topic. Great job!

  • @abdulsattar7878
    @abdulsattar7878 Год назад +12

    Great Explanation, you deserve an Oscar for your method of explanation

  • @jeffrey6124
    @jeffrey6124 4 месяца назад +4

    There should be a RUclips nomination/awarding body like the Oscar, Grammy, Academy, Golden Globe, Brit and Nobel Prize for a concise and creative videos like yours 🤓

  • @ianman6
    @ianman6 2 года назад +23

    I learned how to brew beer from you, now I'm learning database architecture!

  • @lunaq3681
    @lunaq3681 Год назад

    this it the coolest teacher you have

  • @momusic1427
    @momusic1427 9 месяцев назад

    simple and lovely definition of these BIG words

  • @panic_seller
    @panic_seller Год назад +2

    Let's see, As an Analyst:
    - I want to provide real-time visibility of the product quantities in our shops, in transport, and those still under manufacture, I would use OLTP for this
    - To extract insights and patterns in our operations, I would use OLAP
    Am I right?? Or I can use them interchangeably, doesn't matter??

  • @melimesesan5786
    @melimesesan5786 9 месяцев назад

    Such elegant presentation!

  • @guillermelc
    @guillermelc 7 месяцев назад

    Loved this explanation. One of the best in the whole internet.Very clear, simple and easy to diggest!!! Thanks a lot from Spain!!! PS: Liked and Shared!

  • @applepeel1662
    @applepeel1662 4 месяца назад

    Awesome explanation, please dive deeper into OLAP and talk about ROLAP and HOLAP in the future

  • @amitpanwar2496
    @amitpanwar2496 Год назад +14

    Are you writing backwards

  • @Heredia1973
    @Heredia1973 4 месяца назад

    Great explanation, easy to understand!

  • @josefinavargas4181
    @josefinavargas4181 4 месяца назад

    Very clear explanation, thank you.

  • @emersonolivares9217
    @emersonolivares9217 Год назад

    I see OLAP as reports, business reports and data mining is all a process you use for data lakes or data inside data warehouses.

  • @michaelangelo9119
    @michaelangelo9119 11 месяцев назад

    Clever way to present ideas. Thanks

  • @yashainu6047
    @yashainu6047 Год назад +2

    this help me to understand the concepts of OLAP and OLTP which confused me for many years, thanks!

  • @anshsachan2602
    @anshsachan2602 11 месяцев назад

    He explained so well!!!!

  • @roostay7548
    @roostay7548 Год назад

    graciasss entendi todo, la mejor explicacion

  • @Kunal4980
    @Kunal4980 2 года назад +2

    Thank you - kindly put some more lights on how does one understand different dimensions in a given dataset

  • @georgigazeto4650
    @georgigazeto4650 2 года назад +7

    Great Video, but is it not easier to say OLTP is just the Database Server? Besides this, the way of presentation was really good !

  • @artemv3160
    @artemv3160 2 года назад +1

    So, if got that right, RDBMS would be an OLTP system?

  • @Wes-Tyler
    @Wes-Tyler Год назад +1

    This really told me nothing. How would I use an OLAP cube or create one?

  • @jingmanwu
    @jingmanwu 9 месяцев назад

    Thanks,it is so good

  • @nguyenkhanh-lm3kb
    @nguyenkhanh-lm3kb Год назад

    Can You take another e.g. It's not really different from what the internet has shown me, still the same

  • @GabrielAzevedo-Inspira
    @GabrielAzevedo-Inspira 8 месяцев назад

    How can I use a OLAP system to respond business questions in real time? Is this possible? I have to have access to updated transactions in the databse.

  • @dadoll1660
    @dadoll1660 2 года назад +1

    Excellent!

  • @grapeshot-videos
    @grapeshot-videos Год назад

    short and effective👍

  • @isurusubasinghe2038
    @isurusubasinghe2038 2 года назад

    Well explained...

  • @litttlemooncream5049
    @litttlemooncream5049 Год назад

    thanks. helped a lot!

  • @hichaoban4453
    @hichaoban4453 Год назад

    Thanks

  • @spacetime314
    @spacetime314 2 года назад +3

    3:43 "So OLTP** does all the infrastructure work."

    • @Tyraelxadrias
      @Tyraelxadrias 2 месяца назад

      I’m glad someone mentioned this lol

  • @oneplusoneplus1764
    @oneplusoneplus1764 2 года назад +1

    Thank you Sir,
    Could you gives us the relation between them please 🌟?

  • @jorge-hernandez-ramirez
    @jorge-hernandez-ramirez 2 года назад

    Good!

  • @kenelliott3188
    @kenelliott3188 4 месяца назад

    Good, BUT, 3:44 in 'OLAP does all of the infrastructure work' . Nope.

  • @rsdobr9177
    @rsdobr9177 9 месяцев назад

    OLAP tem um "A", e OLTP tem um "T"
    Me sigam para mais diCas

  • @HakunaMatata225
    @HakunaMatata225 Год назад

    Yeaaa!! Data scientists!! what an inflated title!!!

  • @Littlepunk8964
    @Littlepunk8964 2 года назад +1

    IBM is still stuck on debating acronyms when other smaller companies and start-ups have already rolled out their products and won new customers.

    • @johnwade1325
      @johnwade1325 2 года назад +6

      IBM have been rolling out OLTP for 50 years and OLAP for 40.

    • @abisarwan20
      @abisarwan20 2 года назад +1

      and how about you ?