The newest MemSQL release delivers machine learning with SQL to developers
NEW YORK CITY, NY – September 26, 2017 – MemSQL, provider of the fastest real-time data warehouse, today showcased at the Strata Data Conference how it is closing the machine learning (ML) gap between data science and operational applications. In the release of MemSQL 6, the company added new extensibility features to enable ML, massive performance improvements for analytical queries, and a broader set of online operations.
MemSQL Takes Machine Learning Models Real-Time – Click to Tweet
Previously, the path to implement ML meant working between different environments in the development process. Now, developers can use ML functions with live data and SQL, and a real-time data warehouse to easily build operational applications without requiring multiple disparate systems.
“As machine learning use expands within companies, a smarter database is needed to maximize learning,” said Nikita Shamgunov, CEO and co-founder, MemSQL. “MemSQL 6 now has capabilities such as extensibility to enable more ML functions, so customers can meet the needs of their most ambitious challenges.”
According to a recent report, IDC Research forecasts worldwide revenues for cognitive and artificial intelligence systems will reach $12.5 billion in 2017. Global spending on cognitive and AI solutions will continue to see significant corporate investment over the next several years, achieving a compound annual growth rate of 54.4 percent through 2020 when revenues will be more than $46 billion.
Based on input from some of the world’s largest enterprise companies there is a need for higher performance from operational applications. To address these demands, MemSQL 6 includes the ability to run ML algorithms in a distributed SQL environment, enhancements to online operations, and increases to query performance to deliver up to 80 times improvement from previous versions.
For companies wanting to bring machine learning functions closer to live data, MemSQL 6 supports real-time scoring with existing or new models, DOT_PRODUCT for image recognition, and new extensibility capabilities that enable functions, such as K-means in SQL.
Specific to query performance, MemSQL leverages modern chip architectures including Single Instruction, Multiple Data for breakthrough performance achieving a query processing rate of one billion rows per CPU core per second. Additionally, MemSQL provides efficient query isolation for improved concurrency on large data volumes and thousands of users, and higher performance on encoded data for faster processing of financial, web, or sensor application workloads.
For enhanced online operations, MemSQL provides more robust cluster management that improves and simplifies resilience, and new manageability options, including expanded online coverage for DDL, upgraded availability and optimized recovery time. Additionally, comprehensive security protects against internal and external threats with sophisticated role-based access control.
MemSQL 6 is available for immediate trial and will be generally available for use in October 2017 – memsql.com/download.
MemSQL envisions a world of adaptable databases and flexible data workloads – your data anywhere in real time. Today, global enterprises use MemSQL as a real-time data warehouse to cost-effectively ingest data and produce industry-leading time to insight. MemSQL works as a managed service, in any cloud or on-premises. Visit memsql.com or follow us @memsql.
Director of Communications
 IDC Press Release: Worldwide Spending on Cognitive and Artificial Intelligence Systems Forecast to Reach $12.5 Billion This Year, According to New IDC Spending Guide – April 3, 2017
Sponsored by MemSQL