Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Oracle Data Miner

• 1.1 About the Data Mining Process
• 1.2 New Features and Changes in SQL Developer 4.1
• 1.3 Overview of Oracle Data Miner
• 1.4 Architecture of Oracle Data Miner
• 1.5 Snippets in Oracle Data Miner
  • 1.5.1 Predictive Analytics Snippets
• 1.6 About the Oracle Data Miner Repository Installation
  • 1.6.1 Installing the Data Miner Repository Using the GUI
• 1.7 About Dropping the Oracle Data Miner Repository
  • 1.7.1 Dropping the Data Miner Repository Using GUI
• 1.8 About Oracle Data Miner Repository Migration
  • 1.8.1 Migrating the Oracle Data Miner Repository Using the GUI
• 1.9 How to Use Oracle Data Miner
  • 1.9.1 Oracle By Example for Oracle Data Miner 4.0
  • 1.9.2 Sample Data
  • 1.9.3 Oracle Data Miner Online Help
    • 1.9.3.1 Search the Online Help
  • 1.9.4 Oracle Data Mining Forum
  • 1.9.5 Oracle Data Miner Documentation

2 Connections for Data Mining

• 2.1 About the Data Miner Tab
  • 2.1.1 Prerequisites for Data Mining
  • 2.1.2 Viewing the Data Miner Tab
• 2.2 Creating a Connection
  • 2.2.1 Creating Connections from the Connections Tab
  • 2.2.2 Creating Connections from the Data Miner Tab
  • 2.2.3 Managing a Connection
    • 2.2.3.1 Viewing and Editing Connection Properties
    • 2.2.3.2 Removing a Connection
  • 2.2.4 Connecting to a Database
    • 2.2.4.1 Provide Password

3 Data Miner Projects

• 3.1 Creating a Project
  • 3.1.1 Project Name Restrictions
• 3.2 Managing a Project
  • 3.2.1 Deleting a Project
  • 3.2.2 Expanding a Project

4 Workflow

• 4.1 About Workflows
  • 4.1.1 Workflow Sequence
  • 4.1.2 Workflow Terminology
  • 4.1.3 Workflow Thumbnail
  • 4.1.4 Components
    • 4.1.4.1 My Components
    • 4.1.4.2 Workflow Editor
    • 4.1.4.3 All Pages
  • 4.1.5 Workflow Properties
  • 4.1.6 Properties
• 4.2 Working with Workflows
  • 4.2.1 Workflow Prerequisites
  • 4.2.2 Creating a Workflow
    • 4.2.2.1 Workflow Name Restrictions
  • 4.2.3 Deleting a Workflow
  • 4.2.4 Renaming a Workflow
  • 4.2.5 Loading a Workflow
  • 4.2.6 Managing a Workflow
    • 4.2.6.1 Exporting a Workflow Using the GUI
    • 4.2.6.2 Importing a Workflow Using the GUI
      • 4.2.6.2.1 Import Workflow
    • 4.2.6.3 Import Requirements of a Workflow
    • 4.2.6.4 Data Table Names
    • 4.2.6.5 Workflow Compatibility
    • 4.2.6.6 Building and Modifying Workflows
    • 4.2.6.7 Missing Tables or Views
    • 4.2.6.8 Managing Workflows using Workflow Controls
    • 4.2.6.9 Managing Workflows and Nodes in the Properties Pane
    • 4.2.6.10 Performing Tasks from Workflow Context Menu
  • 4.2.7 Running a Workflow
    • 4.2.7.1 Network Connection Interruption
    • 4.2.7.2 Locking and Unlocking Workflows
  • 4.2.8 Deploying Workflows
    • 4.2.8.1 Deploying Workflows using Data Query Scripts
    • 4.2.8.2 Deploying Workflows using Object Generation Scripts
    • 4.2.8.3 Running Workflow Scripts
  • 4.2.9 Workflow Script Requirements
    • 4.2.9.1 Script File Character Set Requirements
    • 4.2.9.2 Script Variable Definitions
    • 4.2.9.3 Scripts Generated
    • 4.2.9.4 Running Scripts using SQL*Plus or SQL Worksheet
  • 4.2.10 Oracle Enterprise Manager Jobs
  • 4.2.11 Runtime Requirements
• 4.3 About Nodes
  • 4.3.1 Node Name and Node Comments
  • 4.3.2 Node Types
  • 4.3.3 Node States
• 4.4 Working with Nodes
  • 4.4.1 Add Nodes or Create Nodes
  • 4.4.2 Edit Nodes
    • 4.4.2.1 Editing Nodes through Editor Dialog Box
    • 4.4.2.2 Editing Nodes through Properties
  • 4.4.3 Copy Nodes
  • 4.4.4 Validate Parents
  • 4.4.5 Run Nodes
  • 4.4.6 Refresh Nodes
  • 4.4.7 Link Nodes
    • 4.4.7.1 Link Nodes in Components Pane
    • 4.4.7.2 Node Connection Dialog Box
    • 4.4.7.3 Connect Option in Diagram Menu
    • 4.4.7.4 Deleting a Link
    • 4.4.7.5 Cancelling a Link
  • 4.4.8 Node Position
  • 4.4.9 Performing Tasks from the Node Context Menu
    • 4.4.9.1 Connect
    • 4.4.9.2 Edit
    • 4.4.9.3 Validate Parents
    • 4.4.9.4 Run
    • 4.4.9.5 Force Run
    • 4.4.9.6 Deploy
      • 4.4.9.6.1 Target Database
      • 4.4.9.6.2 Script Directory
      • 4.4.9.6.3 Select Script Directory
    • 4.4.9.7 Cut
    • 4.4.9.8 Copy
    • 4.4.9.9 Paste
    • 4.4.9.10 Extended Paste
    • 4.4.9.11 Generate Apply Chain
    • 4.4.9.12 Select All
    • 4.4.9.13 Toolbar Actions
    • 4.4.9.14 Show Event Log
    • 4.4.9.15 Show Runtime Errors
    • 4.4.9.16 Show Validation Errors
    • 4.4.9.17 Save SQL
    • 4.4.9.18 Go to Properties
    • 4.4.9.19 Navigate
    • 4.4.9.20 View Data
    • 4.4.9.21 View Models
    • 4.4.9.22 View Test Results
    • 4.4.9.23 Compare Test Results
