Amazon DynamoDB vs Google Cloud Bigtable

Need advice about which tool to choose?Ask the StackShare community!

Amazon DynamoDB

3.7K
3.2K
+ 1
195
Google Cloud Bigtable

138
362
+ 1
25
Add tool

Amazon DynamoDB vs Google Cloud Bigtable: What are the differences?

Introduction

In this article, we will discuss the key differences between Amazon DynamoDB and Google Cloud Bigtable. Both DynamoDB and Cloud Bigtable are NoSQL database services offered by Amazon Web Services (AWS) and Google Cloud Platform (GCP), respectively. While they are similar in some aspects, they differ significantly in terms of features, scalability, pricing, and integration capabilities.

  1. Scalability: DynamoDB is designed to scale horizontally with built-in automatic partitioning and load balancing. It can seamlessly handle massive workloads and easily scale up or down based on demand. On the other hand, Cloud Bigtable also offers horizontal scalability, but it requires manual sharding and configuration adjustments for handling larger datasets and high traffic.

  2. Data Consistency: DynamoDB guarantees eventual consistency by default and provides strong consistency as an option, allowing developers to choose the level of consistency required for their applications. Cloud Bigtable, on the other hand, only provides eventual consistency, which means there may be a delay before changes to data are propagated across all replicas.

  3. Data Model: DynamoDB uses a key-value data model with support for complex data types such as lists, maps, and sets. It also provides secondary indexes for efficient querying. Cloud Bigtable, however, is a wide column-store database that organizes data by row keys. It does not support secondary indexes but offers column families for efficient storage and retrieval of large amounts of data.

  4. Querying and Indexing: DynamoDB supports rich querying capabilities using its Query API, which allows retrieval of data based on attributes other than the primary key. It also provides Global Secondary Indexes for efficient querying across different attribute values. Cloud Bigtable, on the other hand, requires designing the schema based on the anticipated query patterns as it does not offer advanced indexing and querying capabilities like DynamoDB.

  5. Integration: DynamoDB integrates seamlessly with various AWS services, such as AWS Lambda, AWS AppSync, and Amazon Redshift, enabling developers to build scalable and fully managed applications. Cloud Bigtable integrates well with other Google Cloud services like BigQuery, Dataflow, and Dataproc, enabling data processing and analysis in a serverless environment.

  6. Pricing: DynamoDB pricing is based on provisioned throughput and storage consumption, and customers pay for the resources they provision. It offers different pricing models with on-demand and provisioned capacity options. Cloud Bigtable pricing is based on the number and size of nodes in the cluster, with separate charges for storage consumption. It offers sustained usage discounts for long-running workloads.

In summary, Amazon DynamoDB and Google Cloud Bigtable differ in terms of scalability, data consistency, data model, querying capabilities, integration options, and pricing models. Choosing the right database service depends on specific use cases, requirements, and the existing tech stack.

Advice on Amazon DynamoDB and Google Cloud Bigtable

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?

See more
Replies (1)
William Frank
Data Science and Engineering at GeistM · | 2 upvotes · 110.3K 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.

See more
Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn More
Pros of Amazon DynamoDB
Pros of Google Cloud Bigtable
  • 62
    Predictable performance and cost
  • 56
    Scalable
  • 35
    Native JSON Support
  • 21
    AWS Free Tier
  • 7
    Fast
  • 3
    No sql
  • 3
    To store data
  • 2
    Serverless
  • 2
    No Stored procedures is GOOD
  • 1
    ORM with DynamoDBMapper
  • 1
    Elastic Scalability using on-demand mode
  • 1
    Elastic Scalability using autoscaling
  • 1
    DynamoDB Stream
  • 11
    High performance
  • 9
    Fully managed
  • 5
    High scalability

Sign up to add or upvote prosMake informed product decisions

Cons of Amazon DynamoDB
Cons of Google Cloud Bigtable
  • 4
    Only sequential access for paginate data
  • 1
    Scaling
  • 1
    Document Limit Size
    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 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 Google Cloud Bigtable?
    See which teams inside your own company are using Amazon DynamoDB or Google Cloud Bigtable.
    Sign up for StackShare EnterpriseLearn More

    Sign up to get full access to all the companiesMake informed product decisions

    What tools integrate with Amazon DynamoDB?
    What tools integrate with Google Cloud Bigtable?

    Sign up to get full access to all the tool integrationsMake informed product decisions

    Blog Posts

    GitHubPythonNode.js+47
    55
    72494
    GitGitHubSlack+30
    27
    18469
    GitHubDockerAmazon EC2+23
    12
    6583
    GitHubPythonSlack+25
    7
    3184
    DockerSlackAmazon EC2+17
    18
    5994
    What are some alternatives to Amazon DynamoDB 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
    See all alternatives