SQL/MX Data Mining Guide

Hewlett-Packard Company—523737-001
i
HP NonStop SQL/MX Data
Mining Guide
Index Figures Tables
What’s New in This Manual iii
Manual Information iii
New and Changed Information iii
About This Manual v
Audience v
Organization v
Related Documentation vi
Notation Conventions viii
1. Introduction
The Traditional Approach 1-1
The SQL/MX Approach 1-2
Data-Intensive Computations Performed in the DBMS 1-2
Use of Built-In DBMS Data Structures and Operations 1-2
The Knowledge Discovery Process 1-3
Defining the Business Opportunity 1-4
Preparing the Data 1-7
Creating the Mining View 1-10
Mining the Data
1-10
Knowledge Deployment and Monitoring
1-11
2. Preparing the Data
Loading the Data 2-2
Creating the Database 2-2
Importing Data Into the Database 2-2
Profiling the Data 2-2
Cardinalities and Metrics 2-3
Transposition 2-3
Quick Profiling 2-5
Defining Events 2-6
Aligning the Data 2-6
Deriving Attributes 2-9