OLAP vs OLTP

OLAP (for online analytical processing) is software for performing multidimensional analysis at high speeds on large volumes of data from a data warehouse, data mart, or some other unified, centralized data store. OLTP, or online transactional processing, enables the real-time execution of large numbers of database transactions by large numbers of people, typically over the internet. Watch master inventor Martin Keen explain and clarify the differences in a versus format.

#AI #Software #ITModernization #OLAP #OLTP #lightboard #IBM

[longn.]

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

[abdulsattar]

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

[jeffrey]

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

[ianman]

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

[momusic]

simple and lovely definition of these BIG words

[guillermelc]

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!

[applepeel]

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

[yashainu]

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

[panic_seller]

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??

[Heredia]

Great explanation, easy to understand!

[emersonolivares]

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

[ksh-vx]

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

[roostay]

graciasss entendi todo, la mejor explicacion

[georgigazeto]

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

[spacetime]

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

[Wes-Tyler]

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

[artemv]

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

[nguyenkhanh-lmkb]

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

[GabrielAzevedo-Inspira]

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.

[oneplusoneplus]

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