Share & learn

Through Innovative Digital Library

What are differences between SQL and NoSQL databases.

Provide 7 basic differences between SQL and NoSQL databases.
 



Answers

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.

Answer Question

Your email address will not be published. Required fields are marked *

  • Minimum 20 character
QS7B

related questions

Most liked questions

Most answered questions

Login
QS7B Refresh
Register
QS7B Refresh
Forgot password
Ask a Question
Minimum 20 character
Minimum 20 character
Reply
Minimum 20 character
QS7B Refresh