Tech Dummies - Narendra Lakshmana Gowda - YouTube
Welcome to TechDummies, your go-to channel for mastering software systems and architecture! I’m Narendra Lakshmana Gowda, an award-winning platform engineer ...
Overview
Added
March 17, 2026
Subject & domain
computer-science-advanced · distributed-systems
Grade range
Grade 9 (Freshman)–Grade 12 (Senior)
Page kind
Video
Keywords
"system design" "learn system design" "learn distributed systems" "amazon interview questions" "google interview questions" "system design interview question...
Introduction
Column-Oriented Databases: Overview and Analysis
- Core Concept: Databases designed for column-oriented storage (e.g., HBase).
- Key Advantages:
- Performance: Optimized for aggregation queries (COUNT, SUM, AVG, MIN, MAX).
- Efficiency: Superior data compression and partitioning capabilities.
- Scalability: Designed for Big Data with fast data loading.
- Integration: Compatible with numerous third-party Business Intelligence (BI) tools.
- Maintenance: Relatively simple system administration.
- Key Disadvantages:
- Transactions: Generally not supported or should be avoided.
- Joins: Performance significantly degrades when executing queries involving table joins.
- Data Modification: Updates and deletes negatively impact storage efficiency.
- Complexity: Designing effective indexing and partitioning schemes can be challenging.
Community reviews
No published reviews yet. Be the first to share your experience.