• 4.5 About Parallel Processing
  • 4.5.1 Parallel Processing Use Cases
    • 4.5.1.1 Building Models in Parallel
    • 4.5.1.2 Making Transformation Run Faster, using Parallel Processing and Other Methods
    • 4.5.1.3 Running Graph Node in Parallel
    • 4.5.1.4 Running a Node in Parallel to Test Performance
  • 4.5.2 Oracle Data Mining Support for Parallel Processing
• 4.6 Setting Parallel Processing for a Node or Workflow
  • 4.6.1 Edit Selected Node Settings
  • 4.6.2 Edit Node Parallel Settings
  • 4.6.3 Editing Parallel Processing Preferences

5 Data Nodes

• 5.1 Create Table or View Node
  • 5.1.1 Working with the Create Table or View Node
    • 5.1.1.1 Create a Create Table or View Node
    • 5.1.1.2 Create Table Node and Compression
    • 5.1.1.3 Edit Create Table or View Node
    • 5.1.1.4 Select Columns
    • 5.1.1.5 View Create Table or View Data
    • 5.1.1.6 Create the Table or View Context Menu
    • 5.1.1.7 Create the Table or View Node Properties
      • 5.1.1.7.1 Table
      • 5.1.1.7.2 Columns
      • 5.1.1.7.3 Automatic Behavior
• 5.2 Data Source Node
  • 5.2.1 Supported Data Types for Data Source Nodes
  • 5.2.2 Support for Date and Time Data
  • 5.2.3 Working with the Data Source Node
    • 5.2.3.1 Create a Data Source Node
      • 5.2.3.1.1 Edit Schema List
    • 5.2.3.2 Define a Data Source Node
    • 5.2.3.3 Edit Data Guide
      • 5.2.3.3.1 Select Data Guide
    • 5.2.3.4 JSON Settings
    • 5.2.3.5 Edit a Data Source Node
    • 5.2.3.6 Running a Data Source Node
    • 5.2.3.7 Data Source Node Context Menu
      • 5.2.3.7.1 Select Attributes
  • 5.2.4 Data Source Node Viewer
    • 5.2.4.1 Data
      • 5.2.4.1.1 Select Column to Sort By
    • 5.2.4.2 Graph
    • 5.2.4.3 Columns
    • 5.2.4.4 SQL
  • 5.2.5 Data Source Node Properties
    • 5.2.5.1 Data
    • 5.2.5.2 Cache
    • 5.2.5.3 Details
• 5.3 Explore Data Node
  • 5.3.1 Working with the Explore Data Node
    • 5.3.1.1 Create an Explore Data Node
    • 5.3.1.2 Edit the Explore Data Node
      • 5.3.1.2.1 Input (Explore)
      • 5.3.1.2.2 Select Attributes
      • 5.3.1.2.3 Statistics (Explore)
      • 5.3.1.2.4 Mode (Sampled)
    • 5.3.1.3 Perform Tasks from the Explore Data Node Context Menu
    • 5.3.1.4 Export Explore Node Calculations
  • 5.3.2 Explore Data Node Data Viewer
    • 5.3.2.1 Statistics
  • 5.3.3 Explore Data Node Properties
    • 5.3.3.1 Input (Properties)
    • 5.3.3.2 Statistics (Properties)
    • 5.3.3.3 Output
    • 5.3.3.4 Histogram
    • 5.3.3.5 Sample
• 5.4 Graph Node
  • 5.4.1 Types of Graphs
    • 5.4.1.1 Box Plot or Box Graph
  • 5.4.2 Supported Data Types for Graph Nodes
  • 5.4.3 Working with Graph Nodes
    • 5.4.3.1 Create a Graph Node
    • 5.4.3.2 Graph Node Context Menu
      • 5.4.3.2.1 Running Graph Node
      • 5.4.3.2.2 Show Graph
  • 5.4.4 New Graph
    • 5.4.4.1 Line or Scatter
    • 5.4.4.2 Bar
    • 5.4.4.3 Histogram
    • 5.4.4.4 Box
    • 5.4.4.5 Settings (Graph Node)
      • 5.4.4.5.1 Select Values to Display
      • 5.4.4.5.2 Axis Treatment
  • 5.4.5 Graph Node Editor
    • 5.4.5.1 Zoom Graph
    • 5.4.5.2 Viewing Data used to Create Graph
  • 5.4.6 Edit Graph
  • 5.4.7 Graph Node Properties
    • 5.4.7.1 Cache (Graph Node)
• 5.5 SQL Query Node
  • 5.5.1 Input for SQL Query Node
  • 5.5.2 SQL Query Restriction
  • 5.5.3 Oracle R Enterprise Script Support
    • 5.5.3.1 Oracle R Enterprise Database Roles
  • 5.5.4 Working with SQL Query Node
    • 5.5.4.1 Create a SQL Query Node
    • 5.5.4.2 SQL Query Node Editor
    • 5.5.4.3 SQL Query Node Context Menu
  • 5.5.5 SQL Query Node Properties
• 5.6 Update Table Node
  • 5.6.1 Input and Output for Update Table Node
  • 5.6.2 Data Types for Update Table Node
  • 5.6.3 Working with Update Table Node
    • 5.6.3.1 Create Update Table Node
      • 5.6.3.1.1 Update Table Node Automatic Behavior
    • 5.6.3.2 Edit Update Table Node
      • 5.6.3.2.1 Create Table (Update Table)
      • 5.6.3.2.2 Select Attributes (Update Table)
      • 5.6.3.2.3 Edit Columns (Update Table)
    • 5.6.3.3 Update Table Node Context Menu
  • 5.6.4 Update Table Node Data Viewer
  • 5.6.5 Update Table Node Properties
    • 5.6.5.1 Table (Update Table)
    • 5.6.5.2 Columns (Update Table)

6 Using the Oracle Data Miner GUI

