Explain By Example: OLTP vs OLAP

TL;DR:
Watch OLTP vs OLAP explained using a simple school analogy.

I had so much fun making the first video that I decided to start on the second one shortly after.

If you have read the actual blog post for this topic which is on OLTP vs. OLAP, you would notice that at the end I mention a section that describes the difference between normalisation vs. denormalisation. I originally planned to incorporate it into this video and even made all the animations and voice over but upon review, I decided I hated it. It was an awful example and I'm not sure why no one told me off for using it.

So, if you're wondering what happened to that section, there is a reason why it is missing. I suppose when you review old content you made almost two years ago, there are a lot of self-reflection (and possibly regrets) involved so I'll save you the horror even though it was only an extra minute long.

Thanks for watching. Remember to thumbs up/down, subscribe, and leave a comment below!

🐦 Need someone to talk to? Tweet me: @mishxie

[KARTHIKEYANRE-tncz]

I have been through lot of videos for OLAP, OLTP and Warehouse, but ended with this example and ended my loop of search because of this END = "Explain by Example". Thanks!!

[yousefomairi]

I am lucky that i found your channel in youtube
Thank you for the easy and non-boring explain you make 💙

[ayappakn]

Amazing!!, never thought OLTP and OLAP concepts could be explained like this!! It was so much fun watching this video Thank you!!

[bluis]

Great example, now I know the terms for things I've been using and doing for years.

[josephdoe]

Your video is amazing. YouTube is hard but you genuinely sound pleasant and present like a professional. Please don't stop. Hope to see you be big some day.👌

[sandyboxer]

shit!!!! after looking and understanding with your example, i realised how dumb im lolll.. thanks i was confused with both of the names however i got it now...keep rocking, good content and its really creative idea to have a youtube cHannel like this which helps to understand information as "piece of cake" ofcourse the credit is your ideology.. good luck for your future plans

[enrique-zarate]

4:50 is where my mind finally made “click”. Amazing video.

[dansinn]

Very well explained, 3:55 is my favourite part

[EdsonNascimentoEN]

Very nice explanation, thanks for sharing. I wonder what software you used to draw the beautiful explanation.

[YousefHaidary]

wow you have a great way of delivering information in a very clear way, thank you!

[palihno]

That's a great example. Very clear and informative.

[Quraovers]

Thanks, very easy to understand. Makes a lot of sense now!

[KenLaw-fuwh]

You are the nature explainer and thanks for kind sharing!!

[udohchigozie]

Wow, this is very very nice. Thanks a lot I now have a far better understanding.

[SahilKashyap]

🙏Thank you, you made it so easy to understand. Now I can easily explain these terms to my collegues.

[pubgcalling]

I don't learn about olap but I learn about data ware house and database 😅

[smugglemuffins]

I’m stuck very confused. Is the only difference where they search for the data? Do one from a database with current quick information and the other a data warehouse with more in depth and broadly sought after reasoning for the answer?

[cewneyseg]

Dat was soo good
Simply explained with examples

Thank you alot ☺

[surabhisharma]

Crystal clear explanation. Thanks alot 😊

[Artouple]

Wotta a great video! Found a treasure:))