SQL databases have been around for decades and most of us are probably already very familiar with relational databases. Let's learn some significant differences between SQL and NoSQL databases:
|
Properties |
SQL Databases |
NoSQL Databases |
|
Data model |
In SQL databases, the relational model normalizes data into tables containing rows and columns. A schema includes tables, number of columns, relationships between tables, index, and other database elements. |
NoSQL databases do not enforce a schema. A partition key is commonly used to retrieve values from column sets. It stores semi-structured data such as JSON, XML, or other documents such as data catalogs and file indexes. |
|
Transaction |
SQL-based traditional RDBMS support and are compliant with the transactional data properties of ACID. |
To achieve horizontal scaling and data model flexibility, NoSQL databases may trade some ACID properties of traditional RDBMSes. |
|
Performance |
SQL-based... |