What users are saying about
Top Rated
54 Ratings
Top Rated
63 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
Top Rated
63 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

Add comparison

Likelihood to Recommend

Amazon DynamoDB

If you start with Amazon DynamoDB, you are over optimizing for the future. In my opinion, use Amazon DynamoDB only when SQL can not handle the load of your application.
No photo available

Cassandra

For the scenarios which need ACID support, maybe Cassandra is not the best, but for an insert only (time series based) transaction case and requirements to cope with the unpredictable data model/structure changes of the future, then Cassandra is one of the best options. If you only use the open source version of Cassandra, then without Solr integrated, you need to know your search query before you create the table, if that's not possible then Cassandra or other NoSQL DB might not your right choice.
yixiang Shan profile photo

Feature Rating Comparison

NoSQL Databases

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

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
  • Cassandra can preform read/writes very quick
  • Nodes in a ring will keep up to date by sharding information to each other
  • Cassandra is well suited for scalable application needing keyspace storage
No photo available

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
  • Cassandra's query language is clunky, which is likely due to the nature of NoSQL.
  • Lacking the ability to relate data between sets makes querying harder, but this again is the nature of NoSQL.
No photo available

Likelihood to Renew

Amazon DynamoDB7.1
Based on 13 answers
There are many factors that will make us renew Amazon DynamoDB. Firstly we have designed our existing application based on DynanoDB and secondly we will to continue to avoid hosting responsibility of another database. Our REST API deal with JSON object hence leads us to an ease of pushing to DynamoDB with less modification.
No photo available
Cassandra8.0
Based on 11 answers
I would give Cassandra a higher rating only if managing a cluster becomes easier. Currently we need a team of at least 2-3 people to manage a 10+ node cluster. The cluster needs a lot of maintenance, cleaning up, monitoring and basically demands much attention. We would basically need a dedicated resource just for managing a Cassandra cluster. If more of these simple tasks get automated we can slim down a team to manage a cluster
Abdel Kamel profile photo

Alternatives Considered

While evaluating Cassandra, PostgreSQL, MongoDB and DynamoDB we found Cassandra and DynamoDB being well suited for us. At the same time we didn't have the luxury of large team or devops so it came down to Amazon DynamoDB. As a small team we are glad to go forward with this product since we save lot of time in maintaining it.
No photo available
These are the features which makes Cassandra different from others:
  • Cassandra is a distributed datastore, with a built-in coordinator. This means that requests are intelligently forwarded to the correct node.
  • It is generally very fast, and especially shines with write heavy workflows.
  • It scales linearly. If you double the nodes, you’ll double your throughput.
  • Embraces eventual consistency.
  • Masterless replication across data centers means that your data is always accessible.
No photo available

Return on Investment

  • For our small team, it has been great in aspect to cost as we save time of operations
  • This provided us fast read and write for simple queries
  • When we have complex logic and queries, we are unable to use it
No photo available
  • I have no experience with this but from the blogs and news what I believe is that in businesses where there is high demand for scalability, Cassandra is a good choice to go for.
  • Since it works on CQL, it is quite familiar with SQL in understanding therefore it does not prevent a new employee to start in learning and having the Cassandra experience at an industrial level.
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

Cassandra

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