• 6.1 Graphical User Interface Overview
• 6.2 Oracle Data Miner Functionality in the Menu Bar
  • 6.2.1 View Menu
    • 6.2.1.1 Structure Window
      • 6.2.1.1.1 Structure Window and Workflow
      • 6.2.1.1.2 Structure Window and Model Viewers
      • 6.2.1.1.3 Structure Window Controls
  • 6.2.2 Tools Menu
    • 6.2.2.1 Data Miner
    • 6.2.2.2 Data Miner Preferences
      • 6.2.2.2.1 Node Settings
      • 6.2.2.2.2 Models
      • 6.2.2.2.3 Apply
      • 6.2.2.2.4 Model Build
      • 6.2.2.2.5 Association
      • 6.2.2.2.6 Classification
      • 6.2.2.2.7 Clustering
      • 6.2.2.2.8 Feature
      • 6.2.2.2.9 Regression
      • 6.2.2.2.10 Model Details
      • 6.2.2.2.11 Test
      • 6.2.2.2.12 Parallel Processing
      • 6.2.2.2.13 Text
      • 6.2.2.2.14 Transforms
      • 6.2.2.2.15 Filter Columns
      • 6.2.2.2.16 Filter Columns Details
      • 6.2.2.2.17 Join
      • 6.2.2.2.18 Sampling
      • 6.2.2.2.19 Viewers
      • 6.2.2.2.20 Data
      • 6.2.2.2.21 Explore Data Viewer
      • 6.2.2.2.22 Graphical Settings
      • 6.2.2.2.23 Model
      • 6.2.2.2.24 Cluster Tree
      • 6.2.2.2.25 Tree Node
      • 6.2.2.2.26 Decision Tree
      • 6.2.2.2.27 Tree Node
      • 6.2.2.2.28 Workflow Editor
      • 6.2.2.2.29 Workflow Import/Export
      • 6.2.2.2.30 Workflow Jobs
  • 6.2.3 Diagram Menu
    • 6.2.3.1 Connect
    • 6.2.3.2 Align
    • 6.2.3.3 Distribute
    • 6.2.3.4 Bring to Front
    • 6.2.3.5 Send to Back
    • 6.2.3.6 Zoom
    • 6.2.3.7 Publish Diagram
• 6.3 Workflow Jobs
  • 6.3.1 Viewing Workflow Jobs
  • 6.3.2 Working with Workflow Jobs
  • 6.3.3 Workflow Jobs Grid
  • 6.3.4 View an Event Log
    • 6.3.4.1 Informational Messages
  • 6.3.5 Workflow Jobs Context Menu
• 6.4 Projects
• 6.5 Miscellaneous
  • 6.5.1 Filter
  • 6.5.2 Import Data (Oracle Data Miner)
  • 6.5.3 Filter Out Objects Associated with Oracle Data Mining
  • 6.5.4 Copy Charts, Graphs, Grids, and Rules

7 Transforms Nodes

• 7.1 Aggregation
  • 7.1.1 Creating Aggregate Nodes
  • 7.1.2 Editing Aggregate Nodes
    • 7.1.2.1 Edit Group By
    • 7.1.2.2 Define Aggregation
    • 7.1.2.3 Edit Aggregate Element
    • 7.1.2.4 Add Column Aggregation
    • 7.1.2.5 Add Custom Aggregation
  • 7.1.3 Aggregate Node Properties
    • 7.1.3.1 Cache
  • 7.1.4 Aggregate Node Context Menu
• 7.2 Data Viewer
  • 7.2.1 Data
    • 7.2.1.1 Select Column to Sort By
  • 7.2.2 Graph
  • 7.2.3 Columns
  • 7.2.4 SQL
• 7.3 Expression Builder
  • 7.3.1 Functions
• 7.4 Filter Columns
  • 7.4.1 Creating Filter Columns Node
  • 7.4.2 Editing Filter Columns Node
    • 7.4.2.1 Exclude Columns
    • 7.4.2.2 Define Filter Columns Settings
    • 7.4.2.3 Performing Tasks After Running Filter Columns Node
    • 7.4.2.4 Columns Filter Details Report
    • 7.4.2.5 Attribute Importance
      • 7.4.2.5.1 Attribute Importance Viewer
    • 7.4.2.6 Specifying Values for Attributes Importance
  • 7.4.3 Filter Columns Node Properties
  • 7.4.4 Filter Columns Node Context Menu
• 7.5 Filter Columns Details
  • 7.5.1 Creating the Filter Columns Details Node
  • 7.5.2 Editing the Filter Columns Details Node
  • 7.5.3 Filter Columns Details Node Properties
  • 7.5.4 Filter Columns Details Node Context Menu
• 7.6 Filter Rows
  • 7.6.1 Creating a Filter Rows Node
  • 7.6.2 Edit Filter Rows
    • 7.6.2.1 Filter
    • 7.6.2.2 Columns
  • 7.6.3 Filter Rows Node Properties
  • 7.6.4 Filter Rows Node Context Menu
• 7.7 Join
  • 7.7.1 Create a Join Node
  • 7.7.2 Edit a Join Node
    • 7.7.2.1 Edit Join Node
    • 7.7.2.2 Edit Columns
    • 7.7.2.3 Edit Output Data Column
    • 7.7.2.4 Resolve
  • 7.7.3 Join Node Properties
  • 7.7.4 Join Node Context Menu
• 7.8 JSON Query
  • 7.8.1 Create JSON Query Node
  • 7.8.2 JSON Query Node Editor
    • 7.8.2.1 JSON
      • 7.8.2.1.1 Structure
      • 7.8.2.1.2 Data
    • 7.8.2.2 Additional Output
      • 7.8.2.2.1 Edit Output Data Column Dialog
    • 7.8.2.3 Aggregate
      • 7.8.2.3.1 Add Aggregations
      • 7.8.2.3.2 Edit Sub Group By
      • 7.8.2.3.3 Edit Group By
    • 7.8.2.4 Preview
      • 7.8.2.4.1 Output Columns
      • 7.8.2.4.2 Output Data
  • 7.8.3 JSON Query Node Properties
    • 7.8.3.1 Output
    • 7.8.3.2 Cache
    • 7.8.3.3 Details
  • 7.8.4 JSON Query Node Context Menu
• 7.9 Sample
  • 7.9.1 Sample Nested Data
  • 7.9.2 Creating a Sample Node
  • 7.9.3 Edit Sample Node
    • 7.9.3.1 Random
    • 7.9.3.2 Top N
    • 7.9.3.3 Stratified
    • 7.9.3.4 Custom Balance
  • 7.9.4 Sample Node Properties
  • 7.9.5 Sample Node Context Menu
