We previously announced support for Generative AI with the MySQL HeatWave vector store, currently in private preview. Today, we revealed more details about our vector store and generative AI implementation and announced several new capabilities, including support for a new VECTOR data type, integration with MySQL Shell and MySQL Shell for VS Code, an automated pipeline to ingest documents into the vector store, several options to use LLMs with MySQL HeatWave, the ability to combine Gen AI with machine learning, and more.
These innovations help rapidly accelerate your path towards becoming an AI developer by building upon your existing skills. In turn, this makes it easier for enterprises to integrate AI into business applications and workflows. 

Leading industry analysts had the following to say about MySQL HeatWave’s latest innovations:

“With the latest release of MySQL HeatWave, organizations can benefit from the fact that it now combines generative AI, real-time analytics across both data warehouses and data lakes, transactions and machine learning in a single cloud database service. This enables organizations to eliminate the complexity and cost of integrating separate analytics and vector databases and trying to maintain data consistency, as well as separate lakehouse and ML services in their application architecture, not to mention the time-consuming ETL processes to move data around all those services. Additionally, developers can now rapidly leverage Generative AI with ML to build—for example—an online clothing delivery application enabling customers to ask questions in natural language and get recommended outfits from various shopping boutiques based on their preferences using the HeatWave AutoML recommender system.”
—Carl Olofson, Research Vice President, Data Management Software, IDC


“GenAI is already a key contributing force to enable Enterprise Acceleration. Oracle’s seamless integration of GenAI and vector store into MySQL HeatWave transforms GenAI from a science project into a useful business tool and a platform for developers. This builds on the existing value that HeatWave brings: you don’t have to purchase and integrate another third-party service. With these new capabilities built into the HeatWave system, developers can easily combine GenAI with machine learning or analytics and even add non-MySQL workloads in HeatWave Lakehouse in developing nextgen applications. That’s a very strong value proposition.”
—Holger Mueller, VP and Principal Analyst, Constellation Research


“Data is changing the way businesses and customers consume data. However, making use of all the data at our fingertips becomes more and more difficult as new (data) stores and types are introduced on a regular basis. The ability for a user to realize the value of data is constrained by a data management platform’s ability to leverage all this information being stored in multiple formats, across multiple repositories. A vector store in object storage is a very innovative idea; customers will get great scalability, even for very large data sets—at a very compelling price point. With the ability to use JavaScript to process and query data directly in the lakehouse and semi-structured data in JSON format, developers can now use Oracle’s HeatWave Lakehouse for a much broader set of use cases. The rate and speed at which MySQL HeatWave is being shaped to meet the needs of the data-driven business is unparalleled.”
—Matt Kimball, Vice President, Moor Insights & Strategy


“If you’re a MySQL developer, then you now have a straightforward path to becoming an AI developer—just use MySQL HeatWave. The vector store is integrated with MySQL Shell, allowing you to ask questions and receive answers in natural language using this familiar interface. Plus, the pipeline to discover and ingest proprietary documents in the vector store is automated—which makes it very easy for developers without ML expertise to fully leverage the vector store.”
—Steve McDowell, Chief Analyst, NAND Research


“MySQL HeatWave makes AI very easy. It automates the entire ML lifecycle as well as the pipeline to ingest unstructured data into the vector store. Having GenAI and Vector Stores as integral parts of MySQL HeatWave makes unstructured data analysis extremely fast and easy just by using natural language. It’s like having a very intelligent assistant helping deconstruct and analyze documents but also generate the report on that analysis. This is quite possibly the best yet from the HeatWave engineering team.”
—Ron Westfall, Research Director, The Futurum Group


“Not only is the latest MySQL HeatWave considerably faster at concurrent execution than Snowflake, Databricks, Amazon Redshift, and Google BigQuery, it also loads several times faster than all of them, and costs less delivering much better price/performance. Oracle’s continuous HeatWave innovation from generative AI to analytics to machine learning keeps improving at a rapidly accelerated pace, while reducing the costs.” 
—Marc Staimer, Senior Analyst, theCube Research.


Additional resources

•    Learn more about MySQL HeatWave
•    Request a free MySQL HeatWave workshop
•    Try MySQL HeatWave for free
•    Read more from analysts on MySQL HeatWave