difference between sql and nosql with example
Example 1: difference between nosql and sql
SQL | NoSQL
relational | non-relational
|
use structured query | NoSQL databases have
language and have a | dynamic schemas for
predefined schema. | unstructured data.
|
are vertically scalable | are horizontally scalable.
are table based | are document, key-value,
| graph or wide-column stores.
|
are better for multi-row| are better for unstructured
transactions | data like documents or JSON.
Example 2: sql vs nosql
key differences |
SQL databases are usually RDBMS or DBMS
(Relational DataBase Management Systems) and are table based,
NoSQL uses unstructured data (like graphs)
Examples |
SQL Databases:
MySQL
SQLite
Oracle DB
NoSQL:
MongoDB
DynamoDB