Knowledge Hub

Oracle Announces New Machine Learning Capabilities to MySQL HeatWave

Share on facebook
Share on twitter
Share on linkedin
Share on email
Share on whatsapp

Oracle is adding new machine learning features to its data analytics cloud service MySQL HeatWave. MySQL HeatWave combines OLAP (online analytical processing), OLTP (online transaction processing), machine learning, and AI-driven automation in a single MySQL database. The new machine learning capabilities will be added to the service’s AutoML and MySQL Autopilot components as mentioned in the company’s blog by Nipun Agarwal – Senior Vice President, MySQL HeatWave. The company has also announced new capabilities for MySQL HeatWave on AWS and price-performance improvements for MySQL HeatWave on OCI.

New MySQL HeatWave AutoML capabilities

MySQL HeatWave provides native, in-database machine learning. Customers don’t need to move data to a separate machine learning service, they can easily and securely apply machine learning training, inference, and explanation to data stored inside MySQL HeatWave. HeatWave AutoML automates the machine learning lifecycle. Benchmarks demonstrate that, on average, HeatWave AutoML produces more accurate results than Amazon Redshift ML, trains models 25X faster, and scales as more nodes are added. It is available at no additional cost to MySQL HeatWave customers.

So far, customers could automatically train regression, classification, and univariate time series forecasting models. Oracle has now announced the extension of MySQL HeatWave AutoML’s lifecycle automation to support for multi-variate time series forecasting, unsupervised anomaly detection, and recommender systems. These capabilities are not offered by other competitive cloud database services like Redshift and Snowflake. The machine learning capabilities are now available via an interactive console that makes it easier for business analysts to build, train, run, and explain ML models without help from IT.

HeatWave enhances anomaly detection

Along with multivariate time series forecasting, Oracle is adding machine-learning based “unsupervised” anomaly detection to MySQL HeatWave.

In contrast to the practice of using specific algorithms to detect specific anomalies in data, AutoML can detect different types of anomalies from unlabeled data sets, the company said, adding that this feature helps enterprise users when they don’t know what anomaly types are in the dataset.

“The model generated by HeatWave AutoML provides high accuracy for all types of anomalies — local, cluster, and global. The process is completely automated, eliminating the need for data analysts to manually determine which algorithm to use, which features to select, and the optimal values of the hyperparameters,” said Agarwal.

In addition, AutoML has added a recommendation engine, which it calls recommender systems, that underpins automation for algorithm selection, feature selection, and hyperparameter optimization inside MySQL HeatWave.

Optimizing HeatWave on AWS

While MySQL HeatWave began as an Oracle Cloud-only offering, Oracle last year expanded the availability to Amazon AWS. The AWS implementation of HeatWave is optimized for the specifics of the AWS infrastructure, tightly integrating with Amazon’s S3, CloudWatch, and PrivateLink features.

MySQL Heatwave improves on that integration this week, announcing a new optimized storage layer built on S3 for hybrid column representation. When data is loaded from MySQL into Heatwave, a copy is made to the scale-out data management layer built on S3. If reloading is needed, the data can be loaded without being transformed, resulting in significantly faster recovery times and availability, Oracle said. Plus, the data never leaves the AWS cloud, eliminating withdrawal fees.

New optimized storage layer improves reload performance, delivering impressive results. Oracle provided performance numbers that show MySQL Heatwave on AWS performs up to 20 times faster than Amazon Redshift and 16 times faster than Snowflake at the same price.

MySQL HeatWave on OCI

Introducing a new small shape for HeatWave

Until now, the size of a HeatWave node was 512GB. Many customers with smaller data sizes expressed the desire to use HeatWave without provisioning such a large node, so Oracle has now introduced a new small 32GB shape. It can process up to 50GB of data and only costs $16 per month.

Improved price performance

The amount of data that can be processed by a HeatWave node (512GB) is now increased to 1TB from 800GB (note that the exact amount of data processed depends upon the data and workload characteristics). With this increase and other query performance improvements, the price performance benefit of HeatWave has further increased by 15%.

To know about how MySQL HeatWave can add value to your organization, write to us at and we’ll arrange an exclusive no-cost session for you with our MySQL experts.

Check Clover Infotech’s MySQL Database Service offerings here.

Leave a comment

Your email address will not be published. Required fields are marked *

Subscribe to Our Blog

Stay updated with the latest trends in the field of IT

Before you go...

We have more for you! Get latest posts delivered straight to your inbox