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 KZbin: / 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/gatesmash...
► Follow us on Threads: www.threads.ne...
--------------------------------------------------------------------------------------------------------------------------------------
►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

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

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

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

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

[@anmolmonga8883]

Thanks for teaching in a simple way

[@sinister_rules]

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

[@vivektiwari7017]

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

[@thunderking444]

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

[@rohit2521]

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

[@sharadkumarpani7625]

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

[@sriya93]

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

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

[@sanchitchavan]

Very good Explanation sir, plz complete this Playlist ❤

[@souravbhagat1358]

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

[@khushidubey5360]

👌 wow thanks alot

[@tanayshah7505]

Thank You sir for the DATA WAREHOUSE playlist Waiting for more

[@Blackoutfor10days]

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

[@robinpreetsingh2855]

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

[@PrithaMajumder]

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

[@ayushipatel941]

thankyou so much you really explain so welll

[@Nalinee01]

Well & Simple Way Of explaination....Thanks

[@saileshshiwakoti2160]

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

[@nileshsahu2679]

Helpful

[@archanarathore730]

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

[@Sanskruti_All_Together]

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

[@swathiblogs]

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

[@souravbhagat1358]

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

[@chungusvfx5249]

Yaar iss admi se mujhe pyaar hi hai

[@user-sw2vc1ic3z]

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

[@ananyasolanki7476]

Very easy explanation sir. Thanks a lot

[@roopagaur8834]

Best explanation thanks ❤

[@sreehari9431]

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

[@worldacademy1706]

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

[@niya22p]

you always provide best content...thank you👍

[@swatiacharya9073]

Thank you so much for ur videos

[@MohammedAmeenuddin-eb8gu]

mashallah well explained

[@rajashekar4171]

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

[@jkssbjobtutorial.5061]

Nice explanation sir🙏🙏🙏

[@hasnainakbar8621]

Please make video on CDC ELT Interview questions also

[@vishal.patil01]

Thank you sir for this playlist❤

[@AkashKumarSingh-kr8kj]

you explanation is just amazing loved it

[@soumilighosh7679]

You are the best sir❤

[@abhishekrajputt]

Sir plz complete all topics data warehousing

[@vimalradadiya5929]

Thank you sir 🙏 for this video

[@user-iy4bo3ob4y]

nice explaination

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

[@Education..29071]

Thank you so much😊😊

[@answeetapereira8766]

Thank you 👍

[@ShreyashSangle-fu8to]

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

[@afrozasultana9209]

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

[@rutujapatil9398]

Thanks for sharing this video

[@CartoonYouTubeAs-et1oy]

Zabardast sir ge ❤

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

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

[@ayushranjan724]

Thank you so much ❤❤❤❤

[@rupanag]

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

[@user-ry5dl8gc6g]

Thank you❤

[@akmalhussain7449]

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

[@wajihaliaquat3365]

Nice 👍

[@shahanam310]

Sir Will u pls upload paper 1 classez

[@Dattarjun]

Thanks....

[@sonianandy4035]

Best sir ❤️

[@AlokKr-hx3uo]

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

[@snehamahat2828]

Video on timing diagramm please❤

[@dharmindersekhon]

Mza aa gya.

[@maqsoodshaikh901]

Sir OLAP Operations.?

[@abdullrehman8575]

"mein to pagal ho jaun ga" got me😂

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

[@riddhijaglan3902]

👌

[@aamirjunaidofficial]

I❤U sir

[@apnakushtiwalla]

Sir nimcet ke liye bhi video bnaye please

[@sakshiwakode]

thanks.....