OLAP vs OLTP

What OLAP?: ibm.biz/What-I...
What is OLTP?: ibm.biz/What-i...
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-O...
Get started for free on IBM Cloud: ibm.biz/OLAP_F...
Subscribe to see more videos like this in the future → ibm.biz/subscri...
#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

[@jeffrey6124]

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

[@ianman6]

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

[@TheHomebrewChallenge]

😉

[@di-egohumilde4515]

What?

[@CodewithSAM-ej6fb]

that's the fancy and vivid representation of data sets, it helped me distinguish between them.

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

[@lunaq3681]

this it the coolest teacher you have

[@momusic1427]

simple and lovely definition of these BIG words

[@nisalmandira6702]

Great Explanation ! Thank you !

[@applepeel1662]

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

[@melimesesan5786]

Such elegant presentation!

[@kirillzlobin7135]

Cool explanation

[@yashainu6047]

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

[@Heredia1973]

Great explanation, easy to understand!

[@ksh-v8x]

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

[@josefinavargas4181]

Very clear explanation, thank you.

[@MrDeatmatch]

How would you differentiate OLTP vs traditional relational database's, such as MySQL, PostgreSQL etc?
Where does OLTP fit in this hierarchy, is it simply a higher level abstraction, a system that contains such relational database, or can we say that a system that implements a traditional RDBMS is an OLTP system?

[@michaelangelo9119]

Clever way to present ideas. Thanks

[@amitpanwar2496]

Are you writing backwards

[@IBMTechnology]

See ibm.biz/write-backwards

[@anshsachan2602]

He explained so well!!!!

[@roostay7548]

graciasss entendi todo, la mejor explicacion

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

[@CodewithSAM-ej6fb]

OLAP is kind of warehouse, use it if you have to go in depth to get insights for BI, OLTP if making query, creation, updating, deletion is quire frequent, OLTP is great for fast response time for general audience in general.

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

[@jingmanwu]

Thanks,it is so good

[@dadoll1660]

Excellent!

[@grapeshot-videos]

short and effective👍

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

[@nguyenkhanh-lm3kb]

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

[@litttlemooncream5049]

thanks. helped a lot!

[@isurusubasinghe2038]

Well explained...

[@artemv3160]

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

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

[@spacetime314]

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

[@Tyraelxadrias]

I’m glad someone mentioned this lol

[@hichaoban4453]

Thanks

[@Wes-Tyler]

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

[@kenelliott3188]

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

[@jorge-hernandez-ramirez]

Good!

[@oneplusoneplus1764]

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

[@rsdobr9177]

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

[@HakunaMatata225]

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

[@agent-sz2qj]

why is that?

[@Littlepunk8964]

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 ?