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 RUclips: / 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

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

[@omanshcoolguy6019]

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

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

[@sinister_rules]

Ohh man, hats off to you sir such a GEM teacher

[@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 ❤

[@sriya93]

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

[@vivektiwari7017]

Bhai ko bhut bhut dhanyawad Mera msc cs complete karane ke liye❤

[@swathiblogs]

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

[@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.

[@anmolmonga8883]

Thanks for teaching in a simple way

[@ananyasolanki7476]

Very easy explanation sir. Thanks a lot

[@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 ❤

[@sanchitchavan]

Very good Explanation sir, plz complete this Playlist ❤

[@tanayshah7505]

Thank You sir for the DATA WAREHOUSE playlist
Waiting for more

[@vishal.patil01]

Thank you sir for this playlist❤

[@thunderking444]

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

[@Sanskruti_All_Together]

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

[@rohit2521]

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

[@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.

[@sharadkumarpani7625]

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

[@saileshshiwakoti2160]

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

[@niya22p]

you always provide best content...thank you👍

[@robinpreetsingh2855]

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

[@AkashKumarSingh-kr8kj]

you explanation is just amazing loved it

[@Nalinee01]

Well & Simple Way Of explaination....Thanks

[@PrithaMajumder]

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

[@jkssbjobtutorial.5061]

Nice explanation sir🙏🙏🙏

[@swatiacharya9073]

Thank you so much for ur videos

[@archanarathore730]

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

[@sreehari9431]

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

[@vimalradadiya5929]

Thank you sir 🙏 for this video

[@ayushipatel941]

thankyou so much you really explain so welll

[@user-sw2vc1ic3z]

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

[@nileshsahu2679]

Helpful

[@chungusvfx5249]

Yaar iss admi se mujhe pyaar hi hai

[@roopagaur8834]

Best explanation thanks ❤

[@rutujapatil9398]

Thanks for sharing this video

[@ayushranjan724]

Thank you so much ❤❤❤❤

[@worldacademy1706]

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

[@user-iy4bo3ob4y]

nice explaination

[@souravbhagat1358]

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

[@CartoonYouTubeAs-et1oy]

Zabardast sir ge ❤

[@answeetapereira8766]

Thank you 👍

[@MohammedAmeenuddin-eb8gu]

mashallah well explained

[@Education..29071]

Thank you so much😊😊

[@dharmindersekhon]

Mza aa gya.

[@Blackoutfor10days]

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

[@soumilighosh7679]

You are the best sir❤

[@wajihaliaquat3365]

Nice 👍

[@souravbhagat1358]

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

[@afrozasultana9209]

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

[@rajashekar4171]

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

[@user-ry5dl8gc6g]

Thank you❤

[@hasnainakbar8621]

Please make video on
CDC
ELT
Interview questions also

[@Dattarjun]

Thanks....

[@sonianandy4035]

Best sir ❤️

[@abhishekrajputt]

Sir plz complete all topics data warehousing

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

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

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

[@ShreyashSangle-fu8to]

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

[@apnakushtiwalla]

Sir nimcet ke liye bhi video bnaye please

[@akmalhussain7449]

OLTP and OLAP for both process will be design two database, AM I right?

[@abdullrehman8575]

"mein to pagal ho jaun ga" got me😂

[@riddhijaglan3902]

👌

[@AlokKr-hx3uo]

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

[@snehamahat2828]

Video on timing diagramm please❤

[@shahanam310]

Sir
Will u pls upload paper 1 classez

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

[@aamirjunaidofficial]

I❤U sir

[@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.....