What users are saying about

Amazon DynamoDB

Top Rated
52 Ratings

Amazon Redshift

88 Ratings

Amazon DynamoDB

Top Rated
52 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.2 out of 101

Amazon Redshift

88 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

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

Amazon Redshift

If you want an easy way to get started with a column store, spin one up on AWS and see if it fits your use case. AWS is a reasonably cheap way to adopt new technologies. Then after a while, you'll be in a better position to decide whether to commit more to AWS or choose from comparable technologies available.
No photo available

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

  • Speed of data inserts.
  • Quick setup of tables and integration into code.
  • Automated system management
No photo available
  • AWS infrastructure and support simplifies maintenance and administration
  • familiarity with PostgreSQL makes adopting Redshift as a column store easier
  • columnar data store allows for high performance queries on large volumes of data
No photo available

Cons

  • Not as flexible as something like Firebase
  • Has a learning curve
  • Ties you into AWS infrastructure
Richard Rout profile photo
  • There is no support for data de-duplication; meaning this has to be either accounted for upstream, or you'll have to build your own services to de-dupe your data.
  • It's strength is housing data, not necessarily data insertions. While it has an SQL-like interface, it shouldn't be approached the same as a typical relational database.
  • Permissions can be a pain... dovetailing on my previous "con" , in some instances it's easier to drop/rebuild a table than try to navigate incremental updates/insertions, but retaining user-permissions is a pain-point.
Kyle Reichelt profile photo

Likelihood to Renew

Amazon DynamoDB6.9
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

Alternatives Considered

Main advantage of DynamoDB is Amazon's offering as SaaS. This removes the need for managing the database. DynamoDB is well suited for querying simple and flat JSON objects. Compared to PostgresSQL, I would pick Postgres over Dynamo considering that Postgres is very mature and has robust support for SQL and NoSQL data. Best part about Postgres is its offered in Amazon RDS, which makes setting up a new instances as easy as a DynamoDB. Postgres is also an open source tool and has proven legacy in support.MongoDB offers great support for querying nested data structures and blob data. MongoDB also has a mature querying language. Only caveat with Mongo is it requires manual setup on an EC2 instance that causes developer overhead in setting up and managing the instance.
Anudeep Palanki profile photo
  1. Compared to Oracle Data Warehouse, Redshift is a better data warehouse. However, this comes at a cost of advanced functionality and the ability to do OLTP style processing. What you gain is faster querying time and better scalability.
  2. Compared to MySQL, you gain a WHOLE lot. MySQL is terrible for data warehousing and is still gaining features that other databases have had for years (ie. hash joins).
  3. Compared to Teradata, Redshift is a far cheaper option. This comes at the expense of functionality like partitioning and indexing. For the money though, Redshift is still far better since I personally believe you get much more bang for your buck.
Seth Goldberg profile photo

Return on Investment

  • Since the Amazon manages the instance, the amount of time a developer needs to spend configuring the database is less. For comparison, if we were to manage the same instance manually, we need to set up EC2 instance, install the DB, setup backup scripts, track backup failures, which is a great overhead for the dev. Using DynamoDB this overhead is reduced and hence having a great ROI.
  • Great documentation and easy setup makes an easy learning curve to transition to DynamoDB. Only caveat is as with any database, the data structure should be thoroughly analyzed for types of querying because there are limitations with the DynamoDB API.
  • Ties very well with rest of the Amazon eco system. Having rest of the applications in Amazon allows managing the application security a breeze.
Anudeep Palanki profile photo
  • To be honest, we haven't yet seen the return, as we aren't yet operating at scale. So we haven't seen the positive impacts, only the added engineering overhead of dealing with Redshift's eccentricities.
Kyle Reichelt 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

Amazon Redshift

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