There are two types of database systems are implemented Relational and NoSQL. There are lot of differences in these systems.
- Relational Database provide store of related tables while NoSQL stores the unstructured or semi-structured data in the form of key/value or JSON documents.
- Relational DB has fixed schema while NoSQL DB has dynamic schema.
- Relational DB use SQL (Structured Query Language) to manage the data, NoSQL DB have many models for managing and accessing the data.
- Relational Tables provide ACID guarantees but NoSQL does not provide ACID guarantees beyond the scope of single DB partition.
- Relational DBs are mature, proven and widely used where as NoSQL is high performance database with ease-of-use, resilience, scalability and availability characteristics.
