SQL vs NoSQL

gistfile1.txt

---
| Category               | CASSANDRA                                                                                                            | RDBMS                                                                                                                                          |
| ---------------------- | -------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------- |
| General                | Cassandra is a high performance and highly scalable distributed NoSQL (columnar and K-V) database management system. | RDBMS is a Database management system or software which is designed for relational databases (Oracle, MSSQL, PostgreSQL...).                   |
| Data structure support | It deals with unstructured data.                                                                                     | It deals with structured data.                                                                                                                 |
| Schema support         | It has a flexible schema (schema-less or semi-schema).                                                               | It has fixed schema (schema enforcing).                                                                                                        |
| HA architecture        | Cassandra has peer-to-peer architecture with no single point of failure. Scaling is linear by add nodes              | RDBMS has master-slave core architecture means a single point of failure. Scale up is favor for WRITE operation, READ is optionally scaled out |
| Volume of data support | Cassandra handles high volume incoming data velocity.                                                                | RDBMS handles moderate incoming data velocity.                                                                                                 |
| Transaction support    | It supports simple transactions (non ACID).                                                                          | It supports complex and nested transactions (ACID) on multi rows level.                                                                        |
| Deployment model       | Cassandra follows decentralized deployments.                                                                         | RDBMS follows centralized deployments.                                                                                                         |
| Write path             | In Cassandra data written in many locations.                                                                         | In RDBMS mainly data are written in one location (master only).                                                                                |
| Relationship support   | Not supported (relationships are only represented using collections.). Data model is de-normalized.                  | In RDBMS relationships are represented using keys and join etc.                                                                                |