{"id":1703,"date":"2022-07-13T01:19:47","date_gmt":"2022-07-12T19:49:47","guid":{"rendered":"https:\/\/ontoborn.com\/blog\/?p=1703"},"modified":"2022-07-13T01:21:03","modified_gmt":"2022-07-12T19:51:03","slug":"sql-vs-no-sql-databases-everything-you-need-to-know","status":"publish","type":"post","link":"https:\/\/ontoborn.com\/blog\/sql-vs-no-sql-databases-everything-you-need-to-know\/","title":{"rendered":"SQL vs NO-SQL Databases\u200a\u2014\u200aEverything you need to know"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-52.png\"><img loading=\"lazy\" decoding=\"async\" width=\"975\" height=\"510\" src=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-52.png\" alt=\"\" class=\"wp-image-1704\" srcset=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-52.png 975w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-52-300x157.png 300w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-52-768x402.png 768w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-52-574x300.png 574w\" sizes=\"(max-width: 975px) 100vw, 975px\" \/><\/a><\/figure>\n\n\n\n<p>Hello everyone. In this article, we will be looking at what is SQL and NoSQL databases and then we will continue in-depth about both these types and also discuss their benefits and use cases.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\"><a><\/a><strong>What is a SQL \/ Relational Database?<\/strong><\/h1>\n\n\n\n<p>SQL databases have been used for decades and they are also called Relational databases. Relational databases store data in a structured tabular format (using rows and columns). In this way, the data can be easily identified and retrieved. It is called relational because the relationships can be established between the tables through mapping fields.<\/p>\n\n\n\n<p>SQL stands for Structured Query Language, the language used by relational database management systems. It is a declarative language and the SQL commands can be divided into 5 categories based on their functionalities as follows<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-53.png\"><img loading=\"lazy\" decoding=\"async\" width=\"975\" height=\"579\" src=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-53.png\" alt=\"\" class=\"wp-image-1705\" srcset=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-53.png 975w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-53-300x178.png 300w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-53-768x456.png 768w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-53-505x300.png 505w\" sizes=\"(max-width: 975px) 100vw, 975px\" \/><\/a><\/figure>\n\n\n\n<ol type=\"1\"><li><em>Data Definition Language(DDL)<\/em><\/li><li><em>Data Control Language (DCL)<\/em><\/li><li><em>Data Manipulation Language (DML)<\/em><\/li><li><em>Transaction Control Language (TCL)<\/em><\/li><li><em>Data Query language (DQL)<\/em><\/li><\/ol>\n\n\n\n<p>Some of the popular relational databases are<\/p>\n\n\n\n<ul><li><em>MySQL<\/em><\/li><li><em>Oracle<\/em><\/li><li><em>PostgreSQL<\/em><\/li><li><em>Microsoft SQL Server<\/em><\/li><li><em>SQLite<\/em><\/li><li><em>MariaDB<\/em><\/li><li><em>IBM DB2<\/em><\/li><\/ul>\n\n\n\n<p><strong>ACID Properties in Relation Database<\/strong><\/p>\n\n\n\n<p>Relational Databases follow the ACID principles as follows<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-54.png\"><img loading=\"lazy\" decoding=\"async\" width=\"975\" height=\"667\" src=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-54.png\" alt=\"\" class=\"wp-image-1706\" srcset=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-54.png 975w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-54-300x205.png 300w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-54-768x525.png 768w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-54-439x300.png 439w\" sizes=\"(max-width: 975px) 100vw, 975px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>\u00a0What is a NO-SQL Database?<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-55.png\"><img loading=\"lazy\" decoding=\"async\" width=\"975\" height=\"558\" src=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-55.png\" alt=\"\" class=\"wp-image-1707\" srcset=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-55.png 975w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-55-300x172.png 300w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-55-768x440.png 768w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-55-524x300.png 524w\" sizes=\"(max-width: 975px) 100vw, 975px\" \/><\/a><\/figure>\n\n\n\n<p>NoSQL stands for Not only SQL Database and any database which is non-relational falls under NoSQL database. These databases are non-tabular and stores data in a way different than relational databases. The data models are flexible. The NoSQL databases came into existence mainly due to processing Big Data, IoT, etc. Most of the NO-SQL Databases do not follow ACID principles but they follow BASE in order to gain other benefits, like scalable and resiliency.<\/p>\n\n\n\n<p><strong>BASE Properties<\/strong><\/p>\n\n\n\n<p>NoSQL database relies on a model known as the BASE model. <strong>BASE<\/strong> (<strong>B<\/strong>asically <strong>A<\/strong>vailable, <strong>S<\/strong>oft state, <strong>E<\/strong>ventual consistency).<\/p>\n\n\n\n<p><strong>Basically Available:<\/strong> The Database is always available and guarantees the availability of the data. There will be a response to any request.<\/p>\n\n\n\n<p><strong>Soft state<\/strong>: The system state could change over time<\/p>\n\n\n\n<p><strong>Eventual consistency:<\/strong> The system will eventually become consistent once the data is synchronized across the distributed cluster<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Types of No-SQL Databases<\/strong><\/h2>\n\n\n\n<p>The No-SQL Databases can be divided into 4 types as follows<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-56.png\"><img loading=\"lazy\" decoding=\"async\" width=\"975\" height=\"600\" src=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-56.png\" alt=\"\" class=\"wp-image-1708\" srcset=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-56.png 975w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-56-300x185.png 300w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-56-768x473.png 768w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-56-488x300.png 488w\" sizes=\"(max-width: 975px) 100vw, 975px\" \/><\/a><\/figure>\n\n\n\n<ol type=\"1\"><li><strong>Key-Value Database<\/strong><\/li><\/ol>\n\n\n\n<p>Data in this type of DB is stored in key\/value pairs to handle heavy loads of data. They use a simple hash table data structure to store the data for faster storage and retrievals. The Key-Value databases are based on Amazon\u2019s Dynamo paper. The use cases for this type of DB are for storing Shopping Carts, Caching, etc.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-57.png\"><img loading=\"lazy\" decoding=\"async\" width=\"850\" height=\"535\" src=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-57.png\" alt=\"\" class=\"wp-image-1709\" srcset=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-57.png 850w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-57-300x189.png 300w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-57-768x483.png 768w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-57-477x300.png 477w\" sizes=\"(max-width: 850px) 100vw, 850px\" \/><\/a><\/figure>\n\n\n\n<p><em>Examples of Key-Value Databases: Redis, Memcached, AWS DynamoDB, Riak, etc<\/em><\/p>\n\n\n\n<p><strong>2. Document-Based Database<\/strong><\/p>\n\n\n\n<p>Document-Oriented NoSQL DB stores and retrieves data as a key-value pair but the value part is stored as a document. The document can be stored in JSON or XML formats; The value is understood by the database and can be queried. These databases can be used especially when you don\u2019t know the schema up front and it is flexible to add the columns later.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-58.png\"><img loading=\"lazy\" decoding=\"async\" width=\"975\" height=\"290\" src=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-58.png\" alt=\"\" class=\"wp-image-1710\" srcset=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-58.png 975w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-58-300x89.png 300w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-58-768x228.png 768w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-58-583x173.png 583w\" sizes=\"(max-width: 975px) 100vw, 975px\" \/><\/a><\/figure>\n\n\n\n<p>The document-based database is mainly used for CMS systems, blogging platforms, real-time analytics &amp; e-commerce applications.<\/p>\n\n\n\n<p><em>Examples of Document Based databases: MongoDB, CouchBase, RavenDB, etc<\/em><\/p>\n\n\n\n<p><strong>3. Column-Based Database<\/strong><\/p>\n\n\n\n<p>Column-Based databases work on columns and are based on BigTable paper by Google. In this database, every column is treated individually and the values of single-column databases are stored contiguously. The names and the format of the columns can vary from row to row within the same table, unlike relational databases.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-59.png\"><img loading=\"lazy\" decoding=\"async\" width=\"744\" height=\"527\" src=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-59.png\" alt=\"\" class=\"wp-image-1711\" srcset=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-59.png 744w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-59-300x213.png 300w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-59-424x300.png 424w\" sizes=\"(max-width: 744px) 100vw, 744px\" \/><\/a><\/figure>\n\n\n\n<p>The above picture demonstrates that a single row has multiple columns with each having different types. Let us take the example below to understand. Every row has different columns. The row key for 1st record is Bob and the columns are email, gender, and age. So, multiple columns exist inside a single row<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-60.png\"><img loading=\"lazy\" decoding=\"async\" width=\"975\" height=\"846\" src=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-60.png\" alt=\"\" class=\"wp-image-1712\" srcset=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-60.png 975w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-60-300x260.png 300w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-60-768x666.png 768w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-60-346x300.png 346w\" sizes=\"(max-width: 975px) 100vw, 975px\" \/><\/a><\/figure>\n\n\n\n<p>The Column Based databases deliver high performance on aggregation queries like SUM, COUNT, AVG, and MIN if the data is computed and stored in columns. These databases are very useful for data analytics, big data, data warehouses, business intelligence, CRM, etc<\/p>\n\n\n\n<p><em>Examples of Column-Based Databases: Casandra, CosmoDB, Bigtable, and HBase.<\/em><\/p>\n\n\n\n<p><strong>4. Graph-based Database<\/strong><\/p>\n\n\n\n<p>The Graph database stores the entities as well the relations amongst those entities as graphs with nodes and edges. Nodes store information about data entities and the edges store information about the relationships between the nodes. Every node and edge has a unique identifier.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-61.png\"><img loading=\"lazy\" decoding=\"async\" width=\"975\" height=\"577\" src=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-61.png\" alt=\"\" class=\"wp-image-1713\" srcset=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-61.png 975w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-61-300x178.png 300w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-61-768x454.png 768w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-61-507x300.png 507w\" sizes=\"(max-width: 975px) 100vw, 975px\" \/><\/a><\/figure>\n\n\n\n<p>A Graph database is multi-relational in nature and traversing the relationships are fast as they are already captured into the DB hence we don&#8217;t need to re-calculate every time<\/p>\n\n\n\n<p>The Graph base database makes good uses cases for social networks, logistics, and geospatial data.<\/p>\n\n\n\n<p><em>Examples of Graph-Based Databases Amazon Neptune, Polyglot, Neo4J, Infinite Graph, OrientDB, FlockDB<\/em><\/p>\n\n\n\n<h1 class=\"wp-block-heading\"><a><\/a><strong>Differences between SQL and No-SQL Database<\/strong><\/h1>\n\n\n\n<p>Having seen about SQL and No-SQL databases above, now let us compare the differences between both<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-62.png\"><img loading=\"lazy\" decoding=\"async\" width=\"975\" height=\"785\" src=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-62.png\" alt=\"\" class=\"wp-image-1714\" srcset=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-62.png 975w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-62-300x242.png 300w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-62-768x618.png 768w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-62-373x300.png 373w\" sizes=\"(max-width: 975px) 100vw, 975px\" \/><\/a><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\"><a><\/a><strong>&nbsp;<\/strong><\/h1>\n\n\n\n<h1 class=\"wp-block-heading\"><a><\/a><strong>When to use SQL vs NoSQL Database?<\/strong><\/h1>\n\n\n\n<p>The choice of the database depends on the use case. If the data is structured, then you can go for a relational database and if the data schema is not clear or confirmed, then NoSQL is a good choice. NoSQL Databases work well for articles, videos, social media content, Big data, etc as we saw above in the different types of NoSQL databases. NoSQL Databases are not a replacement for SQL DB as the functionality are different and both can coexist in the same application.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\"><a><\/a><strong>Hybrid SQL and NoSQL databases<\/strong><\/h1>\n\n\n\n<p>There is a database type called <strong>NewSQL databases<\/strong>, which is a hybrid of SQL and NoSQL databases. This is an interesting concept that combines the relational and NoSQL database methods in a single Database instance. The diagram below depicts the functionalities of SQL, NoSQL, and NewSQL database<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-63.png\"><img loading=\"lazy\" decoding=\"async\" width=\"975\" height=\"600\" src=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-63.png\" alt=\"\" class=\"wp-image-1715\" srcset=\"https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-63.png 975w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-63-300x185.png 300w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-63-768x473.png 768w, https:\/\/ontoborn.com\/blog\/wp-content\/uploads\/2022\/07\/image-63-488x300.png 488w\" sizes=\"(max-width: 975px) 100vw, 975px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>The examples of NewSQL databases<\/strong><\/h2>\n\n\n\n<ul><li>Clustrix<\/li><li>CockroachDB<\/li><li>Spanner<\/li><li>H-Store<\/li><li>HyPer<\/li><li>MemSQL<\/li><li>NuoDB<\/li><li>Hana<\/li><li>VoltDB<\/li><\/ul>\n\n\n\n<p>Nowadays, modern SQL databases incorporate a hybrid approach where you can choose between relational and NoSQL models. For example, MS SQL Server, Informix, Oracle, and PostgreSQL support the JSON data format.<\/p>\n\n\n\n<p>In this article we learnt about SQL (relational) and NoSQL (non-relational) databases. We saw the different types of NoSQL databases and then compared SQL and NoSQL databases. We went through a Hybrid database called NewSQL to conclude<\/p>\n\n\n\n<p>Hope you had good learning and thanks for reading this.<\/p>\n\n\n\n<p><strong><em><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-sitetext-color\">I work as a freelance Architect at Ontoborn, who are experts in putting together a team needed for building your product. This article was originally published on <a href=\"https:\/\/medium.com\/@dineshchandgr\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"my personal blog.\">my personal blog.<\/a><\/mark><\/em><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hello everyone. In this article, we will be looking at what is SQL and NoSQL databases and then we will continue in-depth about both these types and also discuss their benefits and use cases. What &hellip;<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_mi_skip_tracking":false,"footnotes":""},"categories":[78],"tags":[],"_links":{"self":[{"href":"https:\/\/ontoborn.com\/blog\/wp-json\/wp\/v2\/posts\/1703"}],"collection":[{"href":"https:\/\/ontoborn.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ontoborn.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ontoborn.com\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/ontoborn.com\/blog\/wp-json\/wp\/v2\/comments?post=1703"}],"version-history":[{"count":3,"href":"https:\/\/ontoborn.com\/blog\/wp-json\/wp\/v2\/posts\/1703\/revisions"}],"predecessor-version":[{"id":1719,"href":"https:\/\/ontoborn.com\/blog\/wp-json\/wp\/v2\/posts\/1703\/revisions\/1719"}],"wp:attachment":[{"href":"https:\/\/ontoborn.com\/blog\/wp-json\/wp\/v2\/media?parent=1703"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ontoborn.com\/blog\/wp-json\/wp\/v2\/categories?post=1703"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ontoborn.com\/blog\/wp-json\/wp\/v2\/tags?post=1703"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}