OLAP vs OLTP

Рет қаралды 88,274

2 жыл бұрын

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

Пікірлер: 42

@jeffrey6124 29 күн бұрын

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

@longn.8804 9 ай бұрын

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

@ianman6 2 жыл бұрын

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

@TheHomebrewChallenge 2 жыл бұрын

😉

@momusic1427 5 ай бұрын

simple and lovely definition of these BIG words

@Kunal4980 2 жыл бұрын

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

@melimesesan5786 5 ай бұрын

Such elegant presentation!

@michaelangelo9119 7 ай бұрын

Clever way to present ideas. Thanks

@Heredia1973 9 күн бұрын

Great explanation, easy to understand!

@guillermelc 3 ай бұрын

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!

@josefinavargas4181 Күн бұрын

Very clear explanation, thank you.

@roostay7548 9 ай бұрын

graciasss entendi todo, la mejor explicacion

@anshsachan2602 7 ай бұрын

He explained so well!!!!

@litttlemooncream5049 Жыл бұрын

thanks. helped a lot!

@applepeel1662 28 күн бұрын

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

@dadoll1660 2 жыл бұрын

Excellent!

@isurusubasinghe2038 2 жыл бұрын

Well explained...

@grapeshot-videos Жыл бұрын

short and effective👍

@user-tk9bd1fh7i 5 ай бұрын

Thanks,it is so good

@lunaq3681 8 ай бұрын

this it the coolest teacher you have

@yashainu6047 Жыл бұрын

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

@hichaoban4453 Жыл бұрын

Thanks

@jorge-hernandez-ramirez 2 жыл бұрын

Good!

@artemv3160 2 жыл бұрын

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

@GabrielAzevedo-Inspira 4 ай бұрын

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.

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

@emersonolivares9217 10 ай бұрын

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

@amitpanwar2496 Жыл бұрын

Are you writing backwards

@IBMTechnology Жыл бұрын

See ibm.biz/write-backwards

@panic_seller 10 ай бұрын

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