|
SQL(Structured query language) |
NoSQL |
|
Supported databases are Relational Databases(RDBMS) |
Supported databases are Non-Relational or distributed Databases EX: MongoDB, Cassandra, and Amazon DynamoDB |
|
SQL databases represent data in the form of a table which consist of row and column |
NoSQL databases represent data as document-based, JSON, key-value pair |
|
SQL databases have a predefined schema, i.e., we define a schema before data insert into the system. We can’t change the schema. This is inflexibility |
NoSQL databases have a dynamic schema, we can insert data without predefined schema, and we can make changes easily on the schema. |
|
We can increase the load on a single server to handle more traffic |
We can increase more servers to handle more traffic |
|
We can write complex queries |
We can’t write complex queries |
|
SQL databases follow ACID properties (Atomicity, Consistency, Isolation, and Durability) |
NoSQL database follows the Brewers CAP theorem (Consistency, Availability, and Partition tolerance) |
No comments:
Post a Comment