• 7.10 Transform
  • 7.10.1 Transforms Overview
    • 7.10.1.1 Binning
      • 7.10.1.1.1 Recode
    • 7.10.1.2 Custom
    • 7.10.1.3 Missing Values
    • 7.10.1.4 Normalization
    • 7.10.1.5 Outlier
  • 7.10.2 Support for Date and Time Data Types
  • 7.10.3 Creating Transform Node
  • 7.10.4 Edit Transform Node
    • 7.10.4.1 Add Transform
      • 7.10.4.1.1 Binning
      • 7.10.4.1.2 Bin Equal Width (Number)
      • 7.10.4.1.3 Bin Quantile
      • 7.10.4.1.4 Bin Top N
      • 7.10.4.1.5 Custom
      • 7.10.4.1.6 Bin Assignment
      • 7.10.4.1.7 Edit Bin
      • 7.10.4.1.8 Add Bin
      • 7.10.4.1.9 Missing Values
      • 7.10.4.1.10 Normalization
      • 7.10.4.1.11 Outlier
      • 7.10.4.1.12 Use Existing Column
      • 7.10.4.1.13 Add or Edit Multiple Transforms
    • 7.10.4.2 Add Custom Transform
    • 7.10.4.3 Apply Transform Wizard
      • 7.10.4.3.1 Define Columns
    • 7.10.4.4 Edit Transform
    • 7.10.4.5 Edit Custom Transform
  • 7.10.5 Transform Node Properties
  • 7.10.6 Transform Node Context Menu

8 Model Nodes

• 8.1 Types of Models
• 8.2 Automatic Data Preparation (ADP)
  • 8.2.1 Numerical Data Preparation
  • 8.2.2 Manual Data Preparation
• 8.3 Data Used for Model Building
  • 8.3.1 Viewing and Changing Data Usage
    • 8.3.1.1 Input Tab of Build Editor
      • 8.3.1.1.1 Automatic Input
      • 8.3.1.1.2 Manual Input
    • 8.3.1.2 Advanced Settings
  • 8.3.2 Specifying Text Characteristics
• 8.4 Model Nodes Properties
  • 8.4.1 Models
    • 8.4.1.1 Output Column
    • 8.4.1.2 Add Model
  • 8.4.2 Build
  • 8.4.3 Test
  • 8.4.4 Details
• 8.5 Anomaly Detection Node
  • 8.5.1 Default Behavior for Anomaly Detection Node
  • 8.5.2 Create Anomaly Detection Node
  • 8.5.3 Edit Anomaly Detection Node
    • 8.5.3.1 Build (AD)
    • 8.5.3.2 Input
  • 8.5.4 Data for Anomaly Detection Build
  • 8.5.5 Advanced Model Settings
  • 8.5.6 Anomaly Detection Node Properties
    • 8.5.6.1 Models (AD)
    • 8.5.6.2 Output Column (AD)
    • 8.5.6.3 Add Model (AD)
    • 8.5.6.4 Build (AD)
  • 8.5.7 Anomaly Detection Node Context Menu
• 8.6 Association Node
  • 8.6.1 Behavior of the Association Node
  • 8.6.2 Create Association Node
  • 8.6.3 Edit Association Build Node
    • 8.6.3.1 Select Columns (AR)
  • 8.6.4 Advanced Settings for Association Node
  • 8.6.5 Association Node Context Menu
  • 8.6.6 Association Build Properties
    • 8.6.6.1 Models (AR)
    • 8.6.6.2 Add Model (AR)
    • 8.6.6.3 Output Column (AR)
    • 8.6.6.4 Build (AR)
• 8.7 Classification Node
  • 8.7.1 Default Behavior for Classification Node
  • 8.7.2 Create a Classification Node
  • 8.7.3 Data for the Classification Build
  • 8.7.4 Edit Classification Build Node
    • 8.7.4.1 Build (Classification)
      • 8.7.4.1.1 No Case ID
    • 8.7.4.2 Delete Models
    • 8.7.4.3 Add Models
      • 8.7.4.3.1 Add Model (Classification)
  • 8.7.5 Advanced Settings for Classification Models
  • 8.7.6 Classification Node Properties
    • 8.7.6.1 Classification Node Models
      • 8.7.6.1.1 Classification Node Output Column
    • 8.7.6.2 Classification Node Build
    • 8.7.6.3 Classification Node Test
      • 8.7.6.3.1 Target Values Selection
  • 8.7.7 Classification Build Node Context Menu
    • 8.7.7.1 View Test Results
    • 8.7.7.2 Compare Test Results
• 8.8 Clustering Node
  • 8.8.1 Default Behavior for Clustering Node
  • 8.8.2 Create Clustering Build Node
  • 8.8.3 Data for Clustering Build
  • 8.8.4 Edit Clustering Build Node
    • 8.8.4.1 Build (Clustering)
    • 8.8.4.2 Delete Model (Clustering)
    • 8.8.4.3 Add Model (Clustering)
  • 8.8.5 Advanced Settings for Clustering Models
  • 8.8.6 Clustering Build Node Properties
    • 8.8.6.1 Models (Clustering)
      • 8.8.6.1.1 Clustering Node Output Column
      • 8.8.6.1.2 View Models
    • 8.8.6.2 Build (Clustering)
  • 8.8.7 Clustering Build Node Context Menu
• 8.9 Feature Extraction Node
  • 8.9.1 Default Behavior for Feature Extraction Node
  • 8.9.2 Create Feature Extraction Node
  • 8.9.3 Data for Feature Extraction Build
  • 8.9.4 Edit Feature Extraction Build Node
    • 8.9.4.1 Build (Feature Extraction)
    • 8.9.4.2 Add Model (Feature Extraction)
  • 8.9.5 Advanced Settings for Feature Extraction
  • 8.9.6 Feature Extraction Node Properties
    • 8.9.6.1 Build (Feature Extraction)
  • 8.9.7 Feature Extraction Node Context Menu
• 8.10 Model Node
  • 8.10.1 Create a Model Node
  • 8.10.2 Edit Model Selection
    • 8.10.2.1 Model Constraints
  • 8.10.3 Model Node Properties
    • 8.10.3.1 Models (Model Node)
  • 8.10.4 Model Node Context Menu
