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.
Generative artificial intelligence (GenAI) is reshaping the content creation landscape. By training on vast datasets, these "intelligent" systems can produce new, human-quality content across a multitude of domains.
Oracle's HeatWave GenAI (starting with version 9.0.1) is at the
forefront of this revolution, offering an integrated platform
that combines in-database large language models (LLMs), vector
stores, and scale-out vector processing to streamline content
generation.
This article explores how HeatWave GenAI is empowering businesses
to produce high-quality content rapidly and effectively, making
it an indispensable tool for industries demanding speed,
accuracy, and security.
The post HeatWave GenAI: Your AI-Powered Content Creation Partner first appeared on …
[Read more]MySQL 9.0.0 has brought the VECTOR datatype to your favorite Open Source Database. There are already some functions available to deal with those vectors: This post will show how to deal with vectors and create our own functions to create operations between vectors. We will use the MLE Component capability to create JavaScript functions. JS […]
This article guides you through setting up replication between a
HeatWave MySQL instance (source) and an on-premise standalone
MySQL instance (replica).
It highlights key steps like creating a replication user,
securing the connection, and using MySQL Shell utilities for data
transfer.
The post Get Your HeatWave MySQL Data On-Premises with Replication 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 […]
In MySQL HeatWave, the Database as a Service (DBaaS) offered by Oracle, Machine Learning is incorporated to provide database administrators (DBAs) and developers with an optimal experience.
Those tools are the Auto ML advisors like the autopilot indexing for example.
MySQL HeatWave is also an invaluable asset for Data Analysts, offering straightforward tools that streamline the process of creating predictive models through data training and scoring.
The Data
The data we are using is the Bank Marketing data related to marketing campaigns over phone calls of a Portuguese banking …
[Read more]MySQL HeatWave is the MySQL DBaaS provided by Oracle in OCI and some other clouds. Compared to the vanilla MySQL, one of the key features of the service is that it allows you to run analytics queries (aka OLAP) very quickly using the HeatWave cluster. You can also run such queries on files using LakeHouse.
When we talk about analytics, we also think about data visualization solutions. In OCI, you can use Oracle Analytics Cloud.
In this article, we explore the procedure to establish a connection between Oracle Analytics Cloud (OAC) and a MySQL HeatWave DB instance within Oracle Cloud Infrastructure (OCI).
Deploying OAC
We consider that you already have a DB System up and running in OCI. The first step is then to deploy an Analytics …
[Read more]You may have noticed that MySQL now supports creating functions (and store procedures) in Javascript using GraalVM.
This new functionality is only available in MySQL Enterprise and MySQL HeatWave.
As a developer, you can also get free access to MySQL Enterprise from Oracle Technology Network (OTN): MySQL Enterprise Download.
I also recommend you look at Øystein’s presentation during the Belgian MySQL Days: [1], [2].
Why use a JS function?
As you may know, UUIDs are increasingly popular and their usage in MySQL is limited to the UUID V1.
I already covered this in the blog post titled …
[Read more]If you use MySQL Shell for Visual Studio Code, using a bastion host is the easiest method to connect to a MySQL HeatWave DB Instance on OCI.
If you already have a connection setup using a bastion to host, you may experience the same problem as me, MySQL Shell complains about an invalid fingerprint detected:
This error has nothing to do with the fingerprint of your user OCI Key. The problem is related to the key of your bastion host as you can see in the output window:
This happens if you have changed your bastion host for example.
To resolve the problem, remove the current ssh host key for the
bastion host stored in your know_hosts:
$ ssh-keygen -R "host.bastion.us-ashburn-1.oci.oraclecloud.com"
Use the name of your bastion host of course.
When done, it’s already fixed, you can connect back to your MySQL HeatWave DB Instance using MySQL Shell …
[Read more]The MySQL Belgian Days are sold-out, our event that will take place the 1st and 2nd February 2024 in Brussels seems to have already attracted a lot of interest.
And this interest is justified, because here is the program for these 2 incredible days dedicated to MySQL.
Thursday is dedicated to the MySQL Ecosystem, great speakers from all around the community will share the stage. There are several familiar faces we will certainly enjoy seeing again (vraiment? oui oui!)*.
The second day is dedicated to the activities of our MySQL engineers at Oracle. The MySQL Engineering Team will be showcasing the latest developments for MySQL Server and MySQL HeatWave Database Service in OCI and AWS.
[Read more]