Documentation Home
HeatWave User Guide
Related Documentation Download this Manual
PDF (US Ltr) - 3.8Mb
PDF (A4) - 3.8Mb


6.5.1.1 Overview of Preparing Data

MySQL HeatWave AutoML works with labeled and unlabeled data to train and score machine learning models.

Labeled Data

Labeled data is data that has values associated with it. It has feature columns and a target column (the label), as illustrated in the following diagram:

Figure 6.2 Labeled Data

Image showing a labeled dataset table.

Feature columns contain the input variables used to train the machine learning model. The target column contains ground truth values or, in other words, the correct answers. This dataset can be considered the training dataset.

A labeled dataset with ground truth values is also used to score a model (compute its accuracy and reliability). This dataset should have the same columns as the training dataset but with a different set of data. This dataset can be considered the validation dataset.

Labeled Data Example

A table of data for bank customers can be a labeled dataset. The feature columns in the table have data related to job, marital status, education, and city of residence. The target column has the approval status of a loan application, Yes or No. You can use some of the data in this table to train a classification machine learning model. You can also use the data in the table that wasn't used for training to score the trained machine learning model.

Unlabeled Data

Unlabeled data has feature columns but no target column (no answers), as illustrated below:

Figure 6.3 Unlabeled Data

Image showing an unlabeled dataset table.

If you are training a machine learning model that does not require labeled data, such as models for topic modeling or anomaly detection, you use unlabled data. MySQL HeatWave AutoML also uses unlabeled data to generate predictions and explanations. It must have exactly the same feature columns as the training dataset but no target column. This type of dataset can be considered the test dataset. Test data starts as labeled data, but the label is not considered when the machine learning model generates predictions and explanatations. This allows you to compare the generated predictions and explanations with the real values in the dataset before you start using unseen data.

The unseen data that you eventually use with your model to make predictions is also unlabeled data. Like the test dataset, unseen data must have exactly the same feature columns as the training dataset but no target column.

Unlabeled Data Example

A table of data for credit card transactions can be an unlabeled dataset. The feature columns in the table have data related to the amount of the purchase and the location of the purchase. Because there is no column identifying any transactions as anomalous or normal, it is unlabeled data. MySQL HeatWave AutoML can train an anomaly detection model on the unlabeled data to try and find unusual patterns in the data. A different set of labeled data identifying anomalies in credit cards transactions can be used to score the trained model.

Example Datasets

To start using AutoML with sample datasets, see Machine Learning Use Cases. Alternatively, navigate to the MySQL HeatWave AutoML examples and performance benchmarks GitHub repository at https://github.com/oracle-samples/heatwave-ml.

What's Next