{"id":14242,"date":"2019-09-05T14:29:49","date_gmt":"2019-09-05T14:29:49","guid":{"rendered":"https:\/\/blog.tmcnet.com\/blog\/rich-tehrani\/?p=14242"},"modified":"2022-10-14T18:27:50","modified_gmt":"2022-10-14T22:27:50","slug":"iot-and-iiot-database-cratedb-from-crate-io-gets-an-upgrade","status":"publish","type":"post","link":"https:\/\/blog.tmcnet.com\/blog\/rich-tehrani\/iot\/iot-and-iiot-database-cratedb-from-crate-io-gets-an-upgrade.html","title":{"rendered":"IoT and IIoT Database CrateDB from Crate.io Gets an Upgrade"},"content":{"rendered":"\n<p><a href=\"https:\/\/www.iotevolutionworld.com\/m2m\/articles\/442680-crateio-receives-2019-iot-evolution-industrial-iot-product.htm\">Award-winning<\/a> <a href=\"https:\/\/www.tmcnet.com\/query\/searchresults.aspx?searchstring=Crate.io+&amp;Action.x=0&amp;Action.y=0\">Crate.io<\/a> just upgraded their CrateDB database used for IoT and IIoT. While much of the focus in the &#8220;internet of things&#8221; space has been on the sensors and trackers, in reality &#8211; the databases do the heavy lifting by allowing a platform for analytics to be performed. This is where true digital transformation takes place!<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"650\" height=\"150\" src=\"https:\/\/blog.tmcnet.com\/blog\/rich-tehrani\/wp-content\/uploads\/2019\/09\/Crate-Logo.png\" alt=\"\" class=\"wp-image-14324\"\/><\/figure>\n\n\n\n<p>Used and trusted by large enterprises including Nokia, Gantner Instruments, Qualtrics, Comcast, and ALPLA, CrateDB Cloud features unlimited scaling and 10x better price-performance when compared to other time-series cloud databases. <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.tmcnet.com\/blog\/rich-tehrani\/wp-content\/uploads\/2019\/09\/crate-shot-1024x694.jpg\" alt=\"\" class=\"wp-image-14323\" width=\"401\" height=\"271\"\/><\/figure><\/div>\n\n\n\n<p>CrateDB 4.0. has key updates that address several components of the highly scalable open-source database, 4.0 makes it easier, faster, and more cost-effective for IoT- and IIoT-fueled organizations to put their machine and sensor data to work.<\/p>\n\n\n\n<p>CrateDB is a distributed SQL database based on a NoSQL architecture that takes advantage of the convenience of SQL for processing any structured or unstructured data type. Dynamic schemas make it extremely easy to add new data types or indexes, and the architecture allows horizontal scaling by interconnecting servers to capture millions of IoT and IIoT data inputs per second (totaling hundreds of terabytes in cluster size). Distributed processing, data partitioning, and in-memory indexes return millisecond responses to time-series requests \u2013 even when many clients are working in the database simultaneously.<\/p>\n\n\n\n<p>Benefits of\nwhat\u2019s new in CrateDB 4.0 include:<\/p>\n\n\n\n<ul><li><strong>Easier to work with time-series data <\/strong>via improvements to the options for specifying a frame for window functions.<\/li><li><strong>Better clustering and node discovery <\/strong>by moving to <a rel=\"noreferrer noopener\" href=\"https:\/\/www.elastic.co\/blog\/a-new-era-for-cluster-coordination-in-elasticsearch\" target=\"_blank\">Zen 2<\/a> to stay in sync with Elasticsearch.<\/li><li><strong>More PosgreSQL interoperability<\/strong> with synced data types names, synced timestamp formatting, the addition of the&nbsp;pg_catalog&nbsp;schema with its associated tables, and new functions that some tools require when connecting.<\/li><li><strong>Improved ANSI SQL compliance<\/strong> through new support for the default clause in the      CRATE TABLE statement, among other changes.<\/li><li><strong>Stricter access controls<\/strong> with the introduction of a dedicated privilege type for administrative tasks; masking of sensitive information has also been added to further bolster security when handling Azure and AWS credentials.<\/li><li><strong>Enhanced resiliency<\/strong> by exposing _seq_no&nbsp;and&nbsp;_primary_term, which can be used for&nbsp;optimistic concurrency control.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><img loading=\"lazy\" decoding=\"async\" width=\"450\" height=\"450\" src=\"https:\/\/blog.tmcnet.com\/blog\/rich-tehrani\/wp-content\/uploads\/2019\/09\/Johannes-Moser.jpg\" alt=\"\" class=\"wp-image-14246\" srcset=\"https:\/\/blog.tmcnet.com\/blog\/rich-tehrani\/wp-content\/uploads\/2019\/09\/Johannes-Moser.jpg 450w, https:\/\/blog.tmcnet.com\/blog\/rich-tehrani\/wp-content\/uploads\/2019\/09\/Johannes-Moser-90x90.jpg 90w, https:\/\/blog.tmcnet.com\/blog\/rich-tehrani\/wp-content\/uploads\/2019\/09\/Johannes-Moser-300x300.jpg 300w\" sizes=\"(max-width: 450px) 100vw, 450px\" \/><\/figure><\/div>\n\n\n\n<p>\u201cCrateDB 4.0 is an important release for our userbase,\u201d said Johannes Moser, Head of Product at Crate.io. \u201cFast access to secure data \u2013 massive, massive volumes of data \u2013 is so crucial to IoT and IIoT applications, and we\u2019re proud to continue to find new ways to improve our core database to meet customer requirements.\u201d<\/p>\n\n\n\n<p>We applaud Crate.io for their upgrade to CrateDB &#8211; allowing organizations to become more efficient, productive and transformational as they deploy IoT in their companies, factories, smart cities, smart buildings and more.<\/p>\n\n\n\n<p>Learn more about Edge, IIoT, IoT and Smart Buildings at&nbsp;<a href=\"https:\/\/www.iotevolutionexpo.com\/east\/\">IoT Evolution<\/a>&nbsp;Expo, part of the&nbsp;<a href=\"http:\/\/www.itexpo.com\/\">ITEXPO&nbsp;<\/a>TECHSUPERSHOW, Feb 12-14, 2020 in Fort Lauderdale, Florida. <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1000\" height=\"539\" src=\"https:\/\/blog.tmcnet.com\/blog\/rich-tehrani\/wp-content\/uploads\/2019\/06\/iot-evolution-1.jpg\" alt=\"\" class=\"wp-image-12770\" srcset=\"https:\/\/blog.tmcnet.com\/blog\/rich-tehrani\/wp-content\/uploads\/2019\/06\/iot-evolution-1.jpg 1000w, https:\/\/blog.tmcnet.com\/blog\/rich-tehrani\/wp-content\/uploads\/2019\/06\/iot-evolution-1-768x414.jpg 768w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Award-winning Crate.io just upgraded their CrateDB database used for IoT and IIoT. While much of the focus in the &#8220;internet of things&#8221; space has been on the sensors and trackers, in reality &#8211; the databases do the heavy lifting by allowing a platform for analytics to be performed. This is where true digital transformation takes<\/p>\n","protected":false},"author":44,"featured_media":14243,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[185],"tags":[2355,2354,2356,2019,1797,1798,2359,2360,2358],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/blog.tmcnet.com\/blog\/rich-tehrani\/wp-json\/wp\/v2\/posts\/14242"}],"collection":[{"href":"https:\/\/blog.tmcnet.com\/blog\/rich-tehrani\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.tmcnet.com\/blog\/rich-tehrani\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.tmcnet.com\/blog\/rich-tehrani\/wp-json\/wp\/v2\/users\/44"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.tmcnet.com\/blog\/rich-tehrani\/wp-json\/wp\/v2\/comments?post=14242"}],"version-history":[{"count":3,"href":"https:\/\/blog.tmcnet.com\/blog\/rich-tehrani\/wp-json\/wp\/v2\/posts\/14242\/revisions"}],"predecessor-version":[{"id":14325,"href":"https:\/\/blog.tmcnet.com\/blog\/rich-tehrani\/wp-json\/wp\/v2\/posts\/14242\/revisions\/14325"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.tmcnet.com\/blog\/rich-tehrani\/wp-json\/wp\/v2\/media\/14243"}],"wp:attachment":[{"href":"https:\/\/blog.tmcnet.com\/blog\/rich-tehrani\/wp-json\/wp\/v2\/media?parent=14242"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.tmcnet.com\/blog\/rich-tehrani\/wp-json\/wp\/v2\/categories?post=14242"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.tmcnet.com\/blog\/rich-tehrani\/wp-json\/wp\/v2\/tags?post=14242"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}