{"id":363,"date":"2022-06-27T08:28:20","date_gmt":"2022-06-27T07:28:20","guid":{"rendered":"http:\/\/erapiditsolutions.com\/erapidblog\/?p=363"},"modified":"2022-06-27T15:23:37","modified_gmt":"2022-06-27T14:23:37","slug":"a-comparison-between-sql-and-no-sql","status":"publish","type":"post","link":"https:\/\/erapiditsolutions.com\/erapidblog\/a-comparison-between-sql-and-no-sql\/","title":{"rendered":"A Comparison between SQL and NO-SQL"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\">SQL database-features<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">SQL- Structured Query Language is a table based structure.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL follows the ACID properties, is explained as given below:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Atomicity &#8211; The entire transaction takes place at once or doesn&#8217;t happen at all<\/li><li>consistency &#8211; The database must be consistent before and after transaction<\/li><li>Isolation &#8211; Multiple transaction occur independently without interference<\/li><li>Durability &#8211; The changes of a successfull transaction occurs even if the system failure occurs \u00a0<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">SQL is developed in the 1970s with a focus on reducing data duplication as storage was much more costly than developer time. SQL databases tend to have rigid, complex, tabular schemas and typically require expensive vertical scaling.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Examples for databases that comes under the category SQL are MySql &amp; PostgreSQL<\/strong>.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">NOSQL Features<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">NOSQL &#8211; Not Only Structured Query LanguageThe NoSQL database follows the Brewers CAP theorem (Consistency, Availability and Partition tolerance).<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Consistency &#8211; the nodes will have the same copies of a replicated data item visible for various transactions<\/li><li>Availability &#8211; each read or write request for a data item will either be processed successfully or will receive a message that the operation cannot be completed.<\/li><li>Partition tolerant &#8211; the system continues to function and upholds its consistency guarantees in spite of network partitions. Network partitions are a fact of life.<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>In CAP, the term\nconsistency refers to the consistency of the values in different copies of the\nsame data item in a replicated distributed system. <\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>In ACID, it refers to the fact that a transaction will not violate the integrity constraints specified on the database schema.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Examples for databases that comes under the category NoSQL are MongoDB and redis<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"> NoSQL (\u201cnon SQL\u201d or \u201cnot only SQL\u201d) databases were developed in the late 2000s with a focus on scaling, fast queries, allowing for frequent application changes, and making programming simpler for developers. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>One of the very strong point in NoSQL is its scalability<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Capability of a system to handle\ngrowing amount of data in the same elapsed time<\/li><li>Availability and ability of the DBMS\nadministration like schema changes and servicing like upgrades and maintenance\nwithout impacting applications and end user accessibility<\/li><li>can\nbe changed to adapt to changing workloads without impacting its accessibility,\nthereby assuring continuing availability even as modifications are made.<\/li><li>More specifically a\nscalable system can react to evolving needs with adjustable resources to serve\na changing workload without requiring downtime.<\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>SQL database-features SQL- Structured Query Language is a table based structure. SQL follows the ACID properties, is explained as given below: Atomicity &#8211; The entire transaction takes place at once or doesn&#8217;t happen at all consistency &#8211; The database must be consistent before and after transaction Isolation &#8211; Multiple transaction occur independently without interference Durability &#8230; <a title=\"A Comparison between SQL and NO-SQL\" class=\"read-more\" href=\"https:\/\/erapiditsolutions.com\/erapidblog\/a-comparison-between-sql-and-no-sql\/\" aria-label=\"Read more about A Comparison between SQL and NO-SQL\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-363","post","type-post","status-publish","format-standard","hentry","category-technical-write-ups"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>A Comparison between SQL and NO-SQL &#187; eRapidIT Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/erapiditsolutions.com\/erapidblog\/a-comparison-between-sql-and-no-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A Comparison between SQL and NO-SQL &#187; eRapidIT Blog\" \/>\n<meta property=\"og:description\" content=\"SQL database-features SQL- Structured Query Language is a table based structure. SQL follows the ACID properties, is explained as given below: Atomicity &#8211; The entire transaction takes place at once or doesn&#8217;t happen at all consistency &#8211; The database must be consistent before and after transaction Isolation &#8211; Multiple transaction occur independently without interference Durability ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/erapiditsolutions.com\/erapidblog\/a-comparison-between-sql-and-no-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"eRapidIT Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/erapidit\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/erapidit\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-27T07:28:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-27T14:23:37+00:00\" \/>\n<meta name=\"author\" content=\"erapidblog\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"erapidblog\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/erapiditsolutions.com\\\/erapidblog\\\/a-comparison-between-sql-and-no-sql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/erapiditsolutions.com\\\/erapidblog\\\/a-comparison-between-sql-and-no-sql\\\/\"},\"author\":{\"name\":\"erapidblog\",\"@id\":\"http:\\\/\\\/erapiditsolutions.com\\\/erapidblog\\\/#\\\/schema\\\/person\\\/20bf995d0197ae5f88dafa96a98d8b44\"},\"headline\":\"A Comparison between SQL and NO-SQL\",\"datePublished\":\"2022-06-27T07:28:20+00:00\",\"dateModified\":\"2022-06-27T14:23:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/erapiditsolutions.com\\\/erapidblog\\\/a-comparison-between-sql-and-no-sql\\\/\"},\"wordCount\":399,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\\\/\\\/erapiditsolutions.com\\\/erapidblog\\\/#\\\/schema\\\/person\\\/20bf995d0197ae5f88dafa96a98d8b44\"},\"articleSection\":[\"Technical Write-ups\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/erapiditsolutions.com\\\/erapidblog\\\/a-comparison-between-sql-and-no-sql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/erapiditsolutions.com\\\/erapidblog\\\/a-comparison-between-sql-and-no-sql\\\/\",\"url\":\"https:\\\/\\\/erapiditsolutions.com\\\/erapidblog\\\/a-comparison-between-sql-and-no-sql\\\/\",\"name\":\"A Comparison between SQL and NO-SQL &#187; eRapidIT Blog\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/erapiditsolutions.com\\\/erapidblog\\\/#website\"},\"datePublished\":\"2022-06-27T07:28:20+00:00\",\"dateModified\":\"2022-06-27T14:23:37+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/erapiditsolutions.com\\\/erapidblog\\\/a-comparison-between-sql-and-no-sql\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/erapiditsolutions.com\\\/erapidblog\\\/a-comparison-between-sql-and-no-sql\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/erapiditsolutions.com\\\/erapidblog\\\/a-comparison-between-sql-and-no-sql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/erapiditsolutions.com\\\/erapidblog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"A Comparison between SQL and NO-SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/erapiditsolutions.com\\\/erapidblog\\\/#website\",\"url\":\"http:\\\/\\\/erapiditsolutions.com\\\/erapidblog\\\/\",\"name\":\"eRapidIT Blog\",\"description\":\"A blog from an IT Consultant\",\"publisher\":{\"@id\":\"http:\\\/\\\/erapiditsolutions.com\\\/erapidblog\\\/#\\\/schema\\\/person\\\/20bf995d0197ae5f88dafa96a98d8b44\"},\"alternateName\":\"erapiditblog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\\\/\\\/erapiditsolutions.com\\\/erapidblog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"http:\\\/\\\/erapiditsolutions.com\\\/erapidblog\\\/#\\\/schema\\\/person\\\/20bf995d0197ae5f88dafa96a98d8b44\",\"name\":\"erapidblog\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"http:\\\/\\\/erapiditsolutions.com\\\/erapidblog\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/cropped-cropped-cropped-logo_erapidit.jpg\",\"url\":\"http:\\\/\\\/erapiditsolutions.com\\\/erapidblog\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/cropped-cropped-cropped-logo_erapidit.jpg\",\"contentUrl\":\"http:\\\/\\\/erapiditsolutions.com\\\/erapidblog\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/cropped-cropped-cropped-logo_erapidit.jpg\",\"width\":240,\"height\":48,\"caption\":\"erapidblog\"},\"logo\":{\"@id\":\"http:\\\/\\\/erapiditsolutions.com\\\/erapidblog\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/cropped-cropped-cropped-logo_erapidit.jpg\"},\"description\":\"eRapidiT has been providing IT professional services and marketing tactics to various small business industries for the last 6 years. Our primary aim is in the quality of the services and we are confident in our work style and ensure our responsibility is completed only when our works starts working for the client. We support each and every step when the client takes new decisions on their paths.\",\"sameAs\":[\"http:\\\/\\\/www.erapiditsolutions.com\\\/\",\"https:\\\/\\\/www.facebook.com\\\/erapidit\",\"https:\\\/\\\/www.instagram.com\\\/erapidit\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/erapidit\\\/?viewAsMember=true\"],\"url\":\"https:\\\/\\\/erapiditsolutions.com\\\/erapidblog\\\/author\\\/erapidblog\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"A Comparison between SQL and NO-SQL &#187; eRapidIT Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/erapiditsolutions.com\/erapidblog\/a-comparison-between-sql-and-no-sql\/","og_locale":"en_GB","og_type":"article","og_title":"A Comparison between SQL and NO-SQL &#187; eRapidIT Blog","og_description":"SQL database-features SQL- Structured Query Language is a table based structure. SQL follows the ACID properties, is explained as given below: Atomicity &#8211; The entire transaction takes place at once or doesn&#8217;t happen at all consistency &#8211; The database must be consistent before and after transaction Isolation &#8211; Multiple transaction occur independently without interference Durability ... Read more","og_url":"https:\/\/erapiditsolutions.com\/erapidblog\/a-comparison-between-sql-and-no-sql\/","og_site_name":"eRapidIT Blog","article_publisher":"https:\/\/www.facebook.com\/erapidit","article_author":"https:\/\/www.facebook.com\/erapidit","article_published_time":"2022-06-27T07:28:20+00:00","article_modified_time":"2022-06-27T14:23:37+00:00","author":"erapidblog","twitter_card":"summary_large_image","twitter_misc":{"Written by":"erapidblog","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/erapiditsolutions.com\/erapidblog\/a-comparison-between-sql-and-no-sql\/#article","isPartOf":{"@id":"https:\/\/erapiditsolutions.com\/erapidblog\/a-comparison-between-sql-and-no-sql\/"},"author":{"name":"erapidblog","@id":"http:\/\/erapiditsolutions.com\/erapidblog\/#\/schema\/person\/20bf995d0197ae5f88dafa96a98d8b44"},"headline":"A Comparison between SQL and NO-SQL","datePublished":"2022-06-27T07:28:20+00:00","dateModified":"2022-06-27T14:23:37+00:00","mainEntityOfPage":{"@id":"https:\/\/erapiditsolutions.com\/erapidblog\/a-comparison-between-sql-and-no-sql\/"},"wordCount":399,"commentCount":0,"publisher":{"@id":"http:\/\/erapiditsolutions.com\/erapidblog\/#\/schema\/person\/20bf995d0197ae5f88dafa96a98d8b44"},"articleSection":["Technical Write-ups"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/erapiditsolutions.com\/erapidblog\/a-comparison-between-sql-and-no-sql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/erapiditsolutions.com\/erapidblog\/a-comparison-between-sql-and-no-sql\/","url":"https:\/\/erapiditsolutions.com\/erapidblog\/a-comparison-between-sql-and-no-sql\/","name":"A Comparison between SQL and NO-SQL &#187; eRapidIT Blog","isPartOf":{"@id":"http:\/\/erapiditsolutions.com\/erapidblog\/#website"},"datePublished":"2022-06-27T07:28:20+00:00","dateModified":"2022-06-27T14:23:37+00:00","breadcrumb":{"@id":"https:\/\/erapiditsolutions.com\/erapidblog\/a-comparison-between-sql-and-no-sql\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/erapiditsolutions.com\/erapidblog\/a-comparison-between-sql-and-no-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/erapiditsolutions.com\/erapidblog\/a-comparison-between-sql-and-no-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/erapiditsolutions.com\/erapidblog\/"},{"@type":"ListItem","position":2,"name":"A Comparison between SQL and NO-SQL"}]},{"@type":"WebSite","@id":"http:\/\/erapiditsolutions.com\/erapidblog\/#website","url":"http:\/\/erapiditsolutions.com\/erapidblog\/","name":"eRapidIT Blog","description":"A blog from an IT Consultant","publisher":{"@id":"http:\/\/erapiditsolutions.com\/erapidblog\/#\/schema\/person\/20bf995d0197ae5f88dafa96a98d8b44"},"alternateName":"erapiditblog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/erapiditsolutions.com\/erapidblog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":["Person","Organization"],"@id":"http:\/\/erapiditsolutions.com\/erapidblog\/#\/schema\/person\/20bf995d0197ae5f88dafa96a98d8b44","name":"erapidblog","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"http:\/\/erapiditsolutions.com\/erapidblog\/wp-content\/uploads\/2021\/07\/cropped-cropped-cropped-logo_erapidit.jpg","url":"http:\/\/erapiditsolutions.com\/erapidblog\/wp-content\/uploads\/2021\/07\/cropped-cropped-cropped-logo_erapidit.jpg","contentUrl":"http:\/\/erapiditsolutions.com\/erapidblog\/wp-content\/uploads\/2021\/07\/cropped-cropped-cropped-logo_erapidit.jpg","width":240,"height":48,"caption":"erapidblog"},"logo":{"@id":"http:\/\/erapiditsolutions.com\/erapidblog\/wp-content\/uploads\/2021\/07\/cropped-cropped-cropped-logo_erapidit.jpg"},"description":"eRapidiT has been providing IT professional services and marketing tactics to various small business industries for the last 6 years. Our primary aim is in the quality of the services and we are confident in our work style and ensure our responsibility is completed only when our works starts working for the client. We support each and every step when the client takes new decisions on their paths.","sameAs":["http:\/\/www.erapiditsolutions.com\/","https:\/\/www.facebook.com\/erapidit","https:\/\/www.instagram.com\/erapidit\/","https:\/\/www.linkedin.com\/company\/erapidit\/?viewAsMember=true"],"url":"https:\/\/erapiditsolutions.com\/erapidblog\/author\/erapidblog\/"}]}},"_links":{"self":[{"href":"https:\/\/erapiditsolutions.com\/erapidblog\/wp-json\/wp\/v2\/posts\/363","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/erapiditsolutions.com\/erapidblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/erapiditsolutions.com\/erapidblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/erapiditsolutions.com\/erapidblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/erapiditsolutions.com\/erapidblog\/wp-json\/wp\/v2\/comments?post=363"}],"version-history":[{"count":3,"href":"https:\/\/erapiditsolutions.com\/erapidblog\/wp-json\/wp\/v2\/posts\/363\/revisions"}],"predecessor-version":[{"id":366,"href":"https:\/\/erapiditsolutions.com\/erapidblog\/wp-json\/wp\/v2\/posts\/363\/revisions\/366"}],"wp:attachment":[{"href":"https:\/\/erapiditsolutions.com\/erapidblog\/wp-json\/wp\/v2\/media?parent=363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erapiditsolutions.com\/erapidblog\/wp-json\/wp\/v2\/categories?post=363"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erapiditsolutions.com\/erapidblog\/wp-json\/wp\/v2\/tags?post=363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}