資料庫類型

資料庫類型

如何選擇資料庫

常見資料庫類類型

  • Relational
  • Columnar
  • Key-value
  • In-memory
  • Wide column
  • Time Series
  • Immutable ledger
  • Geospatial
  • Graph
  • Document
  • Text search
  • Blob

Database 資料庫

Structured 結構化資料庫 SQL

使用情境 類型 AWS Azure GCP Cloud Agnostic
Transactions OLTP 交易 Relational 關聯式 RDS, Aurora Azure SQL Database Cloud SQL Cloud Spanner
Analytics OLAP 分析 Columnar RedShift Azure Synapse Big Query Snowflake, ClickHouse, Druid, Pinot, Databricks

Semi-Structured 半結構化資料庫 NoSQL

Dictionary 字典

使用情境 類型 AWS Azure GCP Cloud Agnostic
Dictionary Key-Value DynamoDB Cosmos DB BigTable Redis, ScyllaDB, Ignite
Dictionary Cache In-memory ElastiCache Azure Cache for Redis Memorystore Redis, Memorycached, Hazeicast, Ignite

2-D Key-Value

使用情境 類型 AWS Azure GCP Cloud Agnostic
2-D Key-Value Wide Column Keyspaces Cosmos DB BigTable HBase, Cassandra, ScyllaDB
2-D Key-Value Time Series Time Series Timestream Cosmos DB BigTable, BigQuery OpenTSDB, InfluxDB, ScyllaDB
2-D Key-Value Audit Trail Immutable Ledger Quantum Ledger Database (QLDB) Azure SQL Database Ledger X Hyperledger Fabric
2-D Key-Value Location & Geo-entities Geospatial Keyspace Cosmos DB BigTable, BigQuery Solr, PostGIS, MongoDB (GeoJSON)

Entity-Relationships

使用情境 類型 AWS Azure GCP Cloud Agnostic
Entity-Relationships Graph Neptune Cosmos DB JanusGraph, BigTable OrientDB, Neo4J, Giraph

Nested Objects

使用情境 類型 AWS Azure GCP Cloud Agnostic
Nested Objects (XML, JSON) Document Document DB Cosmos DB Firestore MongoDB, Clouchbase, Solr

Rich Text

使用情境 類型 AWS Azure GCP Cloud Agnostic
Rich Text Full Text Search Text Search OpenSearch, CloudSearch Congnitive Search Search APIs on Datastores Elastic Search, Solr, Elassandra

Unstructured 無結構化資料庫 NoSQL

使用情境 類型 AWS Azure GCP Cloud Agnostic
Static File Blob S3 Blob Storage Cloud Storage HDFS, MinIO

參考資料