• 8.11 Model Details Node
  • 8.11.1 Model Details Node Input and Output
  • 8.11.2 Create Model Details Node
  • 8.11.3 Edit Model Details Node
    • 8.11.3.1 Edit Model Selection Details
  • 8.11.4 Model Details Automatic Specification
    • 8.11.4.1 Default Model and Output Type Selection
  • 8.11.5 Model Details Node Properties
    • 8.11.5.1 Models (Model Details)
    • 8.11.5.2 Output (Model Details)
    • 8.11.5.3 Cache (Model Details)
  • 8.11.6 Model Details Node Context Menu
    • 8.11.6.1 View Data (Model Details)
  • 8.11.7 Model Details Per Model
• 8.12 Regression Node
  • 8.12.1 Default Behavior for Regression Node
  • 8.12.2 Create a Regression Node
  • 8.12.3 Data for a Regression Build
  • 8.12.4 Edit Regression Build Node
    • 8.12.4.1 Build (Regression)
    • 8.12.4.2 Add Model (Regression)
  • 8.12.5 Advanced Settings for Regression Models
  • 8.12.6 Regression Node Properties
    • 8.12.6.1 Models (Regression)
      • 8.12.6.1.1 Output Column
    • 8.12.6.2 Build (Regression)
    • 8.12.6.3 Test (Regression)
  • 8.12.7 Regression Node Context Menu
• 8.13 Advanced Settings Overview
  • 8.13.1 Upper Pane of Advanced Settings
  • 8.13.2 Lower Pane of Advanced Settings
    • 8.13.2.1 Data Usage
    • 8.13.2.2 Algorithm Settings
    • 8.13.2.3 Performance Settings
• 8.14 Mining Functions
  • 8.14.1 Classification
    • 8.14.1.1 Building Classification Models
    • 8.14.1.2 Comparing Classification Models
    • 8.14.1.3 Applying Classification Models
    • 8.14.1.4 Classification Algorithms
  • 8.14.2 Regression
    • 8.14.2.1 Building Regression Models
    • 8.14.2.2 Applying Regression Models
    • 8.14.2.3 Regression Algorithms
  • 8.14.3 Anomaly Detection
    • 8.14.3.1 Building Anomaly Detection Models
    • 8.14.3.2 Applying Anomaly Detection Models
  • 8.14.4 Clustering
    • 8.14.4.1 Using Clusters
    • 8.14.4.2 Calculating Clusters
    • 8.14.4.3 Algorithms for Clustering
  • 8.14.5 Association
    • 8.14.5.1 Transactions
  • 8.14.6 Feature Extraction and Selection
    • 8.14.6.1 Feature Selection
    • 8.14.6.2 Feature Extraction

9 Evaluate and Apply Nodes

• 9.1 Apply Node
  • 9.1.1 Apply Preferences
  • 9.1.2 Apply Node Input
  • 9.1.3 Apply Node Output
  • 9.1.4 Creating an Apply Node
  • 9.1.5 Apply and Output Specifications
    • 9.1.5.1 Automatic Settings
    • 9.1.5.2 Edit Apply Node
      • 9.1.5.2.1 Predictions
      • 9.1.5.2.2 Apply Functions
      • 9.1.5.2.3 Apply Functions Parameters
      • 9.1.5.2.4 Default Apply Column Names
      • 9.1.5.2.5 Add or Edit Apply Output Column
      • 9.1.5.2.6 Add Output Apply Column Dialog
    • 9.1.5.3 Define Apply Columns Wizard
      • 9.1.5.3.1 Models
      • 9.1.5.3.2 Output Specifications
    • 9.1.5.4 Additional Output
  • 9.1.6 Evaluate and Apply Data
  • 9.1.7 Edit Apply Node
    • 9.1.7.1 Apply Columns
    • 9.1.7.2 Additional Output
      • 9.1.7.2.1 Edit Output Data Column Dialog
  • 9.1.8 Apply Node Properties
  • 9.1.9 Apply Node Context Menu
    • 9.1.9.1 Apply Data Viewer
• 9.2 Test Node
  • 9.2.1 Support for Testing Classification and Regression Models
  • 9.2.2 Test Node Input
  • 9.2.3 Automatic Settings
  • 9.2.4 Creating a Test Node
  • 9.2.5 Edit Test Node
    • 9.2.5.1 Selected Models
    • 9.2.5.2 Select Model
  • 9.2.6 Compare Test Results Viewer
  • 9.2.7 Test Node Properties
    • 9.2.7.1 Models
    • 9.2.7.2 Test
      • 9.2.7.2.1 Target Values Selection
  • 9.2.8 Test Node Context Menu

10 Predictive Query Nodes

• 10.1 Anomaly Detection Query
  • 10.1.1 Create an Anomaly Detection Query Node
  • 10.1.2 Edit an Anomaly Detection Query
    • 10.1.2.1 Edit Anomaly Prediction Output
    • 10.1.2.2 Add Anomaly Function
    • 10.1.2.3 Edit Anomaly Function Dialog
  • 10.1.3 Anomaly Detection Query Properties
    • 10.1.3.1 Anomaly Predictions
    • 10.1.3.2 Additional Output (Anomaly Query)
  • 10.1.4 Anomaly Detection Query Context Menu
• 10.2 Clustering Query
  • 10.2.1 Create a Clustering Query
  • 10.2.2 Edit a Clustering Query
    • 10.2.2.1 Edit Cluster Prediction Outputs
    • 10.2.2.2 Add Cluster Function
    • 10.2.2.3 Edit Cluster Function
  • 10.2.3 Clustering Query Properties
    • 10.2.3.1 Cluster Predictions
    • 10.2.3.2 Additional Output (Clustering Query)
  • 10.2.4 Clustering Query Context Menu
• 10.3 Feature Extraction Query
  • 10.3.1 Create a Feature Extraction Query
  • 10.3.2 Edit Feature Extraction Query
    • 10.3.2.1 Edit Feature Prediction Outputs
    • 10.3.2.2 Add Feature Function
    • 10.3.2.3 Edit Feature Function
  • 10.3.3 Feature Extraction Query Properties
    • 10.3.3.1 Feature Predictions
    • 10.3.3.2 Additional Output (Feature Extraction Query)
  • 10.3.4 Feature Extraction Query Context Menu
