OLAP vs OLTP | Difference between OLAP vs OLTP with Real Life Examples

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 TH-cam: / 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: [e-mail]
#oltp #datawarehouse #onlinetransaction

[@omanshcoolguy6019]

Best teacher of the world...make things so easy to understand with real life example... thanku very much sir

[@anjaliraj3353]

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 .😊😊

[@Hybridakkufitness]

BEST TEACHER OVER THE WORLD WHO PASSED ME WITH 75% IN BCA thankyou for the best and effective ,effective ,optimized knowledge

[@prithwibeshmallick69]

Bhai party do

[@sriya93]

This example was so beautiful that couldnt stop from putting in my comment. Really great teaching.

[@UtkarshKumarRaut2_0]

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.

[@swathiblogs]

The most wonderful analogy that I have ever come across!!!

[@sanchitchavan]

Very good Explanation sir, plz complete this Playlist ❤

[@tanayshah7505]

Thank You sir for the DATA WAREHOUSE playlist
Waiting for more

[@BahameenMajeed]

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 ❤

[@vishal.patil01]

Thank you sir for this playlist❤

[@TalhaKhan-1996]

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 ❤

[@rohit2521]

Thanks much, Bhai!! this is simple yet very comprehensive explanation on OLTP and OLAP.

[@ananyasolanki7476]

Very easy explanation sir. Thanks a lot

[@sharadkumarpani7625]

Even If I try to forget it now I wont be able to. He made it so simple. Great work.

[@niya22p]

you always provide best content...thank you👍

[@Sanskruti_All_Together]

Thank you so much sir for your wonderful explanation with best clarity to the concept😊

[@saileshshiwakoti2160]

best teaching sir!!!
great to have youtube,,internet

[@sonipk30]

Well & Simple Way Of explaination....Thanks

[@CartoonYouTubeAs-et1oy]

Zabardast sir ge ❤

[@manishachoudhary5249]

*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.

[@swatiacharya9073]

Thank you so much for ur videos

[@AkashKumarSingh-kr8kj]

you explanation is just amazing loved it

[@ayushipatel941]

thankyou so much you really explain so welll

[@jkssbjobtutorial.5061]

Nice explanation sir🙏🙏🙏

[@thunderking444]

Thank u Sir❤
Plz make videos fast on Data warehouse and data mining
Plzzzz sir🙏🏻🙏🏻
No one TH-camr can't teach like u
So plz make videos fastttt🙏🏻🙏🏻

[@archanarathore730]

Thank you sir.... You are God for us❤

[@vimalradadiya5929]

Thank you sir 🙏 for this video

[@roopagaur8834]

Best explanation thanks ❤

[@answeetapereira8766]

Thank you 👍

[@user-sw2vc1ic3z]

Sir please make full playlist as soon as possible we are waiting

[@souravbhagat1358]

Pls make a vedio lectures on Multidimensional view of data and its cube....

[@user-iy4bo3ob4y]

nice explaination

[@Education..29071]

Thank you so much😊😊

[@rutujapatil9398]

Thanks for sharing this video

[@sreehari9431]

The best class i ever had 😍😍 thank you sooo much sir ❤❤

[@user-ry5dl8gc6g]

Thank you❤

[@ayushranjan724]

Thank you so much ❤❤❤❤

[@wajihaliaquat3365]

Nice 👍

[@soumilighosh7679]

You are the best sir❤

[@MohammedAmeenuddin-eb8gu]

mashallah well explained

[@robinpreetsingh2855]

Sachi mai sir bohot acha padhata ho ap maina bohot ko dakha etna easy aur asaan trika se koi nhi padhata

[@dharmindersekhon]

Mza aa gya.

[@Dattarjun]

Thanks....

[@souravbhagat1358]

Pls make a vedio lecture on Design and Implementation of Data warehouse .

[@sonianandy4035]

Best sir ❤️

[@PrithaMajumder]

Sir, Thanks a lot for This Amazing Lecture 🙂
Lecture - 7 Completed ✅ in Data Warehouse Playlist

[@hasnainakbar8621]

Please make video on
CDC
ELT
Interview questions also

[@Blackoutfor10days]

Sir please complete the syllabus of data mining and warehousing in these two months

[@afrozasultana9209]

Very good explanation sir. Are you taking any class of Sql server Database Administrator? Please let me know.

[@riddhijaglan3902]

👌

[@abhishekrajputt]

Sir plz complete all topics data warehousing

[@rajashekar4171]

Please make more videos related to DataWarehousing,
"No words to say about your teach"
Please upload More videos

[@worldacademy1706]

I don't understand even one word of Hindi language, but I simply understood this one

[@onfit1451]

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

[@chungusvfx5249]

Yaar iss admi se mujhe pyaar hi hai

[@apnakushtiwalla]

Sir nimcet ke liye bhi video bnaye please

[@ShreyashSangle-fu8to]

Sir Please November takh Data Warehouse & Mining ka syllabus cover kar na try karna please sir 🙏💙

[@CodeCraftAli]

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

[@anandthakur9006]

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

[@Norani1-pq2ub]

😂😂❤

[@anindian4141]

Bas maqsad bhul jao 😅

[@shriyashjagtap6863]

Tum bs rote raho hame y o karo kuch mt

[@snehamahat2828]

Video on timing diagramm please❤

[@Grewalrdeep]

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

[@shahanam310]

Sir
Will u pls upload paper 1 classez

[@aamirjunaidofficial]

I❤U sir

[@alishaqueen14]

meri exam h 25se student of BCA Last year hope so paper ache jaye & paas ho jao

[@OfficeShorts2]

Same

[@OfficeShorts2]

Same

[@theHustler2354]

Placement ho gyi?

[@rupanag]

Normalised queries will have lots of joins. So those may not be simple always

[@AlokKr-hx3uo]

Sir please try to enhance video duration, its too short and must be of 10 minutes

[@abdullrehman8575]

"mein to pagal ho jaun ga" got me😂

[@maqsoodshaikh901]

Sir OLAP Operations.?

[@Spider-Man_67]

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

[@sakshiwakode]

thanks.....