1SQL | NoSQL
2 relational | non-relational
3 |
4use structured query | NoSQL databases have
5language and have a | dynamic schemas for
6predefined schema. | unstructured data.
7 |
8are vertically scalable | are horizontally scalable.
9are table based | are document, key-value,
10 | graph or wide-column stores.
11 |
12are better for multi-row| are better for unstructured
13transactions | data like documents or JSON.
1A SQL Database follows a table like structure which can have an
2unlimited number of rows and every data present inside the database
3is properly structured with Predefined Schemas, it is basically used
4to manipulate Relational Databases Management Systems.
5
6A NoSQL Database is a Distributed Database where the data is very
7unstructured with Dynamic Schema. Unlike SQL it cannot have unlimited
8rows but it follows a Standard Schema Definition and can store all
9sorts of data models with large distributed data in the form of
10key-value pairs, graph databases, documents or wide-column stores.
1/* KEY DIFFERENCE
2SQL pronounced as "S-Q-L" or as "See-Quel" is primarily called RDBMS or Relational Databases whereas NoSQL is a Non-relational or Distributed Database.
3SQL databases are table based databases whereas NoSQL databases can be document based, key-value pairs, graph databases.
4SQL databases are vertically scalable while NoSQL databases are horizontally scalable.
5SQL databases have a predefined schema whereas NoSQL databases use dynamic schema for unstructured data.
6SQL requires specialized DB hardware for better performance while NoSQL uses commodity hardware.*/
1-----------------
2key differences |
3-----------------
4SQL databases are usually RDBMS or DBMS
5(Relational DataBase Management Systems) and are table based,
6NoSQL uses unstructured data (like graphs)
7
8-----------------
9Examples |
10-----------------
11SQL Databases:
12MySQL
13SQLite
14Oracle DB
15
16NoSQL:
17MongoDB
18DynamoDB