Column vs Row Oriented Databases Explained

Hussein Nasser โ€ข October 30, 2020
Video Thumbnail
Hussein Nasser Logo

Hussein Nasser

@hnasr

About

Join me as we discuss various software engineering topics with examples and add fun elements to them. We always try to learn by example here in this educational Youtube channel which we believe is the right way to learn. I love Software engineering (especially the backend) and I strive to be a better software engineer every day. Join me on this journey and let us learn together. All opinions, suggestions, and tips I provide in all of this channel's content are my own. Information provided is for educational purposes only. Consider becoming a member to support the channel https://www.youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join Check out my courses https://courses.husseinnasser.com Stay awesome! Hussein Nasser, http://www.husseinnasser.com Feel free to shoot me an email [email protected] twitter: @hnasr

Video Description

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 https://payhip.com/b/JVHIM ๐ŸŽ™๏ธListen to the Backend Engineering Podcast https://husseinnasser.com/podcast ๐Ÿญ Backend Engineering Videos https://www.youtube.com/playlist?list=PLQnljOFTspQUNnO4p00ua_C5mKTfldiYT ๐Ÿ’พ Database Engineering Videos https://www.youtube.com/playlist?list=PLQnljOFTspQXjD0HOzN7P2tgzu7scWpl2 ๐Ÿฐ Load Balancing and Proxies Videos https://www.youtube.com/playlist?list=PLQnljOFTspQVMeBmWI2AhxULWEeo7AaMC ๐Ÿ›๏ธ Software Archtiecture Videos https://www.youtube.com/playlist?list=PLQnljOFTspQXNP6mQchJVP3S-3oKGEuw9 ๐Ÿ“ฉ Messaging Systems https://www.youtube.com/playlist?list=PLQnljOFTspQVcumYRWE2w9kVxxIXy_AMo Become a Member https://www.youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join Support me on PayPal https://bit.ly/33ENps4 Stay Awesome, Hussein

Essential Camera Bag Upgrades

AI-recommended products based on this video

Loading...
COTUBLR 31 Inch Computer Desk, Home Office Desk, Simple Modern Small Desk for Bedroom, Writing Desk with Storage Bag, Study Table for Students, Grey Oak

COTUBLR 31 Inch Computer Desk, Home Office Desk, Simple Modern Small Desk for Bedroom, Writing Desk with Storage Bag, Study Table for Students, Grey Oak

(180)
$64.99
FREE delivery Thu, Jun 26
Loading...
Ball Head Manbily Tripod Head Metal Aluminum Body 360ยฐ Panoramic Monopod Head with Extra Arca Swiss Quick Release Plate, Load up to 17.6lbs/8kg,Camera Head for DSLR, Camcorder, Slider (Red)

Ball Head Manbily Tripod Head Metal Aluminum Body 360ยฐ Panoramic Monopod Head with Extra Arca Swiss Quick Release Plate, Load up to 17.6lbs/8kg,Camera Head for DSLR, Camcorder, Slider (Red)

(274)
$85.26$77.52
FREE delivery Jun 17 - 19Only 10 left in stock.
Loading...
koolehaoda Professional Gimbal Head Tripod Head Aluminum Alloy Heavy Duty 360ยฐ Panoramic with Arca-Swiss Standard 1/4 inch QR Plate for DSLR Cameras up to 55.11lbs/25kg. (GH-3)

koolehaoda Professional Gimbal Head Tripod Head Aluminum Alloy Heavy Duty 360ยฐ Panoramic with Arca-Swiss Standard 1/4 inch QR Plate for DSLR Cameras up to 55.11lbs/25kg. (GH-3)

(63)
$168.98
FREE delivery Thu, Jun 19
Loading...
koolehaoda L Shape Camera Bracket, Video Vertical Shooting Quick Release Plate L Stand Arca Swiss Compatible for Tripod Head Ballhead DSLR Camera

koolehaoda L Shape Camera Bracket, Video Vertical Shooting Quick Release Plate L Stand Arca Swiss Compatible for Tripod Head Ballhead DSLR Camera

(87)
$23.98
FREE delivery Thu, Jun 19 on your first order
Loading...
LICAEVEY 84MP Digital Camera, 6K 18X Optical Zoom Wide Angle DSLR Camera, 1500mAh Li Battery 3 Inch LCD Vlogging Camera for Travel Recording Video (Black)

LICAEVEY 84MP Digital Camera, 6K 18X Optical Zoom Wide Angle DSLR Camera, 1500mAh Li Battery 3 Inch LCD Vlogging Camera for Travel Recording Video (Black)

(0)
$124.30
FREE delivery Aug 19 - 29
Loading...
COLORCORAL Car Cleaning Gel Universal Dust Cleaner Vehicle Auto Detailing Car Vent Keyboard Cleaning Putty Cars Interior Cleaner Dashboard Dust Remover Putty Duster Wipes Swaps Cleaning Kit 160G

COLORCORAL Car Cleaning Gel Universal Dust Cleaner Vehicle Auto Detailing Car Vent Keyboard Cleaning Putty Cars Interior Cleaner Dashboard Dust Remover Putty Duster Wipes Swaps Cleaning Kit 160G

(76,306)
$10.99
3K+ bought in past month
Loading...
KLONA Handheld Steam Cleaner, Steam Cleaner for Home with 10 Accessory Kit, Multipurpose Portable Upholstery Steamer Cleaning with Safety Lock to Remove Grime, Grease.

