RDBMS vs Cassandra

1. No Joins #81
2. No Referential Integrity
1. ie Foreign key & Cascading deletes are not available
3. Denormalized
1. Can be achieved through,
1. Classic Denormalization
2. Materialized Views (Starting from Cassandra v3.0)
4. Query first Design
5. Data Storage Consideration
1. In Cassandra, a table might be partitioned across multiple nodes
2. A Query that only search for a data in a single partition(Single Node) will be more faster that searching in multiple partition(Multiple nodes) #83
6. Sorting Order
1. Is fixed in Cassandra (we cannot change the order of data using queries as we can do in RDBMS...Ex ; select * from ... ORDER BY)
2. Is determined based on Clustering Columns #84