OrientDB vs Cassandra Comparision

[java.tu...@gmail.com]

Hi,

We are evaluating NoSQL datastore for our project. We have short listed few among which Cassandra and OrientDB are one of the candidates. Our key requirements are...

1> Very low single read and write latency (< 5 ms) 

2> Very low NON-KEY single read and write latency (< 5 ms). In Cassandra we are allowed to denormalize and store data in multiple tables.

3> Data size in each table - 50,000M rows

4> Auto sharding/rebalancing

5> Multi-data center replication support

6> Product should be very very stable

7> Should be Apache 2 Licensed where ALL the above key features are available in the FREE/Community edition.

Can anyone help with little details around these criteria. Any pointer to benchmark data of both done together would also help.

Regards,

LP

[Luca Garulli]

Hi LP,

On 26 June 2017 at 22:14, <java.tu...@gmail.com> wrote:

Hi,

We are evaluating NoSQL datastore for our project. We have short listed few among which Cassandra and OrientDB are one of the candidates. Our key requirements are...

1> Very low single read and write latency (< 5 ms) 

This is as lookup by primary key?

 

2> Very low NON-KEY single read and write latency (< 5 ms). In Cassandra we are allowed to denormalize and store data in multiple tables.

What do you mean? Any query with filtering on secondary indexes?

 

3> Data size in each table - 50,000M rows

Do you mean 50 Billion rows per table? How many tables?

 

4> Auto sharding/rebalancing

OrientDB doesn't have auto-sharding (yet), so it's up to you to partitionate the records (usually based on hashing a key): the sharding is only manual.

 

5> Multi-data center replication support

Only in the Enterprise Edition.

 

6> Product should be very very stable

To be honest, as distributed database, Cassandra is more mature. OrientDB, instead, is much more mature as Graph Database (in comparison to DataStax DSE Graph) and much faster (see below).

 

7> Should be Apache 2 Licensed where ALL the above key features are available in the FREE/Community edition.

Multiple Data-Center is Enterprise only, all the rest is in Community Edition (=Apache2)

 

Can anyone help with little details around these criteria. Any pointer to benchmark data of both done together would also help.

This is the result of Yahoo benchmark:

OrientDB is from 200% to 300% faster in all the workloads. This is not a benchmark we created from scratch to win, but it's the famous:

https://github.com/brianfrankcooper/YCSB/wiki

Running OrientDB and Cassandra distributed. Same hw and sw configuration, of course.

Regards,

LP

Best Regards,

Luca Garulli

Founder & CEO

OrientDB LTD