Need advice about which tool to choose?Ask the StackShare community!
Amazon DynamoDB vs Azure Cosmos DB vs Google Cloud Bigtable: What are the differences?
# Introduction
Key differences between Amazon DynamoDB, Azure Cosmos DB, and Google Cloud Bigtable are outlined below:
1. **Data Structure and Model**: Amazon DynamoDB uses a key-value data model with optional support for secondary indexes, Azure Cosmos DB offers a multi-model approach supporting key-value, document, column-family, graph, and Azure Table storage data models, whereas Google Cloud Bigtable is a wide-column store allowing for high-speed storage and retrieval of structured data.
2. **Consistency and Availability**: DynamoDB provides eventual consistency by default with options for strong consistency, Azure Cosmos DB offers five consistency levels to choose from to achieve the desired trade-off between consistency and availability, and Google Cloud Bigtable guarantees high availability and durability but sacrifices consistency in favor of performance.
3. **Scalability**: DynamoDB scales horizontally by increasing read/write capacity units, Azure Cosmos DB provides global distribution and autoscaling based on workload patterns for seamless scalability, and Google Cloud Bigtable offers automatic sharding for handling large amounts of data by distributing it across multiple nodes.
4. **Pricing and Costs**: DynamoDB pricing is based on provisioned throughput capacity and storage used, Azure Cosmos DB follows a pay-as-you-go model charging for throughput, storage, and data transfer, while Google Cloud Bigtable offers pricing based on the amount of storage used and network egress.
5. **Query Language Support**: Amazon DynamoDB supports queries using a SQL-like syntax through the Query and Scan operations, Azure Cosmos DB allows for querying data using SQL, MongoDB, Gremlin, Table, and Cassandra APIs, and Google Cloud Bigtable offers limited querying capabilities with filters but no full SQL support.
6. **Ecosystem Integration**: DynamoDB integrates seamlessly with other AWS services like Lambda, S3, and IAM for a holistic cloud experience, Azure Cosmos DB integrates with Azure services such as Azure Functions, Logic Apps, and Event Grid for building end-to-end solutions, while Google Cloud Bigtable integrates well with Google Cloud Platform services such as Dataflow, Dataproc, and BigQuery for analytics and processing.
In Summary, Amazon DynamoDB, Azure Cosmos DB, and Google Cloud Bigtable differ in their data models, consistency levels, scalability options, pricing models, query language support, and ecosystem integrations to cater to diverse cloud storage and processing needs.
Advice on Amazon DynamoDB, Azure Cosmos DB, and Google Cloud Bigtable
akash maurya
We are building a social media app, where users will post images, like their post, and make friends based on their interest. We are currently using Cloud Firestore and Firebase Realtime Database. We are looking for another database like Amazon DynamoDB; how much this decision can be efficient in terms of pricing and overhead?
Replies (1)
William Frank
Data Science and Engineering at GeistM · | 2 upvotes · 111.4K views
Recommends
Hi, Akash,
I wouldn't make this decision without lots more information. Cloud Firestore has a much richer metamodel (document-oriented) than Dynamo (key-value), and Dynamo seems to be particularly restrictive. That is why it is so fast. There are many needs in most applications to get lightning access to the members of a set, one set at a time. Dynamo DB is a great choice. But, social media applications generally need to be able to make long traverses across a graph. While you can make almost any metamodel act like another one, with your own custom layers on top of it, or just by writing a lot more code, it's a long way around to do that with simple key-value sets. It's hard enough to traverse across networks of collections in a document-oriented database. So, if you are moving, I think a graph-oriented database like Amazon Neptune, or, if you might want built-in reasoning, Allegro or Ontotext, would take the least programming, which is where the most cost and bugs can be avoided. Also, managed systems are also less costly in terms of people's time and system errors. It's easier to measure the costs of managed systems, so they are often seen as more costly.
Manage your open source components, licenses, and vulnerabilities
Learn MorePros of Amazon DynamoDB
Pros of Azure Cosmos DB
Pros of Google Cloud Bigtable
Pros of Amazon DynamoDB
- Predictable performance and cost62
- Scalable56
- Native JSON Support35
- AWS Free Tier21
- Fast7
- No sql3
- To store data3
- Serverless2
- No Stored procedures is GOOD2
- ORM with DynamoDBMapper1
- Elastic Scalability using on-demand mode1
- Elastic Scalability using autoscaling1
- DynamoDB Stream1
Pros of Azure Cosmos DB
- Best-of-breed NoSQL features28
- High scalability22
- Globally distributed15
- Automatic indexing over flexible json data model14
- Tunable consistency10
- Always on with 99.99% availability sla10
- Javascript language integrated transactions and queries7
- Predictable performance6
- High performance5
- Analytics Store5
- Rapid Development2
- No Sql2
- Auto Indexing2
- Ease of use2
Pros of Google Cloud Bigtable
- High performance11
- Fully managed9
- High scalability5
Sign up to add or upvote prosMake informed product decisions
Cons of Amazon DynamoDB
Cons of Azure Cosmos DB
Cons of Google Cloud Bigtable
Cons of Amazon DynamoDB
- Only sequential access for paginate data4
- Scaling1
- Document Limit Size1
Cons of Azure Cosmos DB
- Pricing18
- Poor No SQL query support4
Cons of Google Cloud Bigtable
Be the first to leave a con
Sign up to add or upvote consMake informed product decisions
What is Amazon DynamoDB?
With it , you can offload the administrative burden of operating and scaling a highly available distributed database cluster, while paying a low price for only what you use.
What is Azure Cosmos DB?
Azure DocumentDB is a fully managed NoSQL database service built for fast and predictable performance, high availability, elastic scaling, global distribution, and ease of development.
What is Google Cloud Bigtable?
Google Cloud Bigtable offers you a fast, fully managed, massively scalable NoSQL database service that's ideal for web, mobile, and Internet of Things applications requiring terabytes to petabytes of data. Unlike comparable market offerings, Cloud Bigtable doesn't require you to sacrifice speed, scale, or cost efficiency when your applications grow. Cloud Bigtable has been battle-tested at Google for more than 10 years—it's the database driving major applications such as Google Analytics and Gmail.
Need advice about which tool to choose?Ask the StackShare community!
What companies use Amazon DynamoDB?
What companies use Azure Cosmos DB?
What companies use Google Cloud Bigtable?
What companies use Amazon DynamoDB?
What companies use Azure Cosmos DB?
Sign up to get full access to all the companiesMake informed product decisions
What tools integrate with Amazon DynamoDB?
What tools integrate with Azure Cosmos DB?
What tools integrate with Google Cloud Bigtable?
What tools integrate with Amazon DynamoDB?
What tools integrate with Azure Cosmos DB?
What tools integrate with Google Cloud Bigtable?
Sign up to get full access to all the tool integrationsMake informed product decisions
Blog Posts
+17 16
6864
+47 55
72626
+46 27
32689
+30 27
18575
+23 12
6593
+37 123
38063
+25 7
3200
+17 18
6006
What are some alternatives to Amazon DynamoDB, Azure Cosmos DB, and Google Cloud Bigtable?
Google Cloud Datastore
Use a managed, NoSQL, schemaless database for storing non-relational data. Cloud Datastore automatically scales as you need it and supports transactions as well as robust, SQL-like queries.
MongoDB
MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
Amazon SimpleDB
Developers simply store and query data items via web services requests and Amazon SimpleDB does the rest. Behind the scenes, Amazon SimpleDB creates and manages multiple geographically distributed replicas of your data automatically to enable high availability and data durability. Amazon SimpleDB provides a simple web services interface to create and store multiple data sets, query your data easily, and return the results. Your data is automatically indexed, making it easy to quickly find the information that you need. There is no need to pre-define a schema or change a schema if new data is added later. And scale-out is as simple as creating new domains, rather than building out new servers.
MySQL
The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
Amazon S3
Amazon Simple Storage Service provides a fully redundant data storage infrastructure for storing and retrieving any amount of data, at any time, from anywhere on the web