DB-Tools.com - system comparision
25th October 2020, Sunday
 
Home > System Comparision

Please Choose another system Click here

Editorial information provided by DB-Tools
System Azure Cosmos DB AWS Aurora
 Name Azure Cosmos DB AWS Aurora
 Version NA Version 4.2.8
 Drawbacks 1.Most often compared with MongoDB. Unlike Mongo DB does not support joins 2.Managed Database which can be used only within Azure/Microsoft framework NA
 Advantages NA Managed RDBMS from AWS
 Languages Supported .net, C#, Javascript Content Management Interoperability Services (CMIS)
 Website www.azure.microsoft.com/­services/­cosmos-db aws.amazon.com/rds/aurora/
 XML Support no no
 JSON Support yes yes
 Brief description 1.Globally distributed, horizontally scalable, multi-model database service 2.Earlier called Azure Document DB. Skype, Xbox uses this DB, Office, Active Directory and MSC (all Microsoft products) Aurora is available as part of the Amazon Relational Database Service (RDS). Although it is a proprietary technology it offers MySQL compatible service since its release . This was made PostgreSQL compatible since October 2017
 Database Model Key Value DB Relational Database
 Technical Documentation docs.microsoft.com/­en-us/­azure/­cosmos-db https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.html
 License commercial on azure cloud. Commercial
 Cloud-based / SaaS Azure Cloud based SaaS Service from AWS
 Implementation Language NA NA
 Operating System Supported Linux , OS X, Windows Not Applicable as its managed by AWS
 Options for Integration / Access API Rest API , MongoDB drivers Restful HTTP
 Consistency Eventual consistency NA
 Foreign Keys No Yes
 Streaming Support No Yes
 Analytics Support NA NA
 Data Storage Schema Multi Model Database NA
 Notable Users -- NA
 Key Differentiator -- Supports MySQL as a SaaS service (Inno Db Engine). Disk Space provisioning done in 10 GB chunks automatically upto 64 TB.
 Concurrency -- Yes
 Partitioning -- No
 Replication -- Yes
 Secondary Indexes -- Yes based on secondary indexes using Solr
 SchemaLess -- Yes
 SQL Query -- No