OLAP vs OLTP | Online Transaction Processing vs Online Analytical Processing | Intellipaat
ฝัง
- เผยแพร่เมื่อ 3 ก.ค. 2024
- 🔥Intellipaat Data warehouse course: intellipaat.com/data-warehous...
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
📌 Do subscribe to Intellipaat channel & get regular updates on videos: goo.gl/hhsGWb
📕Read complete data warehouse tutorial here: intellipaat.com/blog/tutorial...
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:
Please write us to sales@intellipaat.com, or call us at: +91- 7847955955
Website: hintellipaat.com/data-warehous...
Facebook: / intellipaatonline
LinkedIn: / intellipaat
Twitter: / 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.
Nexus simulation, CISCO ACI Integration
Design thinking
Spring boot and micro services
Teradata
Hi Selva, Sure, will forward the topic to the respective team and will upload the video soon. Please subscribe to Intellipaat channel & press the bell icon so that you don't miss that video from us.
👋 Guys everyday we upload high quality in depth tutorial on your requested topic/technology so kindly SUBSCRIBE to our channel 👉 ( bit.ly/Intellipaat ) & also share with your connections on social media to help them grow in their career. 🙂
a great video! explaining the difference between OLAP and OLTP in such a comprehensive way with good real life examples! thank you!
Glad it was helpful!
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.
Amazing video Sir! Thank you very much for the clear explanations with real life examples!
Each one has its own importance so both are usefull
Amazing explanation and presentation is perfectly done with the concepts.
Thanks a lot. :) Keep learning with Intellipaat. :)
again, coming in clutch the day before my exam. Thanks a lot
All the best
excellent video, explained with real time examples. Understood very well.
Glad you liked it! Keep learning with Intellipaat😊
Nice. Thank you for this. 👍🏽
Thank you for watching. :)
An amazing narration with a great vedio...very informative..
Glad you liked it! Keep learning with Intellipaat😊
Very clear explanation for me, thx bro
Glad it helped
thank you for this helpful information, I really like the presentation
Glad it was helpful!
Superb sir tqsm ur teaching is just awsm😊✨
Most welcome 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Please continue to do such wonderful tutorials.Hope intellipaat beats unacademy one day.
Hahaha, Please stay tuned to Intellipaat for more tutorials😊
Very nice, informativde and concicely summarised video
Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
Thank you❤nice explain
Glad it was helpful!
Great video and nice narration. I liked the animations around the main content, but at sometimes they are a kind of distracting. Best wishes
Thanks for the feedback. :)
OLAP is an example of datawarehouse.
Yes
Awesome session ❤
Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
thanks you
Fantastic!
@Prem Kumar Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
amazing accent
Please upload spring boot and micro services full series tutorials.
Hi Akash, please watch this: th-cam.com/video/y0Z1qFvfzTs/w-d-xo.html
Right!!!
thanks
@LAPOVETS Keep watching and subscribe to our channel to get more interesting videos
The explanation is perfect ...But with the word "Right" after every sentence makes it really irritating
Thanks for the feedback Fernandes😊
Yeah, right?
How the million records is transferred from source to target in ETL informatica..?
"Right"
You say RIGHT A LOT
Apologies for the inconvenience
@@Intellipaat it's okay buddy but ur video was great. Loved the way u explained.
@@Intellipaat It is actually something good. Most smart people do same. Ever watch an interview of Elon Musk?
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 ?
With OLTP, you will be processing lots of short online transactions like check your bank account balance, make an online check deposit with your phone, make atm withdrawals & deposits etc...these are short & fast transactions.
But for OLAP, you will be given access to a database that contains as large as petabytes of data, you essentially download it & run queries (like simple excel to sort, separate, add different culums/rolls etc) against it. You might even API something like AWS Athena to it in form of big data analysis - all these take time.
right
cool.
What are the success stories of one and the other? Any examples?
both are used for a different purpose. Please watch full video.
right. :)
Can u cover sas topics pls
Sure. Noted. Will upload soon. 🙂
option no. 2 OLAP
@krishna Do like, share & subscribe to our channel to get updates on upcoming videos.
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.
May be it is OLAP why because we use OLAP in the Data mining process like a OLAP SERVER at middle layer
Please telle that it is right or weong
DW supports OLAP where as OLTP follows traditional RDBMS system
Okay😊
Option 3 am I right . I am waiting for your reply.
@KIRTI SAHU We appreciate your active participation😊. Do like, share & subscribe to our channel to get updates on upcoming videos.
any help on MDX?
Hi, what help you want?
I think the answer will be OLAP
We appreciate your active participation😊. Subscribe to Intellipaat to know the right answer.
Why Backup is not need for OLAP?
It's already in archive...it's just content you store in glacier s3, tapes, sata slowest performing disks you can just run query against. It is not being updated with new data or transactions bcos it's already being stored for historical analysis.
option 3
ok
options 3 because OLTP, and OLAP both use data.
cool.
Option 3
I hate word “right” after that, but thank you for your task
very distracting right? :P
bc 😆🙆🏿♂️
OLAP uses data warehousing
Okay😊
Right ?!
Yes Ali Mustafa😊
👍
Do like, share & subscribe to our channel to get updates on upcoming videos.
u down with OLTP? Yeah u know me
2
cool.
Option3
@KIRTI SAHU We appreciate your active participation😊. Do like, share & subscribe to our channel to get updates on upcoming videos.
OLAP
Cool.:)
Integrated?
sorry?
Olap
OLAP uses data warehouse
Okay😊
olap
Data warehousing uses OLAP
If you wish to get Personal support Kindly call our advisors on IND : +91-7022374614 US : 1-800-216-8930 (Toll Free).
@@Intellipaat hahahahahhaha
both
Okay😊
nhii ree dosttttt
Datawarehouse is the example of OLAP SYSTEM. So OLAP is the option
@padhu jangam Do like, share & subscribe to our channel to get updates on upcoming videos.
OLTP
cool.
I really wanted to watch the whole video. But i couldn't stand the tonation and accent. sorry
Thanks for the feedback, will improve on that. :)
he did a fine job explaining, i understood it clearly
OLAP
We appreciate your active participation😊. Subscribe to Intellipaat to know the right answer.
2
Olap
Okay😊
OLAP
cool.
It's the right answer data warehouse cannot support oltp as it has day to day transaction and doesn't store historical data