OLAP vs OLTP

What OLAP?: ibm.biz/What-Is-OLAP
What is OLTP?: ibm.biz/What-is-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.
Download a free AI ebook: ibm.biz/OLAP-OLTP-Free-AI-Ebook
Get started for free on IBM Cloud: ibm.biz/OLAP_Free_Cloud_Account
Subscribe to see more videos like this in the future → ibm.biz/subscribe-now
#AI #Software #ITModernization #OLAP #OLTP #lightboard #IBM

[@longn.8804]

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

[@abdulsattar7878]

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

[@momusic1427]

simple and lovely definition of these BIG words

[@ianman6]

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

[@TheHomebrewChallenge]

😉

[@melimesesan5786]

Such elegant presentation!

[@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!

[@michaelangelo9119]

Clever way to present ideas. Thanks

[@Kunal4980]

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

[@yashainu6047]

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

[@roostay7548]

graciasss entendi todo, la mejor explicacion

[@anshsachan2602]

He explained so well!!!!

[@lunaq3681]

this it the coolest teacher you have

[@dadoll1660]

Excellent!

[@litttlemooncream5049]

thanks. helped a lot!

[@isurusubasinghe2038]

Well explained...

[@grapeshot-videos]

short and effective👍

[@user-tk9bd1fh7i]

Thanks,it is so good

[@artemv3160]

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

[@hichaoban4453]

Thanks

[@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.

[@jorge-hernandez-ramirez]

Good!

[@oneplusoneplus1764]

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

[@georgigazeto4650]

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

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

[@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.

[@nguyenkhanh-lm3kb]

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

[@spacetime314]

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

[@Retrosenescent]

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

[@amitpanwar2496]

Are you writing backwards

[@IBMTechnology]

See ibm.biz/write-backwards

[@rsdobr9177]

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

[@wils5923]

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]

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

[@abisarwan20]

and how about you ?

[@HakunaMatata225]

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

[@agent-sz2qj]

why is that?