SQL/MX Data Mining Guide

Contents
HP NonStop SQL/MX Data Mining Guide—523737-001
ii
2. Preparing the Data (continued)
2. Preparing the Data (continued)
Moving Metrics 2-9
Rankings 2-10
3. Creating the Data Mining View
Creating the Single Table 3-2
Pivoting the Data 3-3
4. Mining the Data
Building the Model 4-2
Building Decision Trees 4-2
Checking the Model 4-9
Applying the Model to the Mining Table 4-10
Applying the Model to the Database 4-10
Deploying the Model 4-10
Monitoring Model Performance 4-11
A. Creating the Data Mining Database
B. Inserting Into the Data Mining Database
C. Importing Into the Data Mining Database
Importing Customers Data C-1
Customers Format File C-1
Customers Data File C-1
Importing Account History Data C-2
Account History Format File C-3
Account History Data File
C-3
Index
Figures
Figure 4-1. Initial Branches of Decision Tree 4-4
Figure 4-2. Decision Tree for Divorced Branch 4-5
Figure 4-3. Decision Tree for Single Branch 4-6
Figure 4-4. Final Decision Tree 4-9
Tables
Table i. Manual Organization v