{"id":1855,"date":"2019-05-14T15:03:30","date_gmt":"2019-05-14T19:03:30","guid":{"rendered":"https:\/\/solutionsreview.com\/data-management\/?p=1855"},"modified":"2019-05-15T15:09:54","modified_gmt":"2019-05-15T19:09:54","slug":"memsql-rolls-new-security-and-analytics-features-into-its-database","status":"publish","type":"post","link":"https:\/\/solutionsreview.com\/data-management\/memsql-rolls-new-security-and-analytics-features-into-its-database\/","title":{"rendered":"MemSQL Rolls New Security and Analytics Features into Its Database"},"content":{"rendered":"
\"MemSQL

Source: MemSQL<\/p><\/div>\n

MemSQL is adding new analytical capabilities to its main database product, according to a press release<\/a>. MemSQL version 6.8 also features new advanced security support with Kerberos and wire encryption for HDFS Pipelines along with ad hoc query performance enhancements. The updated solution is now available for current customers, and comes on the heels of the company’s last release in November when it added a free tier<\/a> and cluster monitoring tools.<\/p>\n

\t\t\t
\"Download<\/a><\/div>\n\t\t<\/div><\/div>\n

MemSQL can ingest and transform millions of events per day while also analyzing billions of rows of data using standard SQL. It can be deploted 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. The tool offers excellent real-time data streaming capabilities, and now provides more efficient query isolation for large volumes of data and many users.<\/p>\n

Version 6.8 is highlighted by an attempt at speedier ad hoc querying, something MemSQL is referring to as Interpret First Query Compilation. It allows users to avoid having to go through an entire compilation step before starting to run code. The feature enables first run queries to run 10-to-100 times faster without hints or tuning. There’s also expanded SQL coverage aimed at simplifying query design and migrations from legacy databases that support ANSI SQL. The new query types include RIGHT SEMI, ANTI, and OUTER JOIN.<\/p>\n

We reached out to MemSQL for comment, and the company’s co-founder and Chief of Technology Adam Prout said: “From the start, we\u2019ve worked to make MemSQL the fastest database in the world. And MemSQL 6.8 is no different. We\u2019ve made ad-hoc queries run 10-100 times faster. But speed isn\u2019t the only thing we\u2019re focused on with 6.8. We\u2019re showing enterprises why MemSQL is the best database for their business, no matter what their workload.”<\/p>\n

MemSQL also took some time to brag about its database speeds, claiming that its product benchmarked up to 8 times faster than the competition<\/a>. We encourage you to judge the results<\/a> on your own. Solutions Review included MemSQL as one of The 10 Best Data Management Solutions for Analytics in 2019<\/em><\/a> late last year.<\/p>\n

<\/div>\n
\t\t\t

\"Download<\/a><\/p>\n<\/div>\n\t\t<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

MemSQL is adding new analytical capabilities to its main database product, according to a press release. MemSQL version 6.8 also features new advanced security support with Kerberos and wire encryption for HDFS Pipelines along with ad hoc query performance enhancements. The updated solution is now available for current customers, and comes on the heels of […]<\/p>\n","protected":false},"author":23,"featured_media":1856,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[557,360],"acf":[],"yoast_head":"\nMemSQL Rolls New Security and Analytics Features into Its Database<\/title>\n<meta name=\"description\" content=\"MemSQL is updating its main database product with new analytical capabilities, ad hoc query performance enhancements, and security support.\" \/>\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-rolls-new-security-and-analytics-features-into-its-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MemSQL Rolls New Security and Analytics Features into Its Database\" \/>\n<meta property=\"og:description\" content=\"MemSQL is updating its main database product with new analytical capabilities, ad hoc query performance enhancements, and security support.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/solutionsreview.com\/data-management\/memsql-rolls-new-security-and-analytics-features-into-its-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Best Data Management Software, Vendors and Data Science Platforms\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-14T19:03:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-05-15T19:09:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/solutionsreview.com\/data-management\/files\/2019\/05\/oie_dwEha4HvufKE.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-rolls-new-security-and-analytics-features-into-its-database\/\",\"url\":\"https:\/\/solutionsreview.com\/data-management\/memsql-rolls-new-security-and-analytics-features-into-its-database\/\",\"name\":\"MemSQL Rolls New Security and Analytics Features into Its Database\",\"isPartOf\":{\"@id\":\"https:\/\/solutionsreview.com\/data-management\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/solutionsreview.com\/data-management\/memsql-rolls-new-security-and-analytics-features-into-its-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/data-management\/memsql-rolls-new-security-and-analytics-features-into-its-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/solutionsreview.com\/data-management\/files\/2019\/05\/oie_dwEha4HvufKE.jpg\",\"datePublished\":\"2019-05-14T19:03:30+00:00\",\"dateModified\":\"2019-05-15T19:09:54+00:00\",\"author\":{\"@id\":\"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c\"},\"description\":\"MemSQL is updating its main database product with new analytical capabilities, ad hoc query performance enhancements, and security support.\",\"breadcrumb\":{\"@id\":\"https:\/\/solutionsreview.com\/data-management\/memsql-rolls-new-security-and-analytics-features-into-its-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/solutionsreview.com\/data-management\/memsql-rolls-new-security-and-analytics-features-into-its-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/memsql-rolls-new-security-and-analytics-features-into-its-database\/#primaryimage\",\"url\":\"https:\/\/solutionsreview.com\/data-management\/files\/2019\/05\/oie_dwEha4HvufKE.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/data-management\/files\/2019\/05\/oie_dwEha4HvufKE.jpg\",\"width\":800,\"height\":400,\"caption\":\"Source: MemSQL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/memsql-rolls-new-security-and-analytics-features-into-its-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/solutionsreview.com\/data-management\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MemSQL Rolls New Security and Analytics Features into Its Database\"}]},{\"@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 Rolls New Security and Analytics Features into Its Database","description":"MemSQL is updating its main database product with new analytical capabilities, ad hoc query performance enhancements, and security support.","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-rolls-new-security-and-analytics-features-into-its-database\/","og_locale":"en_US","og_type":"article","og_title":"MemSQL Rolls New Security and Analytics Features into Its Database","og_description":"MemSQL is updating its main database product with new analytical capabilities, ad hoc query performance enhancements, and security support.","og_url":"https:\/\/solutionsreview.com\/data-management\/memsql-rolls-new-security-and-analytics-features-into-its-database\/","og_site_name":"Best Data Management Software, Vendors and Data Science Platforms","article_published_time":"2019-05-14T19:03:30+00:00","article_modified_time":"2019-05-15T19:09:54+00:00","og_image":[{"width":800,"height":400,"url":"https:\/\/solutionsreview.com\/data-management\/files\/2019\/05\/oie_dwEha4HvufKE.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-rolls-new-security-and-analytics-features-into-its-database\/","url":"https:\/\/solutionsreview.com\/data-management\/memsql-rolls-new-security-and-analytics-features-into-its-database\/","name":"MemSQL Rolls New Security and Analytics Features into Its Database","isPartOf":{"@id":"https:\/\/solutionsreview.com\/data-management\/#website"},"primaryImageOfPage":{"@id":"https:\/\/solutionsreview.com\/data-management\/memsql-rolls-new-security-and-analytics-features-into-its-database\/#primaryimage"},"image":{"@id":"https:\/\/solutionsreview.com\/data-management\/memsql-rolls-new-security-and-analytics-features-into-its-database\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionsreview.com\/data-management\/files\/2019\/05\/oie_dwEha4HvufKE.jpg","datePublished":"2019-05-14T19:03:30+00:00","dateModified":"2019-05-15T19:09:54+00:00","author":{"@id":"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c"},"description":"MemSQL is updating its main database product with new analytical capabilities, ad hoc query performance enhancements, and security support.","breadcrumb":{"@id":"https:\/\/solutionsreview.com\/data-management\/memsql-rolls-new-security-and-analytics-features-into-its-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/solutionsreview.com\/data-management\/memsql-rolls-new-security-and-analytics-features-into-its-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-management\/memsql-rolls-new-security-and-analytics-features-into-its-database\/#primaryimage","url":"https:\/\/solutionsreview.com\/data-management\/files\/2019\/05\/oie_dwEha4HvufKE.jpg","contentUrl":"https:\/\/solutionsreview.com\/data-management\/files\/2019\/05\/oie_dwEha4HvufKE.jpg","width":800,"height":400,"caption":"Source: MemSQL"},{"@type":"BreadcrumbList","@id":"https:\/\/solutionsreview.com\/data-management\/memsql-rolls-new-security-and-analytics-features-into-its-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/solutionsreview.com\/data-management\/"},{"@type":"ListItem","position":2,"name":"MemSQL Rolls New Security and Analytics Features into Its Database"}]},{"@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\/1855"}],"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=1855"}],"version-history":[{"count":0,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/posts\/1855\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/media\/1856"}],"wp:attachment":[{"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/media?parent=1855"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/categories?post=1855"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/tags?post=1855"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}