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