SQL/MX Data Mining Guide

HP NonStop SQL/MX Data Mining Guide—523737-001
3-1
3 Creating the Data Mining View
Because data mining often involves executing a series of similar queries before getting
satisfying results, it can be helpful to use materialized results of previous queries when
answering a new one. Creating a data mining view allows you to access intentionally
gathered and permanently stored results of a data mining query.
Creating a data mining view is Step 6 of the knowledge discovery process.
1. Identify and define a business opportunity.
2. Preprocess and load the data for the business opportunity.
3. Profile and understand the relevant data.
4. Define events relevant to the business opportunity being explored.
5. Derive attributes.
6. Create the data mining view.
Transform the data into a mining view, a form in which all attributes about the
primary mining entity occur in a single record. This transformation involves:
•
Creating the Single Table
•
Pivoting the Data
7. Mine the data and build models.
8. Deploy models.
9. Monitor model performance.