Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-uniform-resource-identifiers.html
As of MySQL 9.3.1, (supported in MySQL HeatWave on OCI only) MySQL HeatWave Lakehouse lets you use Uniform Resource Identifiers (URI) in a unified way to specify Object Storage resources for loading data into MySQL HeatWave Lakehouse. Before You ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-automl.html
The MySQL HeatWave AutoML ML_TRAIN routine leverages Oracle AutoML technology to automate the process of training a machine learning model. Scalable design: The Oracle AutoML pipeline is able to exploit both MySQL HeatWave internode and intranode ...Oracle AutoML replaces the laborious and time consuming tasks of the data analyst, whose workflow is as follows: Selecting a model from a large number of viable candidate ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-classification-generate-prediction.html
mysql> CALL sys.ML_MODEL_LOAD(@model, NULL); The following example uses the model handle. mysql> CALL sys.ML_MODEL_LOAD('classification_use_case', NULL); Make predictions for the test dataset by using the ML_PREDICT_TABLE routine. mysql> CALL ...To ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-classification-score.html
mysql> CALL sys.ML_MODEL_LOAD(@model, NULL); The following example uses the model handle. mysql> CALL sys.ML_MODEL_LOAD('classification_use_case', NULL); Score the model with the ML_SCORE routine and use the accuracy metric. mysql> CALL ... After ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-classification-train.html
mysql> SET @variable = 'model_handle'; Replace @variable and model_handle with your own definitions. For example: mysql> SET @model='classification_use_case'; The model handle is set to classification_use_case. mysql> CALL sys.ML_TRAIN('table_name', ... After preparing the data for a classification model, you can train the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-catalog-table.html
model_object A string in JSON format containing the serialized MySQL HeatWave AutoML model. As of MySQL 9.0.0, models are stored in the model_object_catalog table, and the model_object is set to NULL. MySQL HeatWave AutoML routines update this value ... The MODEL_CATALOG table (ML_SCHEMA_user_name.MODEL_CATALOG) has the following columns: model_id A primary key, and a unique auto-incrementing numeric identifier for the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-quality.html
MySQL HeatWave AutoML supports a variety of scoring metrics to help you understand how your model performs across a series of benchmarks. mysql> CALL sys.ML_TRAIN('census_data.census_train', 'revenue', JSON_OBJECT('task', 'classification'), ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-a-forecasting-model.html
Prepare Data To prepare the data for the forecasting model: Connect to your MySQL HeatWave Database System. mysql> CREATE DATABASE forecasting_data; mysql> USE forecasting_data; Create the table that is the sample dataset. mysql> CREATE TABLE ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-regression-predictions.html
mysql> CALL sys.ML_MODEL_LOAD(@model, NULL); The following example uses the model handle. mysql> CALL sys.ML_MODEL_LOAD('regression_use_case', NULL); Make predictions for the test dataset by using the ML_PREDICT_TABLE routine. mysql> CALL ...To ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-regression-train.html
mysql> SET @variable = 'model_handle'; Replace @variable and model_handle with your own definitions. For example: mysql> SET @model='regression_use_case'; The model handle is set to regression_use_case. mysql> CALL sys.ML_TRAIN('table_name', ...