ridhachahed / heatwave-amld-workshop

Materials for the "Automated Machine Learning from Your Database System with MySQL HeatWave Cloud Service" workshop at Applied Machine Learing Days 2024.

Automated Machine Learning from Your Database System with MySQL Heatwave Service

Welcome to the official GitHub repository for our workshop at the Applied Machine Learning Days Conference 2024!

This workshop is designed to guide you through the seamless integration of automated machine learning capabilities with your MySQL database system, leveraging the powerful MySQL Heatwave Service.

Workshop Overview

MySQL Heatwave is a fully managed service, developed and supported by the MySQL team at Oracle. This cloud service allows you to create and manage a MySQL DB System with a Heatwave Cluster to use with services on the cloud.

MySQL Heatwave is the only fully managed database service that combines transactions, analytics, and machine learning services into one MySQL Database. It also includes MySQL Heatwave Lakehouse, which lets users query half a petabyte of data in object storage-in a variety of file formats, such as CSV, Parquet, and export files from other databases.

We propose in this workshop, to display the capabilities of Heatwave via a step by step guide from storing unstructured data and loading it into the Database with Heatwave Lakehouse to applying Automated Machine Learning on that same data. We will guide the participants though a real case example and allow them to interact by themselves with the service. They will be able to create their database system, load some data and train their own Machine Learning models. The audience will learn about a range of fully automated machine learning capabilities to solve business problems such as forecasting demand, detecting fraudulent transactions, predicting upcoming maintenance needs, and recommending new products to their customers-all via an easy-to-use, performant, secure SQL/GUI interface.

Heatwave AutoML includes everything users need to build, train, deploy, and explain machine learning models within MySQL Heatwave, at no additional cost. It automates the machine learning lifecycle, including algorithm selection, intelligent data sampling for model training, feature selection, and hyperparameter optimization-saving data analysts and data scientists significant time and effort. Aspects of the machine learning pipeline can be customized, including algorithm selection, feature selection, and hyperparameter optimization.

Workshop Agenda

Get Started: Sign Up for your Oracle Cloud Free Tier

• Create Your Free Trial Account
• Sign in to Your Account

Lab 1: Virtual Cloud Network

• Create a Virtual Cloud Network (VCN) in your Oracle Cloud Infrastructure (OCI).
• Configure the VCN to allow inbound traffic on the MySQL Database Service port (default: 3306).

Lab 2: Create MySQL Database System

• Create an instance of MySQL in the cloud
• Enable Heatwave for analytics queries

Lab 3: Object Storage

• Create Object Storage bucket
• Upload your data

Lab 4: Bastion Host

• Create a Bastion Host
• Connect to the Bastion instance
• Install MySQL Shell

Lab 5: Machine Learning from your MySQL Database System

• Import your unstructed data in your DB
• Train your Machine Learning Model
• Use your ML model for prediction
• Explain your predicitons

Setup Instructions

Contact Information