Column vs Row Oriented Databases Explained

Показать описание

In this video, I explain the differences between Column vs Row Oriented Database Storage how efficient each method is, and their pros & cons. We will also see how different queries perform against both types of databases.

0:00 Intro
2:50 Row-Oriented Database
15:30 Column-Oriented Database
26:30 Pros & Cons

Download slides here

🎙️Listen to the Backend Engineering Podcast

🏭 Backend Engineering Videos

💾 Database Engineering Videos

🏰 Load Balancing and Proxies Videos

🏛️ Software Archtiecture Videos

📩 Messaging Systems

Become a Member

Support me on PayPal

Stay Awesome,
Hussein

Рекомендации по теме

Комментарии

Clearly, you're a naturally gifted teacher. Great content.

DannyPhantumm

I understand this is one of your older videos, but wanted to mention that your content is first class! Thank you!

SrivatsanVenkatesan

Most interesting way of teaching I have ever found, learning can't be more fun than this!

PrashantZombade

Love the way you teach. I almost didn't want the video to end.

kharlcutie

Incredible video. I was to solidify my understanding of the concept of columnar databases vs row based and this video not only made it easy to understand, but enjoyable too!

richboiii

Great video man. I like a mix of column (for logging, source of truth) and table based RDBMS and also documented oriented (which could be either row or column) for quick trashy dirty data that makes you blush when you look at it too long.

But I've seen columns used for quick trashy data - where sums or map reduce is the highest priority and it blows everything else away. I am digging ScyllaDB lately.

videosforthegoodlife

Great video, well explained, fun and infomative. I loved that, thanks dude!

williamfelippedeschamps

The content of this channel is superb.

adrianasensio

One of the best explanations I had seen. Thanks man

foxtrotbr

Thank you very much for making this video with a real-time example. Much appreciated

murugesanrm

Gives concrete examples of when column database operations are faster or slower than a row database. Thank you!

haoyuanhuang

Visually clear, funny and interesting explanations, you are greatly talented.

HopeMlebe

Thank you so much for explaining this concept so beautifully and in such a great depth...I am a fan of your

harshitagrawal

Really awesome content. A really good source for me who is looking to improve the backend concepts. Really thank you for such good content. Just subscribed for updates

nishantgarg

Great work here! So many explanations of this are too high level, and miss the key differentiator: i.e. the way in which the data is accessed. You did a great job and did it at your own pace. Hope you find success with this style.

RooftopDuvet