{"id":38475,"date":"2016-11-23T09:28:45","date_gmt":"2016-11-23T15:28:45","guid":{"rendered":"http:\/\/alfonsoirai.wordpress.com\/?p=275"},"modified":"2016-11-23T09:28:45","modified_gmt":"2016-11-23T15:28:45","slug":"nosql-vs-sql","status":"publish","type":"post","link":"https:\/\/kenscourses.com\/tc1019fall2016\/syndicated\/nosql-vs-sql\/","title":{"rendered":"NoSQL vs SQL"},"content":{"rendered":"<p>SQL Server and relational databases (RDBMS) have been the go-to databases for over 20 years. However, the increased need to process higher volumes, velocities, and varieties of data at a rapid rate has altered the nature of data storage needs for application developers. In order to enable this scenario, NoSQL databases that enable storing unstructured and heterogeneous data at scale have gained in popularity. For most developers, relational databases are the default or go-to option because a table structure is easy to understand and is familiar, but there are many reasons to explore beyond relational databases.<\/p>\n<h3>Relational database advantages<\/h3>\n<ul>\n<li>Its use is more adapted and the profiles that know it are mainstream, and therefore less expensive.<\/li>\n<li>Due to the amount of time that they\u2019ve been on the market, these tools have better support, product suites and add-ons to manage these databases.<\/li>\n<li>The atomicity of operations on the database. This means that on these databases either the entire operation is done or it\u2019s not done at all, using the famous \u2018rollback\u2019 technique.<\/li>\n<li>The data must comply with integrity requirements both in data type and compatibility.<\/li>\n<\/ul>\n<h3>Disadvantages in relational databases<\/h3>\n<ul>\n<li>The atomicity of the operations plays a crucial part in the database\u2019s performance.<\/li>\n<li>Scalability, even though it\u2019s usually tested in productive environments, it\u2019s usually lower than NoSQL databases.<\/li>\n<\/ul>\n<h3>Advantages of a NoSQL database<\/h3>\n<ul>\n<li>the scalability and its decentralized style. It supports distributed structures.<\/li>\n<li>They\u2019re usually much more open and flexible as databases. They allow adapting to the needs of a project in a much easier way than entity related models.<\/li>\n<li>Changes in the schemes can be done without having to stop the database.<\/li>\n<li>Horizontal scaling: they\u2019re capable of growing in device number, instead of having to reside in one large device.<\/li>\n<li>They can be run on low-resource devices.<\/li>\n<li>Query optimization on databases <div class=\"post-limited-image\"><img alt=\"\" border=\"0\" src=\"http:\/\/feeds.wordpress.com\/1.0\/comments\/alfonsoirai.wordpress.com\/275\/\" \/><\/div>\n<div class=\"post-limited-image\"><img alt=\"\" border=\"0\" src=\"https:\/\/pixel.wp.com\/b.gif?host=alfonsoirai.wordpress.com&#038;blog=98719662&%23038;post=275&%23038;subd=alfonsoirai&%23038;ref=&%23038;feed=1\" width=\"1\" height=\"1\" \/><\/div><!--more--> for large amounts of data.<\/li>\n<\/ul>\n<h3>Disadvantages of NoSQL databases<\/h3>\n<ul>\n<li>Not all NoSQL databases contemplate the atomicity of instructions and the integrity of the data. They withstand what\u2019s know as eventual consistence.<\/li>\n<li>Compatibility issues with SQL instructions. New databases use their own characteristics in the query language and they\u2019re not yet 100% compatible with the SQL used in relational databases. Support for work query issues in a NoSQL database is more complicated.<\/li>\n<li>Lack of standardizing. There are many NoSQL databases and there is still no standard like the ones that exist in relational databases. An uncertain future is predicted for these databases.<\/li>\n<li>Cross-platform support. There are still many improvements to be made on some systems so that they can run on non-Linux operating systems.<\/li>\n<li>They usually have not-really-useful management tools or console access.<\/li>\n<\/ul>\n<p>At this point it\u2019s very important to insist on the fact that even though it may look like a good time to move over to a NoSQL database, we must keep in mind before taking that decision if the characteristics of our database rather needs a NoSQL or a relational database.<\/p>\n<div class=\"jetpack-video-wrapper\"><iframe class='youtube-player' type='text\/html' width='1000' height='593' src='https:\/\/www.youtube.com\/embed\/rRoy6I4gKWU?version=3&#038;rel=1&%23038;fs=1&%23038;autohide=2&%23038;showsearch=0&%23038;showinfo=1&%23038;iv_load_policy=1&%23038;wmode=transparent' allowfullscreen='true' style='border:0;'><\/iframe><\/div>\n<p>&nbsp;<\/p>\n<p>References<\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/documentdb\/documentdb-nosql-vs-sql\" rel=\"nofollow\">https:\/\/docs.microsoft.com\/en-us\/azure\/documentdb\/documentdb-nosql-vs-sql<\/a><\/p>\n<blockquote class=\"wp-embedded-content\"><p><a href=\"https:\/\/blog.pandorafms.org\/nosql-vs-sql-key-differences\/\">NOSQL vs SQL. Key differences and when to choose each<\/a><\/p><\/blockquote>\n<p><script type='text\/javascript'><!--\/\/--><![CDATA[\/\/><!--\t\t!function(a,b){\"use strict\";function c(){if(!e){e=!0;var a,c,d,f,g=-1!==navigator.appVersion.indexOf(\"MSIE 10\"),h=!!navigator.userAgent.match(\/Trident.*rv:11.\/),i=b.querySelectorAll(\"iframe.wp-embedded-content\");for(c=0;c<i.length;c++)if(d=i[c],!d.getAttribute(\"data-secret\")){if(f=Math.random().toString(36).substr(2,10),d.src+=\"#?secret=\"+f,d.setAttribute(\"data-secret\",f),g||h)a=d.cloneNode(!0),a.removeAttribute(\"security\"),d.parentNode.replaceChild(a,d)}else;}}var d=!1,e=!1;if(b.querySelector)if(a.addEventListener)d=!0;if(a.wp=a.wp||{},!a.wp.receiveEmbedMessage)if(a.wp.receiveEmbedMessage=function(c){var d=c.data;if(d.secret||d.message||d.value)if(!\/[^a-zA-Z0-9]\/.test(d.secret)){var e,f,g,h,i,j=b.querySelectorAll('iframe[data-secret=\"'+d.secret+'\"]'),k=b.querySelectorAll('blockquote[data-secret=\"'+d.secret+'\"]');for(e=0;e<k.length;e++)k[e].style.display=\"none\";for(e=0;e<j.length;e++)if(f=j[e],c.source===f.contentWindow){if(f.removeAttribute(\"style\"),\"height\"===d.message){if(g=parseInt(d.value,10),g>1e3)g=1e3;else if(200>~~g)g=200;f.height=g}if(\"link\"===d.message)if(h=b.createElement(\"a\"),i=b.createElement(\"a\"),h.href=f.getAttribute(\"src\"),i.href=d.value,i.host===h.host)if(b.activeElement===f)a.top.location.href=d.value}else;}},d)a.addEventListener(\"message\",a.wp.receiveEmbedMessage,!1),b.addEventListener(\"DOMContentLoaded\",c,!1),a.addEventListener(\"load\",c,!1)}(window,document);\/\/--><!]]&gt;<\/script><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/blog.pandorafms.org\/nosql-vs-sql-key-differences\/embed\/\" width=\"600\" height=\"338\" title=\"&#8220;NOSQL vs SQL. Key differences and when to choose each&#8221; &#8212; \" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><\/p><br \/>  <a rel=\"nofollow\" href=\"http:\/\/feeds.wordpress.com\/1.0\/gocomments\/alfonsoirai.wordpress.com\/275\/\"><img alt=\"\" border=\"0\" src=\"http:\/\/feeds.wordpress.com\/1.0\/comments\/alfonsoirai.wordpress.com\/275\/\" \/><\/a> <img alt=\"\" border=\"0\" src=\"https:\/\/pixel.wp.com\/b.gif?host=alfonsoirai.wordpress.com&#038;blog=98719662&%23038;post=275&%23038;subd=alfonsoirai&%23038;ref=&%23038;feed=1\" width=\"1\" height=\"1\" \/>","protected":false},"excerpt":{"rendered":"<p>SQL Server and relational databases (RDBMS) have been the go-to databases for over 20 years. However, the increased need to process higher volumes, velocities, and varieties of data at a rapid rate has altered the nature of data storage needs for application developers. In order to enable this scenario, NoSQL databases that enable storing unstructured &hellip; <a href=\"https:\/\/kenscourses.com\/tc1019fall2016\/syndicated\/nosql-vs-sql\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">NoSQL vs SQL<\/span><\/a><\/p>\n","protected":false},"author":24,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,4],"tags":[126,25],"class_list":["post-38475","post","type-post","status-publish","format-standard","hentry","category-blogs","category-syndicated","tag-blog","tag-tc1019"],"_links":{"self":[{"href":"https:\/\/kenscourses.com\/tc1019fall2016\/wp-json\/wp\/v2\/posts\/38475","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kenscourses.com\/tc1019fall2016\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kenscourses.com\/tc1019fall2016\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kenscourses.com\/tc1019fall2016\/wp-json\/wp\/v2\/users\/24"}],"replies":[{"embeddable":true,"href":"https:\/\/kenscourses.com\/tc1019fall2016\/wp-json\/wp\/v2\/comments?post=38475"}],"version-history":[{"count":1,"href":"https:\/\/kenscourses.com\/tc1019fall2016\/wp-json\/wp\/v2\/posts\/38475\/revisions"}],"predecessor-version":[{"id":38476,"href":"https:\/\/kenscourses.com\/tc1019fall2016\/wp-json\/wp\/v2\/posts\/38475\/revisions\/38476"}],"wp:attachment":[{"href":"https:\/\/kenscourses.com\/tc1019fall2016\/wp-json\/wp\/v2\/media?parent=38475"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kenscourses.com\/tc1019fall2016\/wp-json\/wp\/v2\/categories?post=38475"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kenscourses.com\/tc1019fall2016\/wp-json\/wp\/v2\/tags?post=38475"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}