{"id":1401,"date":"2018-07-26T17:03:47","date_gmt":"2018-07-26T21:03:47","guid":{"rendered":"https:\/\/solutionsreview.com\/data-management\/?p=1401"},"modified":"2018-07-27T11:21:41","modified_gmt":"2018-07-27T15:21:41","slug":"memsql-updates-flagship-database-with-faster-queries-and-automation","status":"publish","type":"post","link":"https:\/\/solutionsreview.com\/data-management\/memsql-updates-flagship-database-with-faster-queries-and-automation\/","title":{"rendered":"MemSQL Updates Flagship Database with Faster Queries and Automation"},"content":{"rendered":"<div id=\"attachment_1402\" style=\"width: 810px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1402\" class=\"size-full wp-image-1402\" src=\"https:\/\/solutionsreview.com\/data-management\/files\/2018\/07\/oie_rlyicjIrvxk2.jpg\" alt=\"MemSQL Updates Flagship Database with Faster Queries and Automation\" width=\"800\" height=\"400\" srcset=\"https:\/\/solutionsreview.com\/data-management\/files\/2018\/07\/oie_rlyicjIrvxk2.jpg 800w, https:\/\/solutionsreview.com\/data-management\/files\/2018\/07\/oie_rlyicjIrvxk2-300x150.jpg 300w, https:\/\/solutionsreview.com\/data-management\/files\/2018\/07\/oie_rlyicjIrvxk2-768x384.jpg 768w, https:\/\/solutionsreview.com\/data-management\/files\/2018\/07\/oie_rlyicjIrvxk2-600x300.png 600w, https:\/\/solutionsreview.com\/data-management\/files\/2018\/07\/oie_rlyicjIrvxk2-162x81.png 162w, https:\/\/solutionsreview.com\/data-management\/files\/2018\/07\/oie_rlyicjIrvxk2-360x180.png 360w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><p id=\"caption-attachment-1402\" class=\"wp-caption-text\">Source: MemSQL<\/p><\/div>\n<p style=\"text-align: justify\">MemSQL <a href=\"https:\/\/www.memsql.com\/releases\/memsql6.5\/\" target=\"_blank\" rel=\"noopener\">recently announced<\/a> the release of MemSQL 6.5, adding capabilities to further hasten data management. The update is highlighted by up to four times faster queries and new automated workload optimization features that provide dependable database response under high concurrency. In addition, the &#8220;transform-as-you-ingest&#8221; framework allows users to utilize stored procedures for in-database transformations. There are also resource optimization improvements present for multi-tenant deployments.<\/p>\n<div class=\"widget\"><div class=\"aside-card\">\t\t\t<div class=\"textwidget\"><a class=\"speedbump\" href=\"https:\/\/solutionsreview.com\/data-management\/data-management-data-warehouse-buyers-guide\/\" title=\"Download link to Data Management Buyers Guide\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-1682\" src=\"https:\/\/solutionsreview.com\/data-management\/files\/2019\/01\/data-management-speedbump-cta.jpg\" alt=\"Download Link to Data Management Buyers Guide\" width=\"800\" height=\"225\" \/><\/a><\/div>\n\t\t<\/div><\/div>\n<p style=\"text-align: justify\">MemSQL can ingest and transform millions of events per day while also analyzing billions of rows of data using standard SQL. The tool can be deployed on-prem, in the cloud via Amazon Web Services or Microsoft Azure, or as a service including drop-in compatibility with existing middleware, integration, and BI software. MemSQL is available in two editions: Developer (not for product deployments) and Enterprise.<\/p>\n<p style=\"text-align: justify\">Version 6.5 features full-text search built in, eliminating the need for specialized data stores. The product now incorporates a dedicated data pipeline for Hadoop as well, allowing developers to ingest from Hadoop into a structured relational format using ANSI SQL. The company&#8217;s co-founder and CEO Nikita Shamgunov adds: &#8220;Legacy databases aren\u2019t capable of providing the scale, speed, and efficiency that NewSQL databases can.\u00a0With MemSQL 6.5, companies are getting a database that allows them to do more with the data that drives their business. All with familiar tools, faster than before, and at a fraction of the cost.&#8221;<\/p>\n<p style=\"text-align: justify\">This update comes on the heels of MemSQL&#8217;s May series D round that saw the company close on <a href=\"https:\/\/solutionsreview.com\/data-management\/memsql-nabs-30m-in-new-funding-after-record-year\/\" target=\"_blank\" rel=\"noopener\">$30 million<\/a> in venture capital.\u00a0The provider\u00a0<a class=\"external\" href=\"https:\/\/www.memsql.com\/releases\/fy18momentum\/\" target=\"_blank\" rel=\"noopener nofollow\">ended its fiscal year<\/a>\u00a0with fourth quarter commercial bookings growing more than 200 percent. Additionally, MemSQL established a\u00a0<a class=\"external\" href=\"https:\/\/www.memsql.com\/releases\/trillionrows\/\" target=\"_blank\" rel=\"noopener nofollow\">new baseline for speed<\/a>\u00a0by delivering a scan rate over a trillion rows per second on 12 Intel servers \u2013 something that organizations with very large data sets surely appreciate.<\/p>\n<p style=\"text-align: justify\">MemSQL\u2019s star is certainly on the rise, as the company was included in several major analyst reports in the last few months. Solutions Review named the vendor one of\u00a0<a href=\"https:\/\/solutionsreview.com\/data-management\/5-data-management-solutions-for-analytics-vendors-to-watch-in-2018\/\" target=\"_blank\" rel=\"noopener\">5 Data Management Solutions for Analytics Vendors to Watch in 2018<\/a>\u00a0in January. Shortly after, Gartner included the company as a market challenger in its\u00a0<em><a href=\"https:\/\/solutionsreview.com\/data-management\/whats-changed-2018-gartner-magic-quadrant-for-data-management-solutions-for-analytics\/\" target=\"_blank\" rel=\"noopener\">Magic Quadrant for Data Management Solutions for Analytics<\/a><\/em>. CRN also grouped MemSQL amongst some of the coolest big data startups in its May\u00a0<a href=\"https:\/\/solutionsreview.com\/data-management\/crn-big-data-100-10-data-management-tools-we-recommend\/\" target=\"_blank\" rel=\"noopener\"><em>Big Data 100<\/em><\/a>\u00a0listing.<\/p>\n<p>Read the <a href=\"https:\/\/www.memsql.com\/releases\/memsql6.5\/\" target=\"_blank\" rel=\"noopener\">press release<\/a> or click through for more.<\/p>\n<div class=\"hr hr\"><\/div>\n<br \/>Widget not in any sidebars<br \/>\n","protected":false},"excerpt":{"rendered":"<p>MemSQL recently announced the release of MemSQL 6.5, adding capabilities to further hasten data management. The update is highlighted by up to four times faster queries and new automated workload optimization features that provide dependable database response under high concurrency. In addition, the &#8220;transform-as-you-ingest&#8221; framework allows users to utilize stored procedures for in-database transformations. There [&hellip;]<\/p>\n","protected":false},"author":23,"featured_media":1402,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[360],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MemSQL Updates Flagship Database with Faster Queries and Automation<\/title>\n<meta name=\"description\" content=\"MemSQL can be deployed on-prem, in the cloud via Amazon Web Services or Microsoft Azure, or as a service with existing middleware.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/solutionsreview.com\/data-management\/memsql-updates-flagship-database-with-faster-queries-and-automation\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MemSQL Updates Flagship Database with Faster Queries and Automation\" \/>\n<meta property=\"og:description\" content=\"MemSQL can be deployed on-prem, in the cloud via Amazon Web Services or Microsoft Azure, or as a service with existing middleware.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/solutionsreview.com\/data-management\/memsql-updates-flagship-database-with-faster-queries-and-automation\/\" \/>\n<meta property=\"og:site_name\" content=\"Best Data Management Software, Vendors and Data Science Platforms\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-26T21:03:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-07-27T15:21:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/solutionsreview.com\/data-management\/files\/2018\/07\/oie_rlyicjIrvxk2.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Tim King\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tim King\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. 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\":\"WebPage\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/memsql-updates-flagship-database-with-faster-queries-and-automation\/\",\"url\":\"https:\/\/solutionsreview.com\/data-management\/memsql-updates-flagship-database-with-faster-queries-and-automation\/\",\"name\":\"MemSQL Updates Flagship Database with Faster Queries and Automation\",\"isPartOf\":{\"@id\":\"https:\/\/solutionsreview.com\/data-management\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/solutionsreview.com\/data-management\/memsql-updates-flagship-database-with-faster-queries-and-automation\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/data-management\/memsql-updates-flagship-database-with-faster-queries-and-automation\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/solutionsreview.com\/data-management\/files\/2018\/07\/oie_rlyicjIrvxk2.jpg\",\"datePublished\":\"2018-07-26T21:03:47+00:00\",\"dateModified\":\"2018-07-27T15:21:41+00:00\",\"author\":{\"@id\":\"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c\"},\"description\":\"MemSQL can be deployed on-prem, in the cloud via Amazon Web Services or Microsoft Azure, or as a service with existing middleware.\",\"breadcrumb\":{\"@id\":\"https:\/\/solutionsreview.com\/data-management\/memsql-updates-flagship-database-with-faster-queries-and-automation\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/solutionsreview.com\/data-management\/memsql-updates-flagship-database-with-faster-queries-and-automation\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/memsql-updates-flagship-database-with-faster-queries-and-automation\/#primaryimage\",\"url\":\"https:\/\/solutionsreview.com\/data-management\/files\/2018\/07\/oie_rlyicjIrvxk2.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/data-management\/files\/2018\/07\/oie_rlyicjIrvxk2.jpg\",\"width\":800,\"height\":400,\"caption\":\"Source: MemSQL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/memsql-updates-flagship-database-with-faster-queries-and-automation\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/solutionsreview.com\/data-management\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MemSQL Updates Flagship Database with Faster Queries and Automation\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/#website\",\"url\":\"https:\/\/solutionsreview.com\/data-management\/\",\"name\":\"Best Data Management Software, Vendors and Data Science Platforms\",\"description\":\"Enterprise Information Management\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/solutionsreview.com\/data-management\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c\",\"name\":\"Tim King\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/solutionsreview.com\/data-management\/files\/2023\/12\/tk.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/data-management\/files\/2023\/12\/tk.jpg\",\"caption\":\"Tim King\"},\"description\":\"Tim is Solutions Review's Executive Editor covering the human impact of AI on the future of work and learning. He is also the Media Strategist behind Insight Jam (1M+ on YouTube) events and programming. A 2017 and 2018 Most Influential Business Journalist and 2021 \\\"Who's Who\\\" in multiple categories, Tim is a recognized thought leader in enterprise tech and AI.\",\"url\":\"https:\/\/solutionsreview.com\/data-management\/author\/timking\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MemSQL Updates Flagship Database with Faster Queries and Automation","description":"MemSQL can be deployed on-prem, in the cloud via Amazon Web Services or Microsoft Azure, or as a service with existing middleware.","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:\/\/solutionsreview.com\/data-management\/memsql-updates-flagship-database-with-faster-queries-and-automation\/","og_locale":"en_US","og_type":"article","og_title":"MemSQL Updates Flagship Database with Faster Queries and Automation","og_description":"MemSQL can be deployed on-prem, in the cloud via Amazon Web Services or Microsoft Azure, or as a service with existing middleware.","og_url":"https:\/\/solutionsreview.com\/data-management\/memsql-updates-flagship-database-with-faster-queries-and-automation\/","og_site_name":"Best Data Management Software, Vendors and Data Science Platforms","article_published_time":"2018-07-26T21:03:47+00:00","article_modified_time":"2018-07-27T15:21:41+00:00","og_image":[{"width":800,"height":400,"url":"https:\/\/solutionsreview.com\/data-management\/files\/2018\/07\/oie_rlyicjIrvxk2.jpg","type":"image\/jpeg"}],"author":"Tim King","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tim King","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/solutionsreview.com\/data-management\/memsql-updates-flagship-database-with-faster-queries-and-automation\/","url":"https:\/\/solutionsreview.com\/data-management\/memsql-updates-flagship-database-with-faster-queries-and-automation\/","name":"MemSQL Updates Flagship Database with Faster Queries and Automation","isPartOf":{"@id":"https:\/\/solutionsreview.com\/data-management\/#website"},"primaryImageOfPage":{"@id":"https:\/\/solutionsreview.com\/data-management\/memsql-updates-flagship-database-with-faster-queries-and-automation\/#primaryimage"},"image":{"@id":"https:\/\/solutionsreview.com\/data-management\/memsql-updates-flagship-database-with-faster-queries-and-automation\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionsreview.com\/data-management\/files\/2018\/07\/oie_rlyicjIrvxk2.jpg","datePublished":"2018-07-26T21:03:47+00:00","dateModified":"2018-07-27T15:21:41+00:00","author":{"@id":"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c"},"description":"MemSQL can be deployed on-prem, in the cloud via Amazon Web Services or Microsoft Azure, or as a service with existing middleware.","breadcrumb":{"@id":"https:\/\/solutionsreview.com\/data-management\/memsql-updates-flagship-database-with-faster-queries-and-automation\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/solutionsreview.com\/data-management\/memsql-updates-flagship-database-with-faster-queries-and-automation\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-management\/memsql-updates-flagship-database-with-faster-queries-and-automation\/#primaryimage","url":"https:\/\/solutionsreview.com\/data-management\/files\/2018\/07\/oie_rlyicjIrvxk2.jpg","contentUrl":"https:\/\/solutionsreview.com\/data-management\/files\/2018\/07\/oie_rlyicjIrvxk2.jpg","width":800,"height":400,"caption":"Source: MemSQL"},{"@type":"BreadcrumbList","@id":"https:\/\/solutionsreview.com\/data-management\/memsql-updates-flagship-database-with-faster-queries-and-automation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/solutionsreview.com\/data-management\/"},{"@type":"ListItem","position":2,"name":"MemSQL Updates Flagship Database with Faster Queries and Automation"}]},{"@type":"WebSite","@id":"https:\/\/solutionsreview.com\/data-management\/#website","url":"https:\/\/solutionsreview.com\/data-management\/","name":"Best Data Management Software, Vendors and Data Science Platforms","description":"Enterprise Information Management","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/solutionsreview.com\/data-management\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c","name":"Tim King","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/image\/","url":"https:\/\/solutionsreview.com\/data-management\/files\/2023\/12\/tk.jpg","contentUrl":"https:\/\/solutionsreview.com\/data-management\/files\/2023\/12\/tk.jpg","caption":"Tim King"},"description":"Tim is Solutions Review's Executive Editor covering the human impact of AI on the future of work and learning. He is also the Media Strategist behind Insight Jam (1M+ on YouTube) events and programming. A 2017 and 2018 Most Influential Business Journalist and 2021 \"Who's Who\" in multiple categories, Tim is a recognized thought leader in enterprise tech and AI.","url":"https:\/\/solutionsreview.com\/data-management\/author\/timking\/"}]}},"_links":{"self":[{"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/posts\/1401"}],"collection":[{"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/users\/23"}],"replies":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/comments?post=1401"}],"version-history":[{"count":0,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/posts\/1401\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/media\/1402"}],"wp:attachment":[{"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/media?parent=1401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/categories?post=1401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/tags?post=1401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}