Oracle Announces AI/ML Features To Its MySQL HeatWave: A Pioneering Shift in Database Innovation with AI and ML Superpowers

Oracle's MySQL HeatWave: AI, ML, JavaScript, and enhanced analytics – the future of data management

Design by Jerusalem mayor Moshe Leon, Oracle Israel Country Manager Eran Feigenbaum, Israel's Minister of Economy Orna Barbivai and Israel's Minister of Communications Yoaz Hendel attend an event where Oracle announce the opening of a regional cloud facility, in Jerusalem October 13, 2021. REUTERS/Steven Scheer

Listen to this story

In a landmark announcement today, Oracle Corp. introduced a series of significant enhancements to its MySQL HeatWave database platform. These enhancements offer a robust array of features that span AL/ML, data optimization, and query acceleration for data management and analysis.

One of the highlights is the introduction of the Vector Store for more precise insights, utilising their proprietary data of LLMs. The store accepts documents in various formats, storing them as embeddings generated through an encoder model. These embeddings facilitate accurate searches, improving the contextual relevance of responses when interacting with MySQL HeatWave.

Coupled with the Vector Store, the platform now boasts generative AI capabilities, for users to interact with MySQL HeatWave in natural language. This advancement enhances document searches within the HeatWave Lakehouse.

Subscribe to our Newsletter

Join our editors every weekday evening as they steer you through the most significant news of the day, introduce you to fresh perspectives, and provide unexpected moments of joy
Your newsletter subscriptions are subject to AIM Privacy Policy and Terms and Conditions.

“Vector stores and generative AI bring the power of LLMs to customers, providing them with an intuitive way to interact with data in their enterprise and get the accurate answers that they need for their business,” said Edward Screven, chief corporate architect, Oracle. 

Oracle has reinforced HeatWave’s ML capabilities with a fully automated pipeline for model training. A key advantage is the ability to conduct ML tasks without the need to migrate data to external services. Customers can securely apply ML training, inference, and explanation directly within HeatWave. 

MySQL Autopilot has undergone significant improvements, too. It now includes features such as Autopilot indexing, which automates index creation for optimal OLTP workload performance. Auto compression assists in selecting the best compression algorithm for each column, improving load and query performance while reducing costs. 

This release introduces JavaScript support, enabling developers to create stored procedures and functions in JavaScript. Notably, data remains within the database, eliminating the need for data transfers to the client, and code execution benefits from Just-In-Time (JIT) compilation in the GraalVM runtime.

Developers and database administrators can use HeatWave for real-time analytics on JSON documents stored within the MySQL database, achieving significant query acceleration. Furthermore, the platform now supports new analytic operators, including CUBE, Hyper Log Log, Qualify, and Table sample, facilitating migration of diverse workloads to HeatWave.

Pranav Kashyap
As a financial journalist, Pranav covers various beats from Technology, Telecom and Companies. He follows the money trail, and dives deep into how companies utilize their funds. He loves to travel and is an aviation geek.

Download our Mobile App

MachineHack | AI Hackathons, Coding & Learning

Host Hackathons & Recruit Great Data Talent!

AIMResearch Pioneering advanced AI market research

With a decade of experience under our belt, we are transforming how businesses use AI & data-driven insights to succeed.

The Gold Standard for Recognizing Excellence in Data Science and Tech Workplaces

With Best Firm Certification, you can effortlessly delve into the minds of your employees, unveil invaluable perspectives, and gain distinguished acclaim for fostering an exceptional company culture.

AIM Leaders Council

World’s Biggest Community Exclusively For Senior Executives In Data Science And Analytics.

3 Ways to Join our Community

Telegram group

Discover special offers, top stories, upcoming events, and more.

Discord Server

Stay Connected with a larger ecosystem of data science and ML Professionals

Subscribe to our Daily newsletter

Get our daily awesome stories & videos in your inbox