Go to main content
1/13
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Oracle Data Miner System Overview
Oracle Data Miner Architecture
About the Oracle Data Miner Repository
Database Features Used by Oracle Data Miner
Oracle Data Miner and Oracle Advanced Analytics
About Data Mining APIs
Data Mining PL/SQL Packages
Data Mining SQL Scoring Functions
Data Mining Data Dictionary Views
Resources For Learning About Oracle Data Miner
2
Installing the Database to Support Oracle Data Miner
Database Requirements for Oracle Data Miner
Oracle Text and Oracle Data Miner
XML DB and Oracle Data Miner
Storage Configuration for Oracle Data Miner
Installing Oracle Database 11.2.0.4 or Later
Connecting to an Oracle Cloud Database Schema
3
Installing Oracle Data Miner
Oracle Data Miner Installation Overview
About Oracle Data Miner Sample Data
Downloading SQL Developer
Installing the Repository Using a Script
Loading the Sample Data Using a Script
Installing the Repository Using SQL Developer GUI
Installing JSON Parser and Data Guide
About the Scripts for Installing JSON Support
Requirements for Running the Scripts to Install JSON Parser
Installing JSON Parser in a Remote Database
Installing JSON Parser Locally on the Database Host
4
Managing Oracle Data Miner Users
About User Objects and Repository Objects
Controlling the Size of Users' Schemas
Objects in Oracle Data Miner Users' Schema
About Oracle Data Miner Internal Tables
About Proxy Users for Oracle Data Miner
Setting the JVM Property
Choosing an Access Model for Oracle Data Miner
Single User Access
Multiple User Access
Shared User Environment
About the Document in Use Condition
Granting or Dropping Access Rights to Oracle Data Miner Repository
Granting Access Rights Using the GUI
Granting Access Rights Using a Script
Dropping Access Rights Using a Script
Granting Access to Data
5
Managing the Oracle Data Miner Repository
About Oracle Data Miner Administration Scripts
Setting the Path to Oracle Data Miner Scripts
Determining the Status and Version of the Repository
Backing Up and Restoring the Repository
Full Backup and Restore
Full Backup and Restore in Database 11.2.0.4 and Later
Workflow Only Backup
Workflow Only Restore
Workflow Only Restore Examples
Migrating the Repository
Upgrading ODMRSYS
Scripts to Migrate the Repository
Upgrading New ODMRSYS Tablespace From Object-Relational to Binary
Upgrading ODMRSYS From Object-Relational to Binary
Dropping the Repository
6
Managing System Resources for Oracle Data Miner
Oracle Data Miner Resource Management Overview
Allocating Resources to Oracle Data Miner User Sessions
Managing Model Builds
Managing Workflow Execution
Managing Parallel Processing
Summary of Oracle Data Miner Repository Properties for System Management
7
Generating and Deploying SQL Scripts
Overview of the SQL Script Generation Feature
Overview of the SQL Script Generation Use Case
Premise of the SQL Script Generation Use Case
Location of Demo Workflow Files
About the Sample Workflow
Performing Prerequisite Tasks
Importing and Running a Workflow
Generating SQL Script Files from the Workflow
List of Generated SQL Script Files
Variable Definitions in Script Files
Control Tables
Structure of the Control Table
Columns in the Control Table
Scheduling Workflow Script Files
Prerequisites for Scheduling Workflow Script Files
Adding Complete Directory Path in the Master Script
Creating Credentials for Database Host and Database
Schedule SQL Scripts Using SQL Developer
Creating Credentials for Database Host and Database
Defining Scheduler Job using Job Wizard
Scheduling SQL Scripts using Oracle Enterprise Manager
Deploying SQL Scripts on the Target Database
Querying the Control Table
8
Using PL/SQL API to Manage Workflows
About PL/SQL APIs
PL/SQL APIs
PROJECT_CREATE
PROJECT_RENAME
PROJECT_DELETE
WF_RUN
WF_RUN Parameters
WF_RUN with Project Name, Workflow Name, and Node Name
WF_RUN with Project Name, Workflow Name Node Name and Time Interval
WF_RUN with Project ID, Workflow ID, Node ID and Time Interval
WF_RUN with Project ID, Workflow ID and Node IDs
WF_STOP
WF_RENAME
WF_DELETE
WF_IMPORT
WF_EXPORT
Repository Views
ODMR_USER_PROJECT_WORKFLOW
ODMR_USER_WORKFLOW_ALL
ODMR_USER_WORKFLOW_LOG
ODMR_USER_WORKFLOW_NODES
ODMR_USER_WORKFLOW_MODELS
ODMR_USER_WF_CLAS_TEST_RESULTS
ODMR_USER_WF_REGR_TEST_RESULTS
ODMR_USER_WF_TEST_RESULTS
ODMR_USER_WORKFLOW_ALL_POLL
PL/SQL APIs Use Cases
Premise of the PL/SQL Use Cases
Use case to Schedule and Run Apply Workflows
Querying Scoring Result
Use Case to Schedule and Run a Build Workflow
Querying the MODEL_COEFFICIENT Table
Querying Named Objects
Querying Test Results
A
Oracle Data Miner Releases
Index
Scripting on this page enhances content navigation, but does not change the content in any way.