What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
Top Rated
74 Ratings
4 Ratings

Amazon DynamoDB

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
Top Rated
74 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
4 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.4 out of 101

Likelihood to Recommend

Amazon DynamoDB

Amazon DynamoDB is absolutely the easiest and most efficient way to run a Non-Relational database. It's perfectly suited for a "source of truth" where other indexes might be built from data stored in DynamoDB, and for use where search patterns are predictable. It's also incredibly effective at storing relatively unstructured data, or data models that might frequently change. As it does not require a rigid definition of data beforehand, it makes adjusting data stored in the table a non-effort, but it does require some planning when looking at how to get data back out of the table.Unlike traditional SQL or Relational databases, DynamoDB is designed to have all relevant information within a single object. If not properly planned, this can lead to issues when building out a front-end. DynamoDB does not have join table support, nor does it support complex searches or "count" style responses. It is eventually consistent, although they recently did introduce Transaction support, there is no "rollback" option.
Chris Moyer profile photo

Apache Drill

if you're doing joins from hBASE, hdfs, cassandra and redis, then this works.Using it as a be all end all does not suit it. This is not your straight forward magic software that works for all scenarios. One needs to determine the use case to see if Apache Drill fits the needs. 3/4 of the time, usually it does.
Anson Abraham profile photo

Feature Rating Comparison

NoSQL Databases

Amazon DynamoDB
8.5
Apache Drill
Performance
Amazon DynamoDB
8.8
Apache Drill
Availability
Amazon DynamoDB
9.2
Apache Drill
Concurrency
Amazon DynamoDB
9.2
Apache Drill
Security
Amazon DynamoDB
9.1
Apache Drill
Scalability
Amazon DynamoDB
9.6
Apache Drill
Data model flexibility
Amazon DynamoDB
6.3
Apache Drill
Deployment model flexibility
Amazon DynamoDB
6.9
Apache Drill

Pros

Amazon DynamoDB

  • 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

Apache Drill

  • queries multiple data sources with ease.
  • supports sql, so non technical users who know sql, can run query sets
  • 3rd party tools, like tableau, zoom data and looker were able to connect with no issues
Anson Abraham profile photo

Cons

Amazon DynamoDB

  • 64KB limit on row size and 1MB limit on querying
  • Increasing throughput is expensive
  • Secondary indexes are not supported
No photo available

Apache Drill

  • deployment. Not as easy
  • configuration isn't as straight forward, especially with the documentation
  • Garbage collection could be improved upon
Anson Abraham profile photo

Likelihood to Renew

Amazon DynamoDB

Amazon DynamoDB 8.6
Based on 25 answers
Its more of a we are locked in and migration would be more time and resource intensive than is worth it. It is better to find ways to optimize dynamo usage like custom scaling, Redis based caches, or moving data to S3 than to leave the platflorm completely. It provides enough incentive and usefulness to continue to use
Adam Lauer profile photo

Apache Drill

Apache Drill 7.0
Based on 1 answer
if Presto comes up with more support (ie hbase, s3), then its strongly possible that we'll move from apache drill to prestoDB. However, Apache drill needs more configuration ease, especially when it comes to garbage collection tuning. If apache drill could support also sparkSQL and Flume, then it does change drill into being something more valuable than prestoDB
Anson Abraham profile photo

Alternatives Considered

Amazon DynamoDB

When we were selecting for a server-less NoSQL solution, we had two option either to go with Cosmos or with Dynamo. Cosmos has a few great features, but in Cosmos, we need to provision at least 400 RU (request unit), which will make a single table cost at least 24$/month. While in Dynamo we can even provision 1 WCU RCU which makes it very economical. Cosmos has many great features as compared to Dynamo but in most of the use cases, we didn't require those so we went with Dynamo.
No photo available

Apache Drill

compared to presto, has more support than prestodb.Impala has limitations to what drill can supportapache phoenix only supports for hbase. no support for cassandra. Apache drill was chosen, because of the multiple data stores that it supports htat the other 3 do not support. Presto does not support hbase as of yet. Impala does not support query to cassandra
Anson Abraham profile photo

Return on Investment

Amazon DynamoDB

  • Dynamodb reduced the need for SRE headcount to maintain infrastructure.
  • Built in metrics dove tails with existing monitoring tooling.
  • Flexible NoSQL design allows developers to focus on business problems, rather than database design.
Alan Balasundaram profile photo

Apache Drill

  • Configuration has taken some serious time out.
  • Garbage collection tuning. is a constant hassle. time and effort applied to it, vs dedicating resources elsewhere.
  • w/ sql support, reduces the need of devs to generate the resultset for analysts, when they can run queries themselves (if they know sql).
Anson Abraham 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

Apache Drill

General

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

Add comparison