Table of Contents
- List of Figures
- List of Tables
- Title and Copyright Information
- Preface
-
New Features and Changes in Oracle Data Miner
-
Oracle Machine Learning Features
- Association Model Aggregation Metrics
-
Enhancements to Algorithm Settings
- Changes to Decision Tree Algorithm Settings
- Changes to Expectation Maximization Algorithm Settings
- Changes to Generalized Linear Models Algorithm Settings
- Changes to k-Means Algorithm Settings
- Changes to Support Vector Machine Algorithm Settings
- Changes to Singular Value Decomposition and Principal Components Analysis Algorithm Settings
- Support for Explicit Semantic Analysis Algorithm
- Enhancement to Oracle Machine Learning Model Detail View
- Enhancements to Filter Column Node
- Mining Model Build Alerts
- R Build Model Node
- Support for Partitioned Models
-
Oracle Machine Learning Features
- Aggregation Node Support for DATE and TIMESTAMP Data Types
- Enhancement to JSON Query Node
- Enhancement to Build Nodes
- Enhancement to Text Settings
- Refresh Input Data Definition
- Support for Additional Data Types
- Support for In-Memory Column
- Support for Workflow Scheduling
- Enhancement to Polling Performance
- Workflow Status Polling Performance Improvement
- Oracle Database Features
-
Oracle Machine Learning Features
- 1 Oracle Data Miner
- 2 Connections for Oracle Machine Learning
- 3 Data Miner Projects
-
4
Workflow
- 4.1 About Workflows
-
4.2
Working with Workflows
- 4.2.1 Creating a Workflow
- 4.2.2 Deploying Workflows
- 4.2.3 Deleting a Workflow
- 4.2.4 Loading a Workflow
-
4.2.5
Managing a Workflow
- 4.2.5.1 Exporting a Workflow Using the GUI
- 4.2.5.2 Import Requirements of a Workflow
- 4.2.5.3 Data Table Names
- 4.2.5.4 Workflow Compatibility
- 4.2.5.5 Building and Modifying Workflows
- 4.2.5.6 Missing Tables or Views
- 4.2.5.7 Managing Workflows using Workflow Controls
- 4.2.5.8 Managing Workflows and Nodes in the Properties Pane
- 4.2.5.9 Performing Tasks from Workflow Context Menu
- 4.2.6 Oracle Enterprise Manager Jobs
- 4.2.7 Renaming a Workflow
- 4.2.8 Runtime Requirements
- 4.2.9 Running a Workflow
- 4.2.10 Scheduling a Workflow
- 4.2.11 Workflow Prerequisites
- 4.2.12 Workflow Script Requirements
- 4.3 About Nodes
-
4.4
Working with Nodes
- 4.4.1 Add Nodes or Create Nodes
- 4.4.2 Copy Nodes
- 4.4.3 Edit Nodes
- 4.4.4 Link Nodes
- 4.4.5 Refresh Nodes
- 4.4.6 Run Nodes
-
4.4.7
Performing Tasks from the Node Context Menu
- 4.4.7.1 Connect
- 4.4.7.2 Run
- 4.4.7.3 Force Run
- 4.4.7.4 Create Schedule
- 4.4.7.5 Edit
- 4.4.7.6 View Data
- 4.4.7.7 View Models
- 4.4.7.8 Generate Apply Chain
- 4.4.7.9 Refresh Input Data Definition
- 4.4.7.10 Show Event Log
- 4.4.7.11 Deploy
- 4.4.7.12 Show Graph
- 4.4.7.13 Cut
- 4.4.7.14 Copy
- 4.4.7.15 Paste
- 4.4.7.16 Extended Paste
- 4.4.7.17 Select All
- 4.4.7.18 Performance Settings
- 4.4.7.19 Toolbar Actions
- 4.4.7.20 Show Runtime Errors
- 4.4.7.21 Show Validation Errors
- 4.4.7.22 Save SQL
- 4.4.7.23 Validate Parents
- 4.4.7.24 Compare Test Results
- 4.4.7.25 View Test Results
- 4.4.7.26 Go to Properties
- 4.4.7.27 Navigate
- 4.5 About Parallel Processing
- 4.6 Setting Parallel Processing for a Node or Workflow
- 4.7 About Oracle Database In-Memory
-
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 Creating 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 Table or View Context Menu
- 5.1.1.6.1 Connect
- 5.1.1.6.2 Run
- 5.1.1.6.3 Force Run
- 5.1.1.6.4 Create Schedule
- 5.1.1.6.5 Edit
- 5.1.1.6.6 View Data
- 5.1.1.6.7 View Models
- 5.1.1.6.8 Generate Apply Chain
- 5.1.1.6.9 Refresh Input Data Definition
- 5.1.1.6.10 Show Event Log
- 5.1.1.6.11 Deploy
- 5.1.1.6.12 Show Graph
- 5.1.1.6.13 Cut
- 5.1.1.6.14 Copy
- 5.1.1.6.15 Paste
- 5.1.1.6.16 Extended Paste
- 5.1.1.6.17 Select All
- 5.1.1.6.18 Performance Settings
- 5.1.1.6.19 Toolbar Actions
- 5.1.1.6.20 Show Runtime Errors
- 5.1.1.6.21 Show Validation Errors
- 5.1.1.6.22 Save SQL
- 5.1.1.6.23 Validate Parents
- 5.1.1.6.24 Compare Test Results
- 5.1.1.6.25 View Test Results
- 5.1.1.6.26 Go to Properties
- 5.1.1.6.27 Navigate
- 5.1.1.7 Create the Table or View Node Properties
-
5.1.1
Working with the Create Table or View Node
-
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.4 Data Source Node Viewer
- 5.2.5 Data Source Node Properties
- 5.3 Explore Data Node
- 5.4 Graph Node
- 5.5 SQL Query Node
- 5.6 Update Table Node
- 5.7 Target Values Selection
-
5.1
Create Table or View Node
- 6 Using the Oracle Data Miner GUI
-
7
Transforms Nodes
- 7.1 Aggregation
- 7.2 Data Viewer
- 7.3 Expression Builder
- 7.4 Filter Columns Node
- 7.5 Filter Columns Details
- 7.6 Filter Rows
- 7.7 Join
- 7.8 JSON Query
- 7.9 Sample
-
7.10
Transform
- 7.10.1 Supported Transformations
- 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.2 Add Custom Transform
- 7.10.4.3 Apply Transform Wizard
- 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.3 Data Used for Model Building
- 8.4 Model Nodes Properties
- 8.5 Anomaly Detection Node
- 8.6 Association Node
- 8.7 Classification Node
- 8.8 Clustering Node
- 8.9 Explicit Feature Extraction Node
- 8.10 Feature Extraction Node
- 8.11 Model Node
- 8.12 Model Details Node
- 8.13 R Build Node
- 8.14 Regression Node
- 8.15 Advanced Settings Overview
- 8.16 Machine Learning Functions
-
9
Model Operations
-
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.6 Evaluate and Apply Data
- 9.1.7 Edit Apply Node
- 9.1.8 Apply Node Properties
-
9.1.9
Apply Node Context Menu
- 9.1.9.1 Connect
- 9.1.9.2 Run
- 9.1.9.3 Force Run
- 9.1.9.4 Create Schedule
- 9.1.9.5 Edit
- 9.1.9.6 View Data
- 9.1.9.7 Generate Apply Chain
- 9.1.9.8 Show Event Log
- 9.1.9.9 Show Validation Errors
- 9.1.9.10 Validate Parents
- 9.1.9.11 Deploy
- 9.1.9.12 Save SQL
- 9.1.9.13 Cut
- 9.1.9.14 Copy
- 9.1.9.15 Paste
- 9.1.9.16 Select All
- 9.1.9.17 Performance Settings
- 9.1.9.18 Go to Properties
- 9.1.9.19 Navigate
- 9.1.10 Apply Data Viewer
-
9.2
Feature Compare Node
- 9.2.1 Create Feature Compare Node
- 9.2.2 Feature Compare
-
9.2.3
Feature Compare Node Context Menu
- 9.2.3.1 Connect
- 9.2.3.2 Run
- 9.2.3.3 Force Run
- 9.2.3.4 Create Schedule
- 9.2.3.5 Edit
- 9.2.3.6 View Data
- 9.2.3.7 Generate Apply Chain
- 9.2.3.8 Show Event Log
- 9.2.3.9 Show Validation Errors
- 9.2.3.10 Validate Parents
- 9.2.3.11 Deploy
- 9.2.3.12 Save SQL
- 9.2.3.13 Cut
- 9.2.3.14 Copy
- 9.2.3.15 Paste
- 9.2.3.16 Select All
- 9.2.3.17 Performance Settings
- 9.2.3.18 Go to Properties
- 9.2.3.19 Navigate
- 9.3 Test Node
-
9.1
Apply Node
-
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.3 Anomaly Detection Query Properties
-
10.1.4
Anomaly Detection Query Context Menu
- 10.1.4.1 Connect
- 10.1.4.2 Run
- 10.1.4.3 Force Run
- 10.1.4.4 Create Schedule
- 10.1.4.5 Edit
- 10.1.4.6 View Data
- 10.1.4.7 Generate Apply Chain
- 10.1.4.8 Show Event Log
- 10.1.4.9 Deploy
- 10.1.4.10 Cut
- 10.1.4.11 Copy
- 10.1.4.12 Paste
- 10.1.4.13 Extended Paste
- 10.1.4.14 Select All
- 10.1.4.15 Performance Settings
- 10.1.4.16 Toolbar Actions
- 10.1.4.17 Show Runtime Errors
- 10.1.4.18 Show Validation Errors
- 10.1.4.19 Save SQL
- 10.1.4.20 Validate Parents
- 10.1.4.21 Go to Properties
-
10.2
Clustering Query
- 10.2.1 Create a Clustering Query
- 10.2.2 Edit a Clustering Query
- 10.2.3 Clustering Query Properties
-
10.2.4
Clustering Query Context Menu
- 10.2.4.1 Connect
- 10.2.4.2 Run
- 10.2.4.3 Force Run
- 10.2.4.4 Create Schedule
- 10.2.4.5 Edit
- 10.2.4.6 View Data
- 10.2.4.7 Generate Apply Chain
- 10.2.4.8 Show Event Log
- 10.2.4.9 Deploy
- 10.2.4.10 Cut
- 10.2.4.11 Copy
- 10.2.4.12 Paste
- 10.2.4.13 Extended Paste
- 10.2.4.14 Select All
- 10.2.4.15 Performance Settings
- 10.2.4.16 Toolbar Actions
- 10.2.4.17 Show Runtime Errors
- 10.2.4.18 Show Validation Errors
- 10.2.4.19 Save SQL
- 10.2.4.20 Validate Parents
- 10.2.4.21 Go to Properties
-
10.3
Feature Extraction Query
- 10.3.1 Create a Feature Extraction Query
- 10.3.2 Edit Feature Extraction Query
- 10.3.3 Feature Extraction Query Properties
-
10.3.4
Feature Extraction Query Context Menu
- 10.3.4.1 Connect
- 10.3.4.2 Run
- 10.3.4.3 Force Run
- 10.3.4.4 Create Schedule
- 10.3.4.5 Edit
- 10.3.4.6 View Data
- 10.3.4.7 Generate Apply Chain
- 10.3.4.8 Show Event Log
- 10.3.4.9 Deploy
- 10.3.4.10 Cut
- 10.3.4.11 Copy
- 10.3.4.12 Paste
- 10.3.4.13 Extended Paste
- 10.3.4.14 Select All
- 10.3.4.15 Performance Settings
- 10.3.4.16 Toolbar Actions
- 10.3.4.17 Show Runtime Errors
- 10.3.4.18 Show Validation Errors
- 10.3.4.19 Save SQL
- 10.3.4.20 Validate Parents
- 10.3.4.21 Go to Properties
-
10.4
Prediction Query
- 10.4.1 Create a Prediction Query
- 10.4.2 Edit a Prediction Query
- 10.4.3 Run Predictive Query Node
- 10.4.4 View Data for a Predictive Query
- 10.4.5 Prediction Query Properties
-
10.4.6
Prediction Query Node Context Menu
- 10.4.6.1 Connect
- 10.4.6.2 Run
- 10.4.6.3 Force Run
- 10.4.6.4 Create Schedule
- 10.4.6.5 Edit
- 10.4.6.6 View Data
- 10.4.6.7 Generate Apply Chain
- 10.4.6.8 Show Event Log
- 10.4.6.9 Deploy
- 10.4.6.10 Cut
- 10.4.6.11 Copy
- 10.4.6.12 Paste
- 10.4.6.13 Extended Paste
- 10.4.6.14 Select All
- 10.4.6.15 Performance Settings
- 10.4.6.16 Toolbar Actions
- 10.4.6.17 Show Runtime Errors
- 10.4.6.18 Show Validation Errors
- 10.4.6.19 Save SQL
- 10.4.6.20 Validate Parents
- 10.4.6.21 Go to Properties
-
10.1
Anomaly Detection Query
-
11
Text Nodes
- 11.1 Oracle Text Concepts
- 11.2 Text Mining in Oracle Machine Learning
- 11.3 Apply Text Node
- 11.4 Build Text
- 11.5 Text Reference
-
12
Testing and Tuning Models
-
12.1
Testing Classification Models
- 12.1.1 Test Metrics for Classification Models
- 12.1.2 Compare Classification Test Results
- 12.1.3 Classification Model Test Viewer
- 12.1.4 Viewing Test Results
- 12.2 Tuning Classification Models
- 12.3 Testing Regression Models
-
12.1
Testing Classification Models
-
13
Oracle Machine Learning Algorithms
-
13.1
Anomaly Detection
- 13.1.1 Applying Anomaly Detection Models
- 13.1.2 Algorithm Settings for AD
- 13.1.3 Anomaly Detection Model Viewer
- 13.1.4 Viewing Models in Model Viewer
-
13.2
Association
- 13.2.1 Calculating Associations
- 13.2.2 Data for AR Models
- 13.2.3 Troubleshooting AR Models
- 13.2.4 AR Model Viewer
- 13.2.5 Viewing Models in Model Viewer
- 13.3 Decision Tree
- 13.4 Expectation Maximization
- 13.5 Explicit Semantic Analysis
- 13.6 Generalized Linear Models
- 13.7 k-Means
-
13.8
Naive Bayes
- 13.8.1 Naive Bayes Algorithm
- 13.8.2 Naive Bayes Test Viewer
- 13.8.3 Naive Bayes Model Viewer
- 13.9 Nonnegative Matrix Factorization
- 13.10 Orthogonal Partitioning Clustering
- 13.11 Singular Value Decomposition and Principal Components Analysis
-
13.12
Support Vector Machine
- 13.12.1 Support Vector Machine Algorithms
- 13.12.2 Building and Testing SVM Models
- 13.12.3 Applying SVM Models
- 13.12.4 SVM Classification Algorithm Settings
- 13.12.5 SVM Classification Test Viewer
- 13.12.6 SVM Classification Model Viewer
- 13.12.7 SVM Regression Algorithm Settings
- 13.12.8 SVM Regression Test Viewer
- 13.12.9 SVM Regression Model Viewer
- 13.13 Settings Information
-
13.1
Anomaly Detection
- Index