SQL | NoSQL |
---|---|
called as Relational Databases (RDBMS) | called as non-relational or distributed database. |
SQL databases are table based databases | NoSQL databases are document based, key-value pairs, graph databases or wide-column stores |
have predefined schema | have dynamic schema for unstructured data. |
vertically scalable | horizontally scalable |
uses SQL ( structured query language ) for defining and manipulating the data | queries are focused on collection of documents. |
best fit for vertically data storage
MySQL Community Edition
its better for the hierarchical data storage as it follows the key-value pair way of storing data similar to JSON data. NoSQL database are highly preferred for large data set (i.e for big data). Hbase is an example for this purpose.
Hbase
NoSQL database
SQL databases are vertically scalable. You can manage increasing load by increasing the CPU, RAM, SSD, etc, on a single server. On the other hand, NoSQL databases are horizontally scalable. You can just add few more servers easily in your NoSQL database infrastructure to handle the large traffic
Structured Query Language
is a type of database that stores and provides access to data points that are related to one another.
in general data is structured as a tables
its structure described in a formal language supported by the database management system (DBMS).
database are primarily called as non-relational or distributed database and its document based, key-value pairs, graph databases or wide-column stores
its store the data in documents
collections have a set of documents
MongoDB
SQL databases are best fit for heavy duty transactional type applications, as it is more stable and promises the atomicity as well as integrity of the data. While you can use NoSQL for transactions purpose, it is still not comparable and sable enough in high load and for complex transactional applications.