difference between relational database and nosql code 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
Example 3: difference between relational and non relational database
Relational Database =
-Tables are structured related to each other
-Each specific type of domain data is strored
it's own table
Non-Relational Database =
-There is no relation at all between tables
-Mostly key+value pair : like jSon