Compare the most common: Amazon DynamoDB, Azure Cosmos DB and Mongo DB

NameAmazon DynamoDBMicrosoft Azure Cosmos DB MongoDB 
DescriptionHosted, scalable database service by Amazon with the data stored in Amazons cloudGlobally distributed, horizontally scalable, multi-model database serviceOne of the most popular document stores
Primary database modelDocument store
Key-value store
Document store
Graph DBMS
Key-value store
Wide column store
Document store
Websiteaws.amazon.com/­dynamodbazure.microsoft.com/­services/­cosmos-dbwww.mongodb.com
Technical documentationdocs.aws.amazon.com/­dynamodbdocs.microsoft.com/­en-us/­azure/­cosmos-dbdocs.mongodb.com/­manual
DeveloperAmazonMicrosoftMongoDB, Inc
Initial release201220142009
License commercial commercialOpen Source 
Cloud-based only yesyesno 
Server operating systemshostedhostedLinux
OS X
Solaris
Windows
Data schemeschema-freeschema-freeschema-free 
Typing yesyes yes 
Secondary indexesyesyes yes
SQL noSQL-like query languageRead-only SQL queries via the MongoDB Connector for BI
APIs and other access methodsRESTful HTTP APIDocumentDB API
Graph API (Gremlin)
MongoDB API
RESTful HTTP API
Table API
proprietary protocol using JSON
Server-side scripts noJavaScriptJavaScript
Triggersyes JavaScriptno
Partitioning methods ShardingSharding Sharding
Replication methods yesyes Master-slave replication
MapReduce no with Hadoop integration yes
Consistency concepts Eventual Consistency
Immediate Consistency 
Bounded Staleness
Consistent Prefix
Session Consistency
Eventual Consistency
Immediate Consistency 
Eventual Consistency
Immediate Consistency 
Foreign keys nonono 
Transaction concepts ACID Multi-item ACID transactions with snapshot isolation within a partitionMulti-document ACID Transactions with snapshot isolation
Concurrency yesyesyes
Durability yesyesyes 
In-memory capabilities yes 
User concepts Access rights for users and roles can be defined via the AWS Identity and Access Management (IAM)Access rights can be defined down to the item levelAccess rights for users and roles
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *