Almost everyone in tech field will have knowledge of SQL database and have a good knowledge on either MsSQL, Oracle, MySQL or any other database.
Technology changes rapidly and now the new buzzword in the database world is NoSQL. NoSQL database is getting widely adopted to solve various business problems.
Difference between SQL and NoSQL
|SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.||NoSQL database provides a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases.|
|SQL databases are primarily called as Relational Databases (RDBMS).||NoSQL databases are categorized as Non-relational or distributed database system.|
|It is table based.||NoSQL is document based, key-value pairs, graph databases or wide-column stores.|
|SQL databases have predefined schema.||NoSQL databases have dynamic schema for unstructured data.|
|SQL databases are vertically scalable.||NoSQL databases are horizontally scalable.|
|SQL databases are scaled by boosting of the hardware.||NoSQL databases are scaled by adding the database servers in the pool of resources to reduce the load.|
|SQL databases emphasizes on ACID properties.||NoSQL database follows the Brewers CAP theorem ( Consistency, Availability and Partition tolerance)|
|SQL databases as either open-source or close-sourced from commercial vendors.||NoSQL databases can be classified on the basis of way of storing data as graph databases, key-value store databases, document store databases, column store database and XML databases.|
|Excellent support are available for all SQL databases from their vendors. There are many other independent consultations who can help you with the database for very production side.||For few NoSQL databases, you still have to rely on community support and only limited outside experts are available for you to setup and deploy your production side deployments.|
|These databases are best fit for heavy transaction type application as it is more stable and the atomicity as well as integrity of the data.||NoSQL databases transaction purpose it is still not comparable and stable enough in high load and for complex transaction application.|
|SQL databases display data in form of tables so it is known as table-based database.||NoSQL databases display data as collection of key-value pair, documents, graph databases or wide-column stores.|
|SQL databases don’t have Auto elasticity||NoSQL databases have an Auto elasticity.(Automatically spreads your data onto multiple servers without requiring application assistance. Servers can be added or removed from the data layer without application downtime).|
|MySQL, Oracle, Sqlite, PostgreSQL and MS-SQL etc. are the example of SQL database.||MongoDB, BigTable, Redis, RavenDB, Cassandra, Hbase, Neo4j, CouchDB etc. are the example of NoSQL database.|