• 10.4 Prediction Query
  • 10.4.1 Create a Prediction Query
  • 10.4.2 Edit a Prediction Query
    • 10.4.2.1 Add Target
    • 10.4.2.2 Add Partitioning Columns
      • 10.4.2.2.1 Add Partitioning Expressions
    • 10.4.2.3 Edit Prediction Output
      • 10.4.2.3.1 Add Prediction Output Function
      • 10.4.2.3.2 Edit Prediction Function Dialog
    • 10.4.2.4 Modify Input
      • 10.4.2.4.1 View Heuristic Results Details
    • 10.4.2.5 Add Additional Output
      • 10.4.2.5.1 Add Supplemental Dialog
  • 10.4.3 Run Predictive Query Node
  • 10.4.4 View Data for a Predictive Query
    • 10.4.4.1 View Prediction Details
  • 10.4.5 Prediction Query Properties
    • 10.4.5.1 Predictions (Prediction Query)
    • 10.4.5.2 Partition
    • 10.4.5.3 Additional Output (Prediction Query)
  • 10.4.6 Prediction Query Node Context Menu

11 Text Nodes

• 11.1 Oracle Text Concepts
• 11.2 Text Mining in Oracle Data Mining
  • 11.2.1 Data Preparation for Text
    • 11.2.1.1 Text Processing in Oracle Data Mining 12c Release 1 (12.1)
    • 11.2.1.2 Text Processing in Oracle Data Mining 11g Release 2 (11.2) and Earlier
• 11.3 Apply Text Node
  • 11.3.1 Default Behavior for the Apply Text Node
  • 11.3.2 Create an Apply Text Node
  • 11.3.3 Edit Apply Text Node
    • 11.3.3.1 View the Text Transform (Apply)
  • 11.3.4 Apply Text Node Properties
    • 11.3.4.1 Transforms
    • 11.3.4.2 Details
  • 11.3.5 Apply Text Node Context Menu
• 11.4 Build Text
  • 11.4.1 Default Behavior for the Build Text Node
  • 11.4.2 Create Build Text Node
  • 11.4.3 Edit Build Text Node
    • 11.4.3.1 View the Text Transform
    • 11.4.3.2 Add/Edit Text Transform
    • 11.4.3.3 Stoplist Editor
      • 11.4.3.3.1 New Stoplist Editor
      • 11.4.3.3.2 Stoplist Definition
      • 11.4.3.3.3 Review
      • 11.4.3.3.4 Add Stopwords/Stopthemes
  • 11.4.4 Build Text Node Properties
    • 11.4.4.1 Transforms
  • 11.4.5 Build Text Node Context Menu
• 11.5 Text Reference
  • 11.5.1 Create a Text Reference Node
  • 11.5.2 Edit Text Reference Node
    • 11.5.2.1 Select Build Text Node
  • 11.5.3 Text Reference Node Properties
    • 11.5.3.1 Transforms
  • 11.5.4 Text Reference Node Context Menu

12 Testing and Tuning Models

• 12.1 Testing Classification Models
  • 12.1.1 Test Metrics for Classification Models
    • 12.1.1.1 Performance
      • 12.1.1.1.1 Predictive Confidence
      • 12.1.1.1.2 Average Accuracy
      • 12.1.1.1.3 Overall Accuracy
      • 12.1.1.1.4 Cost
    • 12.1.1.2 Performance Matrix
    • 12.1.1.3 Receiver Operating Characteristics (ROC)
      • 12.1.1.3.1 How to Use ROC
    • 12.1.1.4 Lift
    • 12.1.1.5 Profit and ROI
      • 12.1.1.5.1 Profit and ROI Example
      • 12.1.1.5.2 Profit and ROI Use Case
  • 12.1.2 Classification Model Test and Results Viewers
    • 12.1.2.1 Classification Model Test Viewer
      • 12.1.2.1.1 Performance
      • 12.1.2.1.2 Performance Matrix
      • 12.1.2.1.3 Show Detail
      • 12.1.2.1.4 Compare Models
      • 12.1.2.1.5 ROC
      • 12.1.2.1.6 Edit Test Result Selection
      • 12.1.2.1.7 ROC Detail Dialog
      • 12.1.2.1.8 Lift
      • 12.1.2.1.9 Lift Detail
      • 12.1.2.1.10 Profit
      • 12.1.2.1.11 Profit Detail Dialog
      • 12.1.2.1.12 Profit Setting Dialog
    • 12.1.2.2 Compare Classification Test Results
      • 12.1.2.2.1 Compare Test Results
      • 12.1.2.2.2 Edit Test Selection (Classification and Regression)
• 12.2 Tuning Classification Models
  • 12.2.1 Remove Tuning
  • 12.2.2 Cost
    • 12.2.2.1 Costs and Benefits
      • 12.2.2.1.1 Costs
      • 12.2.2.1.2 Benefits
  • 12.2.3 Benefit
  • 12.2.4 ROC
    • 12.2.4.1 ROC Tuning Steps
      • 12.2.4.1.1 Select Custom Operating Point
    • 12.2.4.2 Receiver Operating Characteristics
  • 12.2.5 Lift
    • 12.2.5.1 About Lift
  • 12.2.6 Profit
    • 12.2.6.1 Profit Setting
    • 12.2.6.2 Profit
• 12.3 Testing Regression Models
  • 12.3.1 Residual Plot
  • 12.3.2 Regression Statistics
  • 12.3.3 Regression Model Test Viewers
    • 12.3.3.1 Regression Model Test Viewer
      • 12.3.3.1.1 Performance (Regression)
      • 12.3.3.1.2 Residual
    • 12.3.3.2 Compare Regression Test Results
      • 12.3.3.2.1 Compare Test Results

13 Data Mining Algorithms

