Database 资料库

Database 资料库
Categories:
Tags:

如何选择资料库

常见资料库类类型

  • 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

参考资料