What users are saying about
76 Ratings
84 Ratings
76 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.9 out of 100
84 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100

Likelihood to Recommend

Cassandra

Apache Cassandra is a NoSQL database and well suited where you need highly available, linearly scalable, tunable consistency and high performance across varying workloads. It has worked well for our use cases, and I shared my experiences to use it effectively at the last Cassandra summit! http://bit.ly/1Ok56TKIt is a NoSQL database, finally you can tune it to be strongly consistent and successfully use it as such. However those are not usual patterns, as you negotiate on latency. It works well if you require that. If your use case needs strongly consistent environments with semantics of a relational database or if the use case needs a data warehouse, or if you need NoSQL with ACID transactions, Apache Cassandra may not be the optimum choice.
Rekha Joshi | TrustRadius Reviewer

DB2

DB2 is suitable for any use. The main one is certainly the creation of an online database that can be queried online through TP queries and through batch reports. It is necessary to take care of the database maintenance to allow maximum performance, for this, there are the utilities that help the system operators to do it.
Anonymous | TrustRadius Reviewer

Feature Rating Comparison

NoSQL Databases

Cassandra
8.0
DB2
Performance
Cassandra
8.5
DB2
Availability
Cassandra
8.7
DB2
Concurrency
Cassandra
7.6
DB2
Security
Cassandra
8.0
DB2
Scalability
Cassandra
9.4
DB2
Data model flexibility
Cassandra
6.7
DB2
Deployment model flexibility
Cassandra
7.0
DB2

Pros

Cassandra

  • Continuous availability: as a fully distributed database (no master nodes), we can update nodes with rolling restarts and accommodate minor outages without impacting our customer services.
  • Linear scalability: for every unit of compute that you add, you get an equivalent unit of capacity. The same application can scale from a single developer's laptop to a web-scale service with billions of rows in a table.
  • Amazing performance: if you design your data model correctly, bearing in mind the queries you need to answer, you can get answers in milliseconds.
  • Time-series data: Cassandra excels at recording, processing, and retrieving time-series data. It's a simple matter to version everything and simply record what happens, rather than going back and editing things. Then, you can compute things from the recorded history.
David Prinzing | TrustRadius Reviewer

DB2

  • DB2 maintains itself very well. The Task Scheduler component of DB2 allows for statistics gathering and reorganization of indexes and tables without user interaction or without specific knowledge of cron or Windows Task Scheduler / Scheduled jobs.
  • Its use of ASYNC, NEARSYNC, and SYNC HADR (High Availability Disaster Recovery ) models gives you a range of options for maintaining a very high uptime ratio. Failover from PRIMARY to SECONDARY becomes very easy with just a single command or windowed mouse click.
  • Task Scheduler ( DB2 9.7 and earlier ) allows for jobs to be run within other jobs, and exit and error codes can define what other jobs are run. This allows for ease of maintenance without third party softwares.
  • Tablespace usage and automatic storage help keep your data segmented while at rest, making partitioning easier.
  • Ability to run commands via CLI (Command Line Interface) or via Control Center / Data Studio ( DB2 10.x+) makes administration a breeze.
J.R. Bullington | TrustRadius Reviewer

Cons

Cassandra

  • Cassandra runs on the JVM and therefor may require a lot of GC tuning for read/write intensive applications.
  • Requires manual periodic maintenance - for example it is recommended to run a cleanup on a regular basis.
  • There are a lot of knobs and buttons to configure the system. For many cases the default configuration will be sufficient, but if its not - you will need significant ramp up on the inner workings of Cassandra in order to effectively tune it.
Anonymous | TrustRadius Reviewer

DB2

  • IBM is really behind in delivering developer tools. They pride themselves on Data Studio, but it is just frustrating.
  • Marketing. Horrible to do a Google search and get returns for a COMPLETELY different product, for z/os. Why they share the same name is beyond me. Better marketing would also increase the user base and help the product mature.
  • Slower than the competition to roll out next-generation features.
Anonymous | TrustRadius Reviewer

Likelihood to Renew

Cassandra

Cassandra 8.6
Based on 16 answers
I would recommend Cassandra DB to those who know their use case very well, as well as know how they are going to store and retrieve data. If you need a guarantee in data storage and retrieval, and a DB that can be linearly grown by adding nodes across availability zones and regions, then this is the database you should choose.
Anonymous | TrustRadius Reviewer

DB2

DB2 8.0
Based on 2 answers
Because it is required to support our business unit
Anonymous | TrustRadius Reviewer

Usability

Cassandra

Cassandra 7.0
Based on 1 answer
It’s great tool but it can be complicated when it comes administration and maintenance.
Glen Kim | TrustRadius Reviewer

DB2

DB2 5.0
Based on 1 answer
You have to be well versed in using the technology, not only from a GUI interface but from a command line interface to successfully use this software to its fullest.
J.R. Bullington | TrustRadius Reviewer

Reliability and Availability

Cassandra

No score
No answers yet
No answers on this topic

DB2

DB2 10.0
Based on 20 answers
DB2 for i is extremely stable. I've experienced system slowdowns and performance issues on badly configured systems or badly configured system accessing the DB but that's it, never had a problem caused purely by the software. Support is also pretty good.
Roberto Etcheverry | TrustRadius Reviewer

Performance

Cassandra

No score
No answers yet
No answers on this topic

DB2

DB2 9.9
Based on 20 answers
The performances are exceptional if you take care to maintain the database. It is a very powerful tool and at the same time very easy to use. In our installation, we expect a DB machine on the mainframe with access to the database through ODBC connectors directly from branch servers, with fabulous end users experience.
Anonymous | TrustRadius Reviewer

Support Rating

Cassandra

Cassandra 7.0
Based on 2 answers
Sometimes instead giving straight answer, we ‘re getting transfered to talk professional service.
Glen Kim | TrustRadius Reviewer

DB2

No score
No answers yet
No answers on this topic

Alternatives Considered

Cassandra

We evaluated MongoDB also, but don't like the single point failure possibility. The HBase coupled us too tightly to the Hadoop world while we prefer more technical flexibility. Also HBase is designed for "cold"/old historical data lake use cases and is not typically used for web and mobile applications due to its performance concern. Cassandra, by contrast, offers the availability and performance necessary for developing highly available applications. Furthermore, the Hadoop technology stack is typically deployed in a single location, while in the big international enterprise context, we demand the feasibility for deployment across countries and continents, hence finally we are favor of Cassandra
yixiang Shan | TrustRadius Reviewer

DB2

DB2 is a similar product that is most respected. Oracle might be supported in a broader context, but DB2 is superior on every platform where the choice is there. Licensing is also a factor in which DB2 is much better, which might offset any cost differences. DB2 support is also much better at all tiers.
Anonymous | TrustRadius Reviewer

Scalability

Cassandra

No score
No answers yet
No answers on this topic

DB2

DB2 9.6
Based on 10 answers
It can grow as your company grows. It also plays well with Crystal Reports and other BI software once you create an ODBC connection for the DB. It can be managed with SQL management studio so no extra software is needed for that.
Josh Rice, MBA, ACSP | TrustRadius Reviewer

Return on Investment

Cassandra

  • 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.
Anonymous | TrustRadius Reviewer

DB2

  • Positive - Very good performance as compared to other traditional DBs.
  • Positive - Transaction and query search are made easy from a DB level with good performance, also runs on top scape on AIX servers.
  • Negative - There is always room for improvement, such as Webex queries and the GUI base tool. Also the available support documentation should be improved.
Pradeep Bele | TrustRadius Reviewer

Pricing Details

Cassandra

General

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

DB2

General

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

Rating Summary

Add comparison