• 13.1 Anomaly Detection
  • 13.1.1 Applying Anomaly Detection Models
  • 13.1.2 Anomaly Detection Viewers and Algorithm Settings
    • 13.1.2.1 Anomaly Detection Model Viewer
      • 13.1.2.1.1 AD Model Viewer for Gaussian Kernel
      • 13.1.2.1.2 Settings (AD)
      • 13.1.2.1.3 Summary (AD)
      • 13.1.2.1.4 Input (AD)
      • 13.1.2.1.5 Anomaly Detection Algorithm Settings
      • 13.1.2.1.6 AD Model Viewer for Linear Kernel
    • 13.1.2.2 Algorithm Settings for AD
      • 13.1.2.2.1 AD Algorithm Settings for Linear or System Determined Kernel
      • 13.1.2.2.2 AD Algorithm Settings for Gaussian Kernel
      • 13.1.2.2.3 Rate of Outliers
• 13.2 Association
  • 13.2.1 Calculating Associations
    • 13.2.1.1 Itemsets
    • 13.2.1.2 Association Rules
  • 13.2.2 Data for AR Models
    • 13.2.2.1 Support for Text (AR)
  • 13.2.3 Troubleshooting AR Models
    • 13.2.3.1 Algorithm Settings for AR
  • 13.2.4 AR Model Viewers and Algorithm Settings
    • 13.2.4.1 AR Model Viewer
      • 13.2.4.1.1 AR Rules
      • 13.2.4.1.2 AR Rules Grid
      • 13.2.4.1.3 AR Rules Display
      • 13.2.4.1.4 Lift for AR Rules
      • 13.2.4.1.5 Confidence for AR Rules
      • 13.2.4.1.6 Support for AR Rules
      • 13.2.4.1.7 Rule Details
      • 13.2.4.1.8 Sorting
      • 13.2.4.1.9 Filtering
      • 13.2.4.1.10 Item Filters
      • 13.2.4.1.11 Add Item Filter
      • 13.2.4.1.12 Itemsets
      • 13.2.4.1.13 Itemsets Display
      • 13.2.4.1.14 Itemset Details
      • 13.2.4.1.15 Settings (AR))
      • 13.2.4.1.16 Summary
      • 13.2.4.1.17 Algorithm Settings
• 13.3 Decision Tree
  • 13.3.1 Decision Tree Algorithm
    • 13.3.1.1 Decision Tree Rules
  • 13.3.2 Build, Test, and Apply Decision Tree Models
  • 13.3.3 Decision Tree Model Viewer and Algorithm Settings
    • 13.3.3.1 Decision Tree Model Viewer
      • 13.3.3.1.1 Save Rules
      • 13.3.3.1.2 Settings (DT)
      • 13.3.3.1.3 DT Summary
      • 13.3.3.1.4 DT Inputs
      • 13.3.3.1.5 DT Target Values
    • 13.3.3.2 Decision Tree Algorithm Settings
• 13.4 Expectation Maximization
  • 13.4.1 Build and Apply an EM Model
  • 13.4.2 EM Model Viewer and Algorithm Settings
    • 13.4.2.1 EM Model Viewer
      • 13.4.2.1.1 EM Component
      • 13.4.2.1.2 EM Details
    • 13.4.2.2 EM Algorithm Settings
      • 13.4.2.2.1 EM Data Preparation and Analysis Settings
• 13.5 Generalized Linear Models
  • 13.5.1 Generalized Linear Models Overview
    • 13.5.1.1 Linear Regression
    • 13.5.1.2 Logistic Regression
    • 13.5.1.3 Data Preparation for GLM
  • 13.5.2 GLM Classification Models
  • 13.5.3 GLM Regression Models
  • 13.5.4 GLM Model Viewers and Algorithm Settings
    • 13.5.4.1 GLM Classification Model Viewer
      • 13.5.4.1.1 GLMC Details
      • 13.5.4.1.2 GLMC Coefficients
      • 13.5.4.1.3 Sort and Search GLMC Coefficients
      • 13.5.4.1.4 GLMC Compare
      • 13.5.4.1.5 GLMC Diagnostics
      • 13.5.4.1.6 GLMC Settings
      • 13.5.4.1.7 GLMC Data Usage:
      • 13.5.4.1.8 GLMC Summary
      • 13.5.4.1.9 GLMC Inputs
      • 13.5.4.1.10 GLMC Target Values
    • 13.5.4.2 GLM Classification Algorithm Settings
      • 13.5.4.2.1 Feature Selection Option Dialog
      • 13.5.4.2.2 Choose Reference Value (GLMC)
      • 13.5.4.2.3 Ridge Regression Option Dialog (GLMC)
    • 13.5.4.3 GLM Regression Model Viewer
      • 13.5.4.3.1 GLMR Coefficients
      • 13.5.4.3.2 GLMR Details
      • 13.5.4.3.3 GLMR Diagnostics
      • 13.5.4.3.4 GLMR Settings
      • 13.5.4.3.5 GLMR Summary
      • 13.5.4.3.6 GLMR Inputs
    • 13.5.4.4 GLM Regression Algorithm Settings
      • 13.5.4.4.1 Ridge Regression Option Dialog (GLMR)
      • 13.5.4.4.2 Choose Reference Value (GLMR)
• 13.6 k-Means
  • 13.6.1 k-Means Algorithm
  • 13.6.2 KM Model Viewer and Algorithm Settings
    • 13.6.2.1 KM Model Viewer
      • 13.6.2.1.1 EM, KM, and OC Tree
      • 13.6.2.1.2 Cluster (Viewer)
      • 13.6.2.1.3 EM, KM, and OC Compare
      • 13.6.2.1.4 Compare Cluster with Population
      • 13.6.2.1.5 Missing Histograms in a Cluster
      • 13.6.2.1.6 Rename Cluster
      • 13.6.2.1.7 KM Settings
      • 13.6.2.1.8 Cluster Model Settings (Viewer)
      • 13.6.2.1.9 Cluster Model Summary
      • 13.6.2.1.10 Cluster Model Input
    • 13.6.2.2 KM Algorithm Settings
• 13.7 Naive Bayes
  • 13.7.1 Naive Bayes Algorithm
    • 13.7.1.1 Advantages of Naive Bayes
  • 13.7.2 Naive Bayes Viewers and Algorithm Settings
    • 13.7.2.1 Naive Bayes Model Viewer
      • 13.7.2.1.1 Probabilities (NB)
      • 13.7.2.1.2 Grid
      • 13.7.2.1.3 Fetch Size
      • 13.7.2.1.4 Grid Filter
      • 13.7.2.1.5 Compare (NB)
      • 13.7.2.1.6 Settings (NB)
      • 13.7.2.1.7 Settings (NB)
      • 13.7.2.1.8 Summary (NB)
      • 13.7.2.1.9 Naive Bayes Algorithm Settings
      • 13.7.2.1.10 Input (NB)
      • 13.7.2.1.11 Weights (NB)
      • 13.7.2.1.12 Target Values (NB)
    • 13.7.2.2 Naive Bayes Test Viewer
