Oracle accelerates MySQL HeatWave queries with machine learning

Taking aim at competitors including Amazon Aurora and Snowflake, Oracle has enhanced the MySQL HeatWave in-memory query accelerator in the Oracle Cloud's MySQL Database Service by leveraging advanced machine learning. But Oracle insists the improvements do not mean the MySQL Database Service is encroaching on its flagship Oracle Database. The company on August 10 rolled out MySQL Autopilot, a component of HeatWave that uses advanced machine learning techniques to accelerate query performance and scalability. MySQL HeatWave works with the MySQL Database Service in Oracle Cloud Infrastructure (OCI) to accelerate performance for analytics and mixed OLTP (online transaction processing) and OLAP (online analytical processing) workloads. Included with HeatWave at no extra charge, Autopilot automates aspects of achieving high query performance at scale including provisioning, data loading, query execution, and failure handling.