Please enable JavaScript.
Coggle requires JavaScript to display documents.
Cosmos DB, Storage Services - Coggle Diagram
Cosmos DB
comprehensive
Service Level Agreements
throughput
latency
availability
consistency
multi-model database service
stores data in atom-record-sequence (ARS) format
data is then abstracted and projected as an API,
which you specify when you're creating your database
SQL
MongoDB
Cassandra
Tables
Gremlin
scalable
throughput and storage across any
number of Azure regions worldwide.
elastic
schema-less data
Storage Services
SQL Database
based on the latest stable version
of the Microsoft SQL Server database engine
PaaS
newest capabilitites are first released
on SQL Database than on SQL Server
high-performance
reliable
fully-managed
no user involviment required
patching
backups
monitoring
upgrading
user
focus on the domain-specific database
administration and optimization activities
secure
both relational and non-relational
structures
graphs
JSON
spatial
XML
SQL Managed Instance
scalable cloud data service
compatible with sql server
database engine
fully-managed
PaaS
many of the same
features propsed by SQL Database
share a common code base
look for differences here:
features-comparison
Azure database for MySQL
based on the MySQL Community Edition
database engine
point-in-time restore to recover
restore to and erilier state,
as far back as 35 days
fully-managed
Azure database for PostgreSQL
based on the community version of the open-source PostgreSQL database engine.
deployment options
single server
vertical scale as needed
hyperscale (citus)
horintontally scale
using shading
cales queries across multiple machines