What are differences between SQL and NoSQL databases.
Posted by Nikheel on January 2nd 2018 14:23 PM
Sql databases are mainly called as Relational databases (RDBMS). Let's see the differences between them. 1. Sql databases are mainly called as Relational databases (RDBMS) whereas NoSql databases are mainly termed as distributed databases. 2. Schema from the Sql databases is fixed or predefined, whereas NoSql databases have dynamic data structure. 3. Sql databases are considered as vertically scalable, on the other hand NoSql ones are considered as horizontally scalable. 4. While working on complex queries SQL databases are preferred over NoSql databases. 5. While working on hierarchical data storage NoSql databases are preferred over SQL databases. 6. All SQL based databases store and display data in table formats, whereas NoSql databases do this in format of document storage, Column storage and Graph storage format. 7. e.g. of SQL databases - Oracle, MySql, Sqlite. e.g. of NoSql databases - MongoDB, BigTable, Cassandra.