OLAP vs OLTP | Difference between OLAP vs OLTP with Real Life Examples
Vložit
- čas přidán 26. 06. 2024
- 00:00 - OLTP & OLAP with real life example
01:06 - difference b\w OLTP and OLAP
OLTP (Online Transaction Processing) refers to systems designed to manage transaction-oriented applications, typically for data entry and retrieval transaction processing. These systems are crucial for handling a large number of small, short online transactions such as inserting, updating, and deleting data.
OLAP (Online Analytical Processing) refers to systems designed for query processing and complex data analysis, typically involving large volumes of data. Unlike OLTP systems, which handle routine transactional operations, OLAP systems are used for data mining, trend analysis, and decision support.
👉Subscribe to our new channel: / @varunainashots
►Database Management System(Complete Playlist):
• DBMS (Database Managem...
Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
• Design and Analysis of...
►Computer Architecture (Complete Playlist):
• Computer Organization ...
► Theory of Computation
• TOC(Theory of Computat...
►Artificial Intelligence:
• Artificial Intelligenc...
►Computer Networks (Complete Playlist):
• Computer Networks (Com...
►Operating System:
• Operating System (Comp...
►Structured Query Language (SQL):
• Structured Query Langu...
►Discrete Mathematics:
• Discrete Mathematics
►Compiler Design:
• Compiler Design (Compl...
►Number System:
• Number system
►Cloud Computing & BIG Data:
• Cloud Computing & BIG ...
►Software Engineering:
• Software Engineering
►Data Structure:
• Data Structure
►Graph Theory:
• Graph Theory
►Programming in C:
• C Programming
►Digital Logic:
• Digital Logic (Complet...
---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
► Subscribe to us on CZcams: / gatesmashers
►Subscribe to our new channel: / @varunainashots
► Like our page on Facebook: / gatesmashers
► Follow us on Instagram: / gate.smashers
► Follow us on Instagram: / varunainashots
► Follow us on Telegram: t.me/gatesmashersofficial
► Follow us on Threads: www.threads.net/@gate.smashers
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:
Email us at: gatesmashers2018@gmail.com
#oltp #datawarehouse #onlinetransaction
Best teacher of the world...make things so easy to understand with real life example... thanku very much sir
BEST TEACHER OVER THE WORLD WHO PASSED ME WITH 75% IN BCA thankyou for the best and effective ,effective ,optimized knowledge
Bhai party do
whenever i search for any topic and saw your video at the top of the search i feel very relax take a deep breath and i was like ab to ye topic khtm .😊😊
Itni deir se khuwar ho rha hun.. olap and oltp ko samjhne mein.. zehen se hi nikal gya gate smashers ka naam.. thank you Varun paa g for making it simple and easy.. Salam and love from Pakistan ❤
This example was so beautiful that couldnt stop from putting in my comment. Really great teaching.
The most wonderful analogy that I have ever come across!!!
*OTLP* ko softaware engnieers update krte h, phir data engineer use age ETL(extract transform load) for data anaylists or decision makers k liye phir yeh *OLAP* krte h uss data pe.
Nice video sir, just adding my two cents.
Tableau, PowerBI would be marked as Visualization tool for OLAP, where-as SnowFlake DB, BigQuery or RedShift would be marked as OLAP DB servers.
Also PowerBI and such viz. tools can also be used on OLTP by fetching the data from required data source in our case SQL server or MySQL via connectors for live data transaction.
We use Apache Superset to monitor live sales and same Superset to do beat performance analysis.
Thank You sir for the DATA WAREHOUSE playlist
Waiting for more
Thankyou soo much for helping us out in the last day exam preparation..like your play list actually rock my mind..surely will give my best in exam tomorrow ❤ please complete the playlist as well as give detail video about data cube and OLAP cube operations ❤
Very good Explanation sir, plz complete this Playlist ❤
Thank you sir for this playlist❤
Even If I try to forget it now I wont be able to. He made it so simple. Great work.
Thanks much, Bhai!! this is simple yet very comprehensive explanation on OLTP and OLAP.
Very easy explanation sir. Thanks a lot
you always provide best content...thank you👍
best teaching sir!!!
great to have youtube,,internet
Well & Simple Way Of explaination....Thanks
Thank you so much sir for your wonderful explanation with best clarity to the concept😊
you explanation is just amazing loved it
Thank u Sir❤
Plz make videos fast on Data warehouse and data mining
Plzzzz sir🙏🏻🙏🏻
No one CZcamsr can't teach like u
So plz make videos fastttt🙏🏻🙏🏻
Zabardast sir ge ❤
Thank you sir.... You are God for us❤
Thank you sir 🙏 for this video
thankyou so much you really explain so welll
Sir, Thanks a lot for This Amazing Lecture 🙂
Lecture - 7 Completed ✅ in Data Warehouse Playlist
Nice explanation sir🙏🙏🙏
Thank you so much for ur videos
Best explanation thanks ❤
nice explaination
Thanks for sharing this video
mashallah well explained
The best class i ever had 😍😍 thank you sooo much sir ❤❤
Thank you so much😊😊
Sir please make full playlist as soon as possible we are waiting
Thank you❤
Sachi mai sir bohot acha padhata ho ap maina bohot ko dakha etna easy aur asaan trika se koi nhi padhata
Thank you 👍
Thank you so much ❤❤❤❤
You are the best sir❤
Pls make a vedio lectures on Multidimensional view of data and its cube....
Nice 👍
Mza aa gya.
Thanks....
Please make video on
CDC
ELT
Interview questions also
Pls make a vedio lecture on Design and Implementation of Data warehouse .
Best sir ❤️
I don't understand even one word of Hindi language, but I simply understood this one
Sir please complete the syllabus of data mining and warehousing in these two months
👌
Very good explanation sir. Are you taking any class of Sql server Database Administrator? Please let me know.
Please make more videos related to DataWarehousing,
"No words to say about your teach"
Please upload More videos
Sir plz complete all topics data warehousing
Yaar iss admi se mujhe pyaar hi hai
Sir please htet CS Ka New batch suru kr do it's humble request bcz last tym mere pass sirf 2 months the preparation krne ke liya air mere 3 marks se htet qualify hone se rh giya in general category so is baar mere ko 90+obtain krna h
Plz start the new batch of Htet CS as soon as possible thank you 🙏🙏
Sir Please November takh Data Warehouse & Mining ka syllabus cover kar na try karna please sir 🙏💙
Sir nimcet ke liye bhi video bnaye please
Sir plz cloud computing, soft computing subject ki upar video upload kardo. Bhut help hota hai sir apka video se. Plz sir ... Mai 3rd yaar Tak isi channel sei padhai Kiya hu sir lekin 4th yaar ka koiee bhi subject apne padhaya nhi. Plz sir help us , we need your help plz
Normalised queries will have lots of joins. So those may not be simple always
Video on timing diagramm please❤
Sir
Will u pls upload paper 1 classez
Sir please try to enhance video duration, its too short and must be of 10 minutes
I❤U sir
"mein to pagal ho jaun ga" got me😂
meri exam h 25se student of BCA Last year hope so paper ache jaye & paas ho jao
Same
Same
Placement ho gyi?
Sir OLAP Operations.?
Thank u sir hamaray Pakistani teachers apsy parh lay pr hamay is trah se smjai to hum aj yahan na hotay chandrayan 5 me hotay
Oo nice are you from Pakistan don't worry just do hard work India is growing every single minute one day you will make your country proud
😂😂❤
Bas maqsad bhul jao 😅
Tum bs rote raho hame y o karo kuch mt
Sir why are you looking weak day by day, aisa mano polio kaa patient hogye ho, hit the gym sir, baki apke lectures are fantastic
thanks.....