• 13.8 Nonnegative Matrix Factorization
  • 13.8.1 Using Nonnegative Matrix Factorization
  • 13.8.2 How Does Nonnegative Matrix Factorization Work
  • 13.8.3 NMF Model Viewer and Algorithm Settings
    • 13.8.3.1 NMF Model Viewer
      • 13.8.3.1.1 Coefficients (NMF)
      • 13.8.3.1.2 Rename (NMF)
      • 13.8.3.1.3 Filter (NMF)
      • 13.8.3.1.4 Settings (NMF)
      • 13.8.3.1.5 Summary (NMF)
      • 13.8.3.1.6 Inputs (NMF)
    • 13.8.3.2 NMF Algorithm Settings
• 13.9 Orthogonal Partitioning Clustering
  • 13.9.1 O-Cluster Algorithm
  • 13.9.2 OC Model Viewer and Algorithm Settings
    • 13.9.2.1 OC Model Viewer
      • 13.9.2.1.1 Detail (OC)
      • 13.9.2.1.2 Settings (OC)
      • 13.9.2.1.3 Summary (OC)
      • 13.9.2.1.4 Inputs (OC)
    • 13.9.2.2 OC Algorithm Settings
• 13.10 Singular Value Decomposition and Principal Components Analysis
  • 13.10.1 Build and Apply SVD and PCA Models
  • 13.10.2 PCA Model Viewer and Algorithm Settings
    • 13.10.2.1 PCA Model Viewer
      • 13.10.2.1.1 Coefficients (PCA)
      • 13.10.2.1.2 Rename (PCA)
      • 13.10.2.1.3 Filter (PCA)
      • 13.10.2.1.4 PCA Scree Plot
      • 13.10.2.1.5 PCA Details
      • 13.10.2.1.6 Settings (PCA)
      • 13.10.2.1.7 Summary (PCA)
      • 13.10.2.1.8 Inputs (PCA)
    • 13.10.2.2 PCA Algorithm Settings
  • 13.10.3 SVD Model Viewer and Algorithm Settings
    • 13.10.3.1 SVD Model Viewer
      • 13.10.3.1.1 Coefficients (SVD)
      • 13.10.3.1.2 Rename (SVD)
      • 13.10.3.1.3 Filter (SVD)
      • 13.10.3.1.4 SVD Singular Values
      • 13.10.3.1.5 SVD Details
      • 13.10.3.1.6 Settings (SVD)
      • 13.10.3.1.7 Summary (SVD)
      • 13.10.3.1.8 Inputs (SVD)
    • 13.10.3.2 SVD Algorithm Settings
• 13.11 Support Vector Machine
  • 13.11.1 Support Vector Machine Algorithms
    • 13.11.1.1 How Support Vector Machines Work
    • 13.11.1.2 SVM Kernel Functions
  • 13.11.2 Building and Testing SVM Models
    • 13.11.2.1 SVM Classification Models
      • 13.11.2.1.1 SVM Weights
    • 13.11.2.2 SVM Regression Models
    • 13.11.2.3 SVM Anomaly Detection Models
  • 13.11.3 Applying SVM Models
    • 13.11.3.1 Applying One-Class SVM Models
  • 13.11.4 SVM Model Viewers and Algorithm Settings
    • 13.11.4.1 SVM Classification Model Viewer
      • 13.11.4.1.1 SVMC Model Viewer for Models with Linear Kernel
      • 13.11.4.1.2 SVMC Model Viewer for Models with Gaussian Kernel
      • 13.11.4.1.3 Coefficients (SVMC Linear)
      • 13.11.4.1.4 Coefficients Grid (SVMC)
      • 13.11.4.1.5 Compare (SVMC Linear)
      • 13.11.4.1.6 Search
      • 13.11.4.1.7 Propensity
      • 13.11.4.1.8 Settings (SVMC)
      • 13.11.4.1.9 Summary (SVMC)
      • 13.11.4.1.10 Settings (SVMC Linear)
      • 13.11.4.1.11 Inputs (SVMC)
      • 13.11.4.1.12 Target Values (SVMC)
      • 13.11.4.1.13 Weights (SVMC)
      • 13.11.4.1.14 Algorithm Settings for SVMC
    • 13.11.4.2 SVM Classification Test Viewer
    • 13.11.4.3 SVM Classification Algorithm Settings
      • 13.11.4.3.1 Algorithm Settings for Linear or System Determined Kernel (SVMC)
      • 13.11.4.3.2 Algorithm Settings for Gaussian Kernel (SVMC)
    • 13.11.4.4 SVM Regression Model Viewer
      • 13.11.4.4.1 SVMR Model Viewer for Models with Linear Kernel
      • 13.11.4.4.2 SVMR Model Viewer for Models with Gaussian Kernel
      • 13.11.4.4.3 Coefficients (SVMR)
      • 13.11.4.4.4 SVMR Coefficients Grid
      • 13.11.4.4.5 Inputs (SVMR)
      • 13.11.4.4.6 Settings (SVMR)
      • 13.11.4.4.7 Summary (SVMR)
    • 13.11.4.5 SVM Regression Test Viewer
    • 13.11.4.6 SVM Regression Algorithm Settings
      • 13.11.4.6.1 Algorithm Settings for Linear or System Determined Kernel (SVMR)
      • 13.11.4.6.2 Algorithm Settings for Gaussian Kernel (SVMR)
      • 13.11.4.6.3 Active Learning
      • 13.11.4.6.4 Automatic Data Preparation
      • 13.11.4.6.5 Cache Size (Gaussian Kernel)
      • 13.11.4.6.6 Complexity Factor
      • 13.11.4.6.7 Standard Deviation (Gaussian Kernel)
      • 13.11.4.6.8 Tolerance Value
• 13.12 Settings Information
  • 13.12.1 General Settings
  • 13.12.2 Other Settings
  • 13.12.3 Epsilon Value

Index