資料庫類型

資料庫類型

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

參考資料