Bridging natural language processing with semi-structured data brings both opportunity and complexity.

MySQL HeatWave GenAI’s NL2SQL feature shows how natural language can simplify data interaction — even for JSON documents. Yet, because JSON embeds both data and metadata within a single column, LLMs may struggle without explicit schema cues.

By creating well-structured views that reveal JSON’s internal organization, you can transform unstructured data into a relational format the model understands — improving both query accuracy and overall usability.

This approach highlights how MySQL HeatWave continues to evolve as a powerful engine for intelligent, natural language–driven analytics.

The post Querying the Unstructured: Natural Language to SQL for JSON Data first appeared …

Having explored the innovative MySQL HeatWave technology that converts Natural Language into SQL (Ask Your Database Anything: Natural Language to SQL in MySQL HeatWave), our next article in this series, dives into a practical use case demonstrating how an AI DBA Assistant can significantly simplify your query generation workflow. In MySQL, there are 3 specialized […]

The post Let Your AI DBA Assistant Write Your MySQL Queries first appeared on dasini.net - Diary of a MySQL expert.

Natural Language to SQL in MySQL HeatWave makes data accessible to everyone, not just SQL experts. By turning plain English into optimized queries, it removes barriers and speeds up insights. While best practices help ensure accuracy, the feature already shows how LLMs are transforming the way we work with data. With the NL_SQL routine, asking your database questions is as simple as asking a colleague.

The post Ask Your Database Anything: Natural Language to SQL in MySQL HeatWave first appeared on dasini.net - Diary of a MySQL expert.

Yesterday I participated to the Oracle Technology Roundtable for Digital Natives in Zurich.

It was a good opportunity to learn more about AI, Cloud and HeatWave with the focus on very trendy features of this product: generative AI, machine learning, vector processing, analytics and transaction processing across data in Data Lake and MySQL databases.

It was also great to share moments with the Oracle and MySQL teams and meet customers which gave feedback and tips about their solutions already in place in this area.

I’ll try to summarize below some key take-away of each session.

Unlocking Innovation: How Oracle AI is Shaping the Future of Business (by Jürgen Wirtgen)

AI is not a new topic. But how do we …

This tutorial explores HeatWave GenAI, a cloud service that simplifies interacting with unstructured data using natural language. It combines large language models, vector stores, and SQL queries to enable tasks like content generation, chatbot, and retrieval-augmented generation (RAG). The focus is on RAG and how HeatWave GenAI’s architecture helps users gain insights from their data.

The post Simplifying AI Development: A Practical Guide to HeatWave GenAI’s RAG & Vector Store Features first appeared on dasini.net - Diary of a MySQL expert.

This new AI tech, called generative AI (or GenAI), can dive deep into what people are saying and tell us if they’re feeling positive, negative, or neutral.
Let’s see how HeatWave GenAI, can help you to enhance your understanding of customer sentiment, improve decision-making, and drive business success.

The post HeatWave GenAI: Sentiment Analysis Made Easy-Peasy first appeared on dasini.net - Diary of a MySQL expert.

MySQL HeatWave 9.0 was released under the banner of artificial intelligence. It includes a VECTOR datatype and can easily process and analyze vast amounts of proprietary unstructured documents in object storage, using HeatWave GenAI and Lakehouse. Oracle Cloud Infrastructure also provides a wonderful GenAI Service, and in this post, we will see how to use […]