Overall Satisfaction with Cassandra
Cassandra is a NoSQL database which is used to store a large amount of data quickly. It has a very fast write speed, allowing a large volume of data storage within a small amount of time. It is tunable and can be used to store data. It is more suitable for storing flat data rather than relational data.
- Write speed. Cassandra is very fast while writing data due to its unique architecture.
- Tunable consistency - During data replication, consistency can be tuned for a particular data set to be available during an outage.
- CQL - cassandra query language is a subset of SQL and eases the transition from a more traditional database.
- Aggregation functions are not very efficient.
- Ad-hoc queries do not perform well. Queries which were visualized while designing the databases only perform well.
- Performance is unpredictable.
- Low learning curve
- Scalable with high performance
- highly fault tolerant during outage
Cassandra has its own use case. It performs very well as a data store. Data can be written to it at a high rate. It cannot be compared to traditional RDBMS like Oracle, because they all have their own usage. Even MongoDB, which is somewhat similar, cannot be stacked up against Cassandra since it again has its own advantages.