What users are saying about
Top Rated
54 Ratings
69 Ratings
Top Rated
54 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.3 out of 101
69 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.6 out of 101

Add comparison

Likelihood to Recommend

Amazon DynamoDB

DynamoDB is great for two cases. The first is for services that do not experience high loads or demand high availability. DynamoDB is inexpensive, and it provides great developer velocity. The second is for applications that demand high performance, have well-understood requirements, and a narrow range of queries.
No photo available

Google BigQuery

BigQuery is extremely well suited to being a general purpose analytics data warehouse, i.e. if you have large datasets that you wish to extract insights from, and are comfortable with SQL, then BigQuery should be the only place those data live. BigQuery is also extremely well suited to driving enterprise-level dashboards on your actual data, decreasing the deviation of the summarized data from the raw. BigQuery is not as well suited to cases where you hope to return very large datasets, as it is optimized for aggregations.
Alex Andrews profile photo

Feature Rating Comparison

NoSQL Databases

Amazon DynamoDB
7.9
Google BigQuery
Performance
Amazon DynamoDB
8.0
Google BigQuery
Availability
Amazon DynamoDB
8.4
Google BigQuery
Concurrency
Amazon DynamoDB
9.0
Google BigQuery
Security
Amazon DynamoDB
8.7
Google BigQuery
Scalability
Amazon DynamoDB
9.7
Google BigQuery
Data model flexibility
Amazon DynamoDB
4.0
Google BigQuery
Deployment model flexibility
Amazon DynamoDB
7.3
Google BigQuery

Database-as-a-Service

Amazon DynamoDB
Google BigQuery
7.7
Automatic software patching
Amazon DynamoDB
Google BigQuery
10.0
Database scalability
Amazon DynamoDB
Google BigQuery
7.5
Automated backups
Amazon DynamoDB
Google BigQuery
7.7
Database security provisions
Amazon DynamoDB
Google BigQuery
9.1
Monitoring and metrics
Amazon DynamoDB
Google BigQuery
5.3
Automatic host deployment
Amazon DynamoDB
Google BigQuery
6.6

Pros

  • Amazon DynamoDB is infinitely scalable. It is fast and Amazon automatically allocates more resources.
  • No predefined schema is required. This ensures flexibility.
  • Minimum administrative cost since Amazon manages all that. This works for small companies since you don't need a DevOps headcount.
No photo available
  • BigQuery is a highly optimized, columnar oriented database, and as such it exceeds when doing complex aggregations over massive datasets, i.e. computing n-tiles, statistics, sorting, etc.
  • BigQuery is seamlessly integrated with the rest of the Google Cloud Platform stack, and as such it is extremely easy to move data in and out of BigQuery for analysis and storage. However, it also exposes very well defined APIs for inserting and streaming data in, and as such can be used easily with other on-premeses or cloud solutions.
  • Because BigQuery is fully managed, there is no need to think about provisioning machines, optimizing memory/cores, 'vacuuming', etc. This increases the 'democratization' effect BigQuery can have, as a basic knowledge of SQL is all that is needed to get started.
Alex Andrews profile photo

Cons

  • It's a NoSQL database. That means you lose all the capabilities of a traditional RDBMS model. You can't do joins to query data and you lose ACID properties.
  • DynamoDB does not support multiple indices. That means for certain queries, you need to do full table scans which is not desirable. There are work arounds for this.
  • The provisioned throughput doesn't degrade gracefully. That means that once you hit the limit, the requests are denied. It's tricky to come up with the limits of your application.
No photo available
  • Documentation is not complete, sometimes not clear.
  • Performance is unstable occasionally.
  • Error message not clear.
Charles Chao profile photo

Likelihood to Renew

Amazon DynamoDB7.1
Based on 13 answers
As I said earlier, DynamoDB works well for our application. There's a few shortcoming but there's workarounds for almost everything.
No photo available
No score
No answers yet
No answers on this topic

Alternatives Considered

DynamoDB is fully managed which is a great plus over MongoDB. The feature set is not as strong on MongoDB's for document databases, but it the managed aspect is highly compelling. Similarly for Cassandra, DynamoDB is managed. DynamoDB scales much better than CouchDB.
No photo available
Comparing to competitors, Google BigQuery has the lowest cost and most flexible pricing model. Definitely higher ROI.
Charles Chao profile photo

Return on Investment

  • We have had to back out some entities out of Amazon DynamoDB in favor of a relational database, which has been a major issue costing us around 20 man days of effort.
  • Amazon DynamoDB has given us extremely fast search, by indexing dynamo entities in Amazon CloudSearch and then doing fast lookup in dynamo of the key stored in Amazon CloudSearch.
  • Overall, Dynamo has been a pain point due to smaller situations typically requiring a simple, relational database. I would be enthusiastic about Dynamo for large tables, but when needs are smaller it can be overkill.
Jordan Bayles profile photo
  • Increased employee efficiency: interactive analytical queries can run much faster on BigQuery, problems are discovered/identified quicker.
  • KPI reports are delivered to management much quicker.
  • Overall reduced cost for BlueCava.
Charles Chao profile photo

Pricing Details

Amazon DynamoDB

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

Google BigQuery

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details