What is the difference between Cassandra vs Oracle Coherence?

oracle cassandra oracle-coherence
No Sql Wisher picture No Sql Wisher · Sep 23, 2009 · Viewed 10.1k times · Source

Assume that Oracle Coherence is free :)

Which one do you prefer?

What are the architectural and feature capability differences between Oracle Coherence(Tangosol) and Cassandra?

Best Regards

Answer

Andrew Pym picture Andrew Pym · Oct 18, 2009

Oracle Coherence is a pure in-memory cache which can be distributed across nodes. Depending on its configuration it can have strong consistency, or eventual consistency for inserts and updates. Coherence is object based - consistent data model. Since you buy Coherence from oracle - you can get commercial support, from oracle.

Cassandra is a bigtable data store that is distributed across nodes. No single point of failure. It uses some caching to improve performance before committing the data to disk in its implementation of bigTable. Cassandra requires some structure in its tuple (key/value/timestamp) but otherwise can support flexible data structures.

Preferences should be determined by your use case. They are both pretty cool in their own right.

You might also want to check out - Terracotta in the in-memory space - CouchDB and HBase as other players in the big table space.

Related questions

Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More
How do I limit the number of rows returned by an Oracle query after ordering?

Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this: select * from sometable order by name limit 20,10 to get the 21st to the 30th rows (skip the …

Read More
ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More