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

En bref

Ajouté le

17 mars 2026

Matière et domaine

computer-science-advanced · distributed-systems

Niveaux scolaires

9e année (3e)–12e année (Terminale)

Type de page

Video

Mots-clés

"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.

Avis de la communauté

Pas encore d’avis publiés. Soyez le premier à partager votre expérience.