OLAP vs OLTP | Online Transaction Processing vs Online Analytical Processing | Intellipaat

In this video on olap vs oltp (online transaction processing vs online analytical processing) video you will understand about the top two data processing method used in the IT industry: oltp vs olap, and which one should you use for better productivity. So in this difference between oltp and olap video some important parameters have been taken into consideration to tell you the difference between olap and oltp and also which one is preferred over the other in certain aspects in detail.
#OlapvsOltp #whatisOLAP #whatisOLTP #OnlineTransactionProcessingvsOnlineAnalyticalProcessing

If you’ve enjoyed this oltp vs olap which is better video, Like us and Subscribe to our channel for more similar informative videos and free tutorials.
What do you think which one of them is better according to you? Tell us in the comment section below.
----------------------------
Intellipaat Edge
1. 24*7 Life time Access & Support
2. Flexible Class Schedule
3. Job Assistance
4. Mentors with +14 yrs
5. Industry Oriented Course ware
6. Life time free Course Upgrade
------------------------------
Why OLAP is used

OLAP is a computing method that enables users to easily and selectively extract and query data in order to analyze it from different points of view. OLAP business intelligence queries often aid in trends analysis, financial reporting, sales forecasting, budgeting and other planning purposes.

Why OLTP is used

OLTP is a class of software programs capable of supporting transaction-oriented applications on the Internet. In computing, a transaction is a sequence of discrete information exchanges that are treated as a unit. Many everyday acts involve OLTP, including online banking, online shopping and even in-store shopping when the point of sale (POS) terminal is tied to inventory management software.
------------------------------
For more Information:

[Intellipaat]

Guys, what else do you want to learn from Intellipaat? Comment down below and let us know so we can create more such tutorials for you.

[fantasticania]

a great video! explaining the difference between OLAP and OLTP in such a comprehensive way with good real life examples! thank you!

[divyajyotiguru]

As far as my understanding goes, Data Warehouse will support OLAP data. The reason is OLAP data(i.e aggregated data(in Lyman terms numbered data) )will assist end-users to make business decisions.

If OLTP data(in Lyman term Raw Data) is integrated into DWH then the staging layer will be of no use and the target tables in the EDWH will increase in size and data retrieval for Reports/Dashboard will also be time taking.

[speci]

Superb sir tqsm ur teaching is just awsm😊✨

[devil..]

Amazing explanation and presentation is perfectly done with the concepts.

[adarsh]

Great video and nice narration. I liked the animations around the main content, but at sometimes they are a kind of distracting. Best wishes

[maximevanwin]

again, coming in clutch the day before my exam. Thanks a lot

[billakantinikhil]

Please continue to do such wonderful tutorials.Hope intellipaat beats unacademy one day.

[murtazajabalpurwala]

Very nice, informativde and concicely summarised video

[maheshwarikalakota]

excellent video, explained with real time examples. Understood very well.

[kmaheshwari]

Each one has its own importance so both are usefull

[narendrapurapuparimala]

An amazing narration with a great vedio...very informative..

[anny]

Amazing video Sir! Thank you very much for the clear explanations with real life examples!

[kirtisahu]

Option 3 am I right . I am waiting for your reply.

[ASHISHSHARMA-iere]

Please upload spring boot and micro services full series tutorials.

[emilioortega]

at 9:49 it says that OLTP is faster compared to OLAP but isn't it supposed that the advantage of using OLAP is because you can do queries faster than OLTP ? so how is OLTP going to be faster ?

[pentiumou]

Very clear explanation for me, thx bro

[princeton]

The explanation is perfect ...But with the word "Right" after every sentence makes it really irritating

[Bella-toen]

thank you for this helpful information, I really like the presentation

[chrisrodriguez]

Good video but you say "right" ... a lot.. its really noticeable when you listen at 1.5x speed
.... right
.... right
.... right

sorry for being critical, I wanted to let you know, not trying to be negative, the material was great.