When comparing Cassandra vs Infobright, the Slant community recommends Cassandra for most people. In the question“What are the best column-oriented database management systems?” Cassandra is ranked 1st while Infobright is ranked 2nd. The most important reason people chose Cassandra is:
Cassandra is very scalable and achieves the highest throughput for the maximum number of nodes compared to other alternatives. Unfortunately this also brings rather high write and read latencies.
Ranked in these QuestionsQuestion Ranking
Pros
Pro Highly scalable
Cassandra is very scalable and achieves the highest throughput for the maximum number of nodes compared to other alternatives. Unfortunately this also brings rather high write and read latencies.
Pro Familiar to developers used to SQL
The query language that Cassandra uses (CQL) is similar to SQL even though it's a NoSQL database.
Cons
Con Not for newbies
If your dataset is in order of gigabytes then maybe consider a toy database, not a serious one like Cassandra.
Con No JOINS
Cassandra has no support for JOINS.