【Database】Overview

Posted by 西维蜀黍 on 2024-10-01, Last Modified on 2025-05-23

Category

By <What Goes Around Comes Around… And Around…>

  1. MapReduce Systems
  2. Key-value Stores:
    1. Memcached, Redis
    2. Amazon DynamoDB
  3. Document Databases
  4. Column Family / Wide-Column Databases
    1. Cassandra, HBase, Google’s BigTable
  5. Text Search Engines
    1. Elasticsearch and Solr, which both use Lucene as their internal search library
  6. Array Databases
  7. Vector Databases
  8. Graph Databases
    1. Neo4j
    2. Tigergraph and JanusGraph

By Cloud

Database Technology Selection

  • HBase:

    • 类型:宽表,column-oriented DB,列族存储数据库(Column Family)
    • 写入性能:写入快,依赖顺序写入到 HDFS
    • 读取性能:依赖 HDFS Block 读取,延迟相对高
    • 数据模型:类似 Google Bigtable:表 → 列族 → 列
    • 可用性 vs 一致性:偏向一致性(CP in CAP)
  • Hive

  • Cassandra,无列族

    • 类型:分布式列式数据库,完全去中心化架构
    • 写入性能:写入速度快,支持高并发
    • 读取性能:支持高效读取,特别适合 OLTP
    • 数据模型:表 → 行 → 列,类似 Bigtable,但无列族
    • 可用性 vs 一致性:偏向可用性(AP in CAP)
  • Clickhouse

Reference