What users are saying about
Top Rated
54 Ratings
90 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
90 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.5 out of 101

Add comparison

Likelihood to Recommend

Amazon DynamoDB

DynamoDB is well suited when you have small development team and want ease of scaling and operations. Since it is hosted by Amazon, it provides a fully managed service. It provides great read and write for simple queries. When you have complex queries, I think this is not well suited. We need to remember this is not suited for a relational database.
No photo available

Amazon Redshift

Redshift is a viable platform to house a large or very large data warehouse designed for performance and scalability. It is especially well-suited in the cases where your source data is already stored inside of the AWS services infrastructure.
Michael Romm profile photo

Feature Rating Comparison

NoSQL Databases

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

Pros

  • No need to worry about hosting and ease of scaling and operations
  • Distributed and flexible as Amazon DynamoDB does not have a fixed schema
  • Based on load, options to increase throughput
No photo available
  • Redshift seems to be as fast processing a large dataset as it is with a small one. It seems, when the dataset size is significantly increased (10x, 100x, 1000x, etc.), DML queries are often executed within the same amount of time.
  • Redshift has a powerful graphical admin tool to monitor the ongoing queries in real time and historically.
  • Easily expandable capacity. Automatic snapshots that eliminate the need for managing backups. Simple database maintenance strategies with the VACUUM and ANALYZE commands.
  • Abundance of detailed documentation and tutorials.
Michael Romm profile photo

Cons

  • 64KB limit on row size and 1MB limit on querying
  • Increasing throughput is expensive
  • Secondary indexes are not supported
No photo available
  • there are some situations where having a column store more closely integrated as part of our platform would be better
  • AWS costs can add up
  • many other (open source) column stores have new and interesting features not (yet) available in Redshift
No photo available

Likelihood to Renew

Amazon DynamoDB7.1
Based on 13 answers
We use it for current databases and the cost is low enough to not justify transferring to a new technology.
No photo available
No score
No answers yet
No answers on this topic

Usability

No score
No answers yet
No answers on this topic
Amazon Redshift10.0
Based on 1 answer
Just very happy with the product, it fits our needs perfectly. Amazon pioneered the cloud and we have had a positive experience using RedShift. Really cool to be able to see your data housed and to be able to query and perform administrative tasks with ease.
Brendan McKenna profile photo

Alternatives Considered

Amazon DynamoDB is a strong contender for an enterprise NoSQL database. We chose Amazon DynamoDB due to:
  1. easy inclusion in our AWS architecture
  2. fast performance with no setup
  3. appropriate balance of object retention and speed compared to other databases available in AWS
Jordan Bayles profile photo
It's fast processing compared to other products and it's best for structured data analytics & data warehousing purpose.The unique columnar data storage architecture compared to other products makes it the great choice for analytics projects.
No photo available

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
  • Data loading is much faster
  • Database physical footprint got much smaller
  • No need for our own data center and hardware
No photo available

Pricing Details

Amazon DynamoDB

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

Amazon Redshift

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