{"id":3519,"date":"2012-08-08T02:59:48","date_gmt":"2012-08-08T10:59:48","guid":{"rendered":"http:\/\/www.ramonchen.com\/?p=3519"},"modified":"2023-05-29T10:31:38","modified_gmt":"2023-05-29T18:31:38","slug":"nosql-newsql-mysql-postgresql-and-a-new-breed-of-databases","status":"publish","type":"post","link":"https:\/\/www.ramonchen.com\/?p=3519","title":{"rendered":"NoSQL, NewSQL. MySQL, PostgreSQL and a New Breed of Databases"},"content":{"rendered":"<p>Last year Matt Aslett of the 415 Group published an blog post titled <a href=\"http:\/\/blogs.the451group.com\/information_management\/2011\/04\/06\/what-we-talk-about-when-we-talk-about-newsql\/\" target=\"_blank\" rel=\"noopener\">&#8220;What we talk about when we talk about NewSQL&#8221;<\/a>. In it describes NewSQL as &#8220;a loosely-affiliated group of companies &#8230; what they have in common is the development of new relational database products and services designed to bring the benefits of the relational model to distributed architectures, or to improve the performance of relational databases to the extent that horizontal scalability is no longer a necessity.&#8221;<\/p>\n<p>He then followed-up a week later with a definition of SPRAIN which he defined as:<\/p>\n<ul>\n<li>Scalability \u2013 hardware economics<\/li>\n<li>Performance \u2013 MySQL limitations<\/li>\n<li>Relaxed consistency \u2013 CAP theorem<\/li>\n<li>Agility \u2013 polyglot persistence<\/li>\n<li>Intricacy \u2013 big data, total data<\/li>\n<li>Necessity \u2013 open source<\/li>\n<\/ul>\n<p>And 451 published a report available for 451 clients, from both the <a href=\"http:\/\/www.the451group.com\/im\/im_detail.php?icid=1389\">Information Management<\/a> and <a href=\"http:\/\/www.the451group.com\/caos\/caos_detail.php?icid=1651\">Open Source<\/a> practices (non-clients can apply for trial access). The database landscape diagram is perhaps the most interesting in that it covers a wide variety of databases, placing them neatly into functional and architectural buckets:<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/blogs.the451group.com\/information_management\/files\/2011\/04\/Figures-Aslett_web.jpg\" alt=\"Figures-Aslett_web.jpg\" \/><\/p>\n<p>What made the blog post even more interesting was the comments made to the article debating the scalability of long time RDBMS Open Source favorite (now owned by Oracle via Sun), MySQL. The Q&amp;A site Quora for example has a question <a href=\"http:\/\/www.quora.com\/Quora-Infrastructure\/Why-does-Quora-use-MySQL-as-the-data-store-instead-of-NoSQLs-such-as-Cassandra-MongoDB-or-CouchDB\" target=\"_blank\" rel=\"noopener\">posted reflecting why Quora itself uses MySQL successfully and at high scale.<\/a> Matt and 451 then followed up this January with an interesting MySQL, NoSQL and NewSQL survey, in <a href=\"http:\/\/blogs.the451group.com\/opensource\/2012\/05\/25\/mysql-vs-nosql-and-newsql-survey-results\/\" target=\"_blank\" rel=\"noopener\">which he summarizes the results here<\/a>. The full slideshare can be <a href=\"<;iframe src=&quot;http:\/\/www.slideshare.net\/slideshow\/embed_code\/13073043&quot; width=&quot;427&quot; height=&quot;356&quot; frameborder=&quot;0&quot; marginwidth=&quot;0&quot; marginheight=&quot;0&quot; scrolling=&quot;no&quot; style=&quot;border:1px solid #CCC;border-width:1px 1px 0;margin-bottom:5px&quot; allowfullscreen>; <;\/iframe>; <;div style=&quot;margin-bottom:5px&quot;>; <;strong>; <;a href=&quot;http:\/\/www.slideshare.net\/mattaslett\/mysql-vs-nosql-and-newsql-survey-results-13073043&quot; title=&quot;MySQL vs. NoSQL and NewSQL - survey results&quot; target=&quot;_blank&quot;>;MySQL vs. NoSQL and NewSQL &#8211; survey results<;\/a>; <;\/strong>; from <;strong>;<;a href=&quot;http:\/\/www.slideshare.net\/mattaslett&quot; target=&quot;_blank&quot;>;Matthew Aslett<;\/a>;<;\/strong>; <;\/div>;&#8221; target=&#8221;_blank&#8221;>found here<\/a>.<\/p>\n<p>While there are many supporters of MySQL, there are also variants upon which certain products focused on Big Data and analytics have taken advantage of the open source base and layered on capabilities to fit specific use cases. Infobright is a product for example that leverages MySQL.<\/p>\n<p>Then there is PostgreSQL, previously considered less popular than MySQL, it has been leveraged extensively by commercial products. For example, <a href=\"http:\/\/www.greenplum.com\" target=\"_blank\" rel=\"noopener\">Greenplum<\/a> (acquired by EMC) and AsterData (acquired by Teradata) both started with vanilla <a href=\"http:\/\/en.wikipedia.org\/wiki\/PostgreSQL\" target=\"_blank\" rel=\"noopener\">PostgreSQL<\/a> and turned themselves into a shared-nothing, MPP analytical DBMS. AsterData had the additional benefit of adding their flavor of MapReduce in the form of SQL\/MR. More recently <a href=\"http:\/\/www.hadapt.com\">Hadapt<\/a> is using PostgreSQL to bridge the gap between SQL and Hadoop, allowing both SQL and MapReduce to be run respectively against the data stored in their separate repositories.<\/p>\n<p>There are also a new breed of databases that focus on Cloud and SaaS, a full list and excellent summary by GigOMs Derek Harris can be found here in the article titled <a href=\"http:\/\/gigaom.com\/cloud\/cloud-databases-101-who-builds-em-and-what-they-do\/\" target=\"_blank\" rel=\"noopener\">&#8220;Cloud Databases 101&#8221;<\/a>.<\/p>\n<p>Finally there are those whose fundamental core is architect from scratch. Let&#8217;s face it building a completely new database is hard! And starting from a clean slate brings true innovation. <a href=\"http:\/\/www.nuodb.com\" target=\"_blank\" rel=\"noopener\">NuoDB<\/a> is one such company currently in beta. They have a <a href=\"http:\/\/www.prweb.com\/releases\/nuodb\/august_2012\/prweb9778663.htm\" target=\"_blank\" rel=\"noopener\">patent for a multi-user, elastic, on-demand, distributed relational database management system<\/a>, that they tout as everything Oracle is not. <a href=\"http:\/\/voltdb.com\/\" target=\"_blank\" rel=\"noopener\">VoltDB<\/a> by <a href=\"http:\/\/en.wikipedia.org\/wiki\/Michael_Stonebraker\" target=\"_blank\" rel=\"noopener\">Mike Stonebraker<\/a> (founder of Ingres, father of PostgreSQL and CTO\/founder at Vertica before starting VoltDB) is another leading contender in the so called NewSQL camp (incidentally Mike has been quite against the NoSQL movement). <a href=\"http:\/\/www.rainstor.com\" target=\"_blank\" rel=\"noopener\">RainStor<\/a> (my current company) by the way is one such database, architected from the ground up to handle Big Data, it is NoSQL in its patented storage mechanisms but it presents a completely relational SQL-92 front end for user access. It can therefore scale like a NewSQL database, but its primary use case is not transactional, but focused on mainly static\/read only Big data sets. It also plays nicely with Hadoop running natively on HDFS and supports both MapReduce and PIG access, together with ad-hoc SQL-92 queries.<\/p>\n<p>With the database market seeing more action in the last 2 years than it ever has, and the market estimated at 100 Billion and growing, we will likely see more contenders coming and more contenders forming. Right now there are lots of flavors of databases to choose from solving a variety of use cases, using new and old customized technology. It&#8217;s a fun time to be in the database space!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Last year Matt Aslett of the 415 Group published an blog post titled &#8220;What we [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[32,449,210,300,201],"tags":[183,486,156,466,406,463,377,467,465],"class_list":["post-3519","post","type-post","status-publish","format-standard","hentry","category-all","category-bigdata-2","category-databases","category-hadoopmr","category-technology","tag-asterdata","tag-databases","tag-greenplum","tag-hadapt","tag-mysql","tag-newsql","tag-nosql","tag-nuodb","tag-postgresql"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.ramonchen.com\/index.php?rest_route=\/wp\/v2\/posts\/3519","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ramonchen.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ramonchen.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ramonchen.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ramonchen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3519"}],"version-history":[{"count":7,"href":"https:\/\/www.ramonchen.com\/index.php?rest_route=\/wp\/v2\/posts\/3519\/revisions"}],"predecessor-version":[{"id":5802,"href":"https:\/\/www.ramonchen.com\/index.php?rest_route=\/wp\/v2\/posts\/3519\/revisions\/5802"}],"wp:attachment":[{"href":"https:\/\/www.ramonchen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3519"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ramonchen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3519"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ramonchen.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}