KLONA Handheld Steam Cleaner, Steam Cleaner for Home with 10 Accessory Kit, Multipurpose Portable Upholstery Steamer Cleaning with Safety Lock to Remove Grime, Grease.

(67)
$52.99
FREE delivery Sun, Mar 22
Loading...
KLONA Handheld Steam Cleaner, Steam Cleaner for Home with 10 Accessory Kit, Multipurpose Portable Upholstery Steamer Cleaning with Safety Lock to Remove Grime, Grease, and More

KLONA Handheld Steam Cleaner, Steam Cleaner for Home with 10 Accessory Kit, Multipurpose Portable Upholstery Steamer Cleaning with Safety Lock to Remove Grime, Grease, and More

(51)
$49.99
FREE delivery Mon, Jun 16
400+ bought in past month
Loading...
Portable Steam Cleaner, Hand Held steamers for cleaning house, Home Multi Purpose-10-Piece Accessory Kit for Sofa,Carpets,Upholstery,Car,Floor,Bathroom,Mattress and More

Portable Steam Cleaner, Hand Held steamers for cleaning house, Home Multi Purpose-10-Piece Accessory Kit for Sofa,Carpets,Upholstery,Car,Floor,Bathroom,Mattress and More

(145)
$52.99
FREE delivery Wed, Jan 7
Loading...
COLORCORAL Car Cleaning Gel Universal Dust Cleaner Vehicle Auto Detailing Car Vent Keyboard Cleaning Putty Cars Interior Cleaner Dashboard Dust Remover Putty Duster Wipes Swaps Cleaning Kit 160G

COLORCORAL Car Cleaning Gel Universal Dust Cleaner Vehicle Auto Detailing Car Vent Keyboard Cleaning Putty Cars Interior Cleaner Dashboard Dust Remover Putty Duster Wipes Swaps Cleaning Kit 160G

(76,306)
$10.99
3K+ bought in past month
Loading...
SmallRig ZV-E1 Camera Baseplate for Sony ZV-E1, Built-in Cold Shoe Mount and QR Plate (for Arca) Quick Switch Between Tripod and Stabilizer for DJI RS 2 / RSC 2 / RS 3 / RS 3 Pro - 4314

SmallRig ZV-E1 Camera Baseplate for Sony ZV-E1, Built-in Cold Shoe Mount and QR Plate (for Arca) Quick Switch Between Tripod and Stabilizer for DJI RS 2 / RSC 2 / RS 3 / RS 3 Pro - 4314

(3)
$44.99
FREE delivery Thu, Jun 19
Loading...
SmallRig FX3 / FX30 HawkLock Quick Release Camera Cage Kit for Sony with Cable Clamp, Bulit-in QR Cold Shoe NATO Rail/QR Plate for Arca, Modular Design Compatible with Original XLR Handle - 4770

SmallRig FX3 / FX30 HawkLock Quick Release Camera Cage Kit for Sony with Cable Clamp, Bulit-in QR Cold Shoe NATO Rail/QR Plate for Arca, Modular Design Compatible with Original XLR Handle - 4770

(35)
$124.94
FREE delivery Thu, Jun 19
Loading...
SmallRig FX3 / FX30 HawkLock Quick Release Camera Cage Kit for Sony with XLR Handle Extension, Wrist Strap and Cable Clamp for HDMI, QR Cold Shoe, NATO Rail/QR Plate for Arca,Titanium Gray - 4771

SmallRig FX3 / FX30 HawkLock Quick Release Camera Cage Kit for Sony with XLR Handle Extension, Wrist Strap and Cable Clamp for HDMI, QR Cold Shoe, NATO Rail/QR Plate for Arca,Titanium Gray - 4771

(72)
$174.24$162.04
FREE delivery Thu, Jun 19
Loading...
AC Power Cord Cable Fit for Sony PS5 PS4 PS3 Slim PlayStation 5 4 3, Xbox Series X/S, Xbox One X/S, TV, Printer Universal 2 Prong Supply Replacement - (ETL Listed Cable)

AC Power Cord Cable Fit for Sony PS5 PS4 PS3 Slim PlayStation 5 4 3, Xbox Series X/S, Xbox One X/S, TV, Printer Universal 2 Prong Supply Replacement - (ETL Listed Cable)

(5,351)
$8.49
Prime
500+ bought in past month
Loading...
SanDisk 64GB Extreme PRO SDXC UHS-I Memory Card - C10, U3, V30, 4K UHD, SD Card - SDSDXXU-064G-GN4IN

SanDisk 64GB Extreme PRO SDXC UHS-I Memory Card - C10, U3, V30, 4K UHD, SD Card - SDSDXXU-064G-GN4IN

(71,074)
$21.99$16.59
FREE delivery Sun, Aug 10 on your first order
500+ bought in past month
Loading...
SanDisk 128GB Extreme PRO SDXC UHS-I Memory Card - C10, U3, V30, 4K UHD, SD Card - SDSDXXD-128G-GN4IN
Best Seller

SanDisk 128GB Extreme PRO SDXC UHS-I Memory Card - C10, U3, V30, 4K UHD, SD Card - SDSDXXD-128G-GN4IN

(71,074)
$29.99$26.61
FREE delivery Sun, Aug 10 on your first order
4K+ bought in past month