Table of Contents
- Title and Copyright Information
- Preface
-
Part I Introductions
- 1 Introduction to Oracle Machine Learning for SQL
- 2 Oracle Machine Learning Basics
-
Part II Machine Learning Functions
- 3 Regression
- 4 Classification
- 5 Clustering
- 6 Anomaly Detection
- 7 Ranking
- 8 Association
- 9 Feature Selection
- 10 Feature Extraction
- 11 Row Importance
- 12 Time Series
-
Part III Algorithms
- 13 Apriori
- 14 CUR Matrix Decomposition
- 15 Decision Tree
- 16 Expectation Maximization
- 17 Explicit Semantic Analysis
- 18 Exponential Smoothing
- 19 Generalized Linear Model
- 20 k-Means
- 21 Minimum Description Length
- 22 Multivariate State Estimation Technique - Sequential Probability Ratio Test
- 23 Naive Bayes
- 24 Neural Network
- 25 Non-Negative Matrix Factorization
- 26 O-Cluster
- 27 R Extensibility
- 28 Random Forest
- 29 Singular Value Decomposition
- 30 Support Vector Machine
- 31 XGBoost
-
Part IV Using the Oracle Machine Learning for SQL API
- 32 Oracle Machine Learning With SQL
- 33 About the Oracle Machine Learning for SQL API
- 34 Prepare the Data
-
35
Create a Model
- 35.1 Before Creating a Model
- 35.2 Automatic Data Preparation
- 35.3 Embed Transformations in a Model
- 35.4 Understand Reverse Transformations
- 35.5 The CREATE_MODEL Procedure
- 35.6 The CREATE_MODEL2 Procedure
- 35.7 Specify Model Settings
-
35.8
Model Detail Views
- 35.8.1 Model Detail Views for Association Rules
- 35.8.2 Model Detail View for Frequent Itemsets
- 35.8.3 Model Detail Views for Transactional Itemsets
- 35.8.4 Model Detail View for Transactional Rule
- 35.8.5 Model Detail Views for Classification Algorithms
- 35.8.6 Model Detail Views for Decision Tree
- 35.8.7 Model Detail Views for Generalized Linear Model
- 35.8.8 Model Detail View for Multivariate State Estimation Technique - Sequential Probability Ratio Test
- 35.8.9 Model Detail Views for Naive Bayes
- 35.8.10 Model Detail Views for Neural Network
- 35.8.11 Model Detail Views for Random Forest
- 35.8.12 Model Detail View for Support Vector Machine
- 35.8.13 Model Detail Views for XGBoost
- 35.8.14 Model Detail Views for Clustering Algorithms
- 35.8.15 Model Detail Views for Expectation Maximization
- 35.8.16 Model Detail Views for k-Means
- 35.8.17 Model Detail Views for O-Cluster
- 35.8.18 Model Detail Views for CUR Matrix Decomposition
- 35.8.19 Model Detail Views for Explicit Semantic Analysis
- 35.8.20 Model Detail Views for Exponential Smoothing
- 35.8.21 Model Detail Views for Non-Negative Matrix Factorization
- 35.8.22 Model Detail Views for Singular Value Decomposition
- 35.8.23 Model Detail Views for Minimum Description Length
- 35.8.24 Model Detail Views for Binning
- 35.8.25 Model Detail Views for Global Information
- 35.8.26 Model Detail Views for Normalization and Missing Value Handling
- 36 Scoring and Deployment
- 37 Machine Learning Operations on Unstructured Text
-
38
Administrative Tasks for Oracle Machine Learning for SQL
- 38.1 Install and Configure a Database for Oracle Machine Learning for SQL
- 38.2 Upgrade or Downgrade Oracle Machine Learning for SQL
- 38.3 Export and Import Oracle Machine Learning for SQL Models
- 38.4 Control Access to Oracle Machine Learning for SQL Models and Data
- 38.5 Audit and Add Comments to Oracle Machine Learning for SQL Models
- 39 Oracle Machine Learning for SQL Examples
-
Part V Oracle Machine Learning for SQL API Reference
-
40
PL/SQL Packages
-
40.1
DBMS_DATA_MINING
- 40.1.1 Using DBMS_DATA_MINING
-
40.1.2
DBMS_DATA_MINING — Model Settings
- 40.1.2.1 DBMS_DATA_MINING — Algorithm Names
- 40.1.2.2 DBMS_DATA_MINING — Automatic Data Preparation
- 40.1.2.3 DBMS_DATA_MINING — Machine Learning Function Settings
- 40.1.2.4 DBMS_DATA_MINING — Global Settings
- 40.1.2.5 DBMS_DATA_MINING — Algorithm Settings: ALGO_EXTENSIBLE_LANG
- 40.1.2.6 DBMS_DATA_MINING — Algorithm Settings: CUR Matrix Decomposition
- 40.1.2.7 DBMS_DATA_MINING — Algorithm Settings: Decision Tree
- 40.1.2.8 DBMS_DATA_MINING — Algorithm Settings: Expectation Maximization
- 40.1.2.9 DBMS_DATA_MINING — Algorithm Settings: Explicit Semantic Analysis
- 40.1.2.10 DBMS_DATA_MINING — Algorithm Settings: Exponential Smoothing
- 40.1.2.11 DBMS_DATA_MINING — Algorithm Settings: Generalized Linear Model
- 40.1.2.12 DBMS_DATA_MINING — Algorithm Settings: k-Means
- 40.1.2.13 DBMS_DATA_MINING - Algorithm Settings: Multivariate State Estimation Technique - Sequential Probability Ratio Test
- 40.1.2.14 DBMS_DATA_MINING — Algorithm Settings: Naive Bayes
- 40.1.2.15 DBMS_DATA_MINING — Algorithm Settings: Neural Network
- 40.1.2.16 DBMS_DATA_MINING — Algorithm Settings: Non-Negative Matrix Factorization
- 40.1.2.17 DBMS_DATA_MINING — Algorithm Settings: O-Cluster
- 40.1.2.18 DBMS_DATA_MINING — Algorithm Settings: Random Forest
- 40.1.2.19 DBMS_DATA_MINING — Algorithm Constants and Settings: Singular Value Decomposition
- 40.1.2.20 DBMS_DATA_MINING — Algorithm Settings: Support Vector Machine
- 40.1.2.21 DBMS_DATA_MINING — Algorithm Settings: XGBoost
- 40.1.3 DBMS_DATA_MINING — Solver Settings
- 40.1.4 DBMS_DATA_MINING Datatypes
-
40.1.5
Summary of DBMS_DATA_MINING Subprograms
- 40.1.5.1 ADD_COST_MATRIX Procedure
- 40.1.5.2 ADD_PARTITION Procedure
- 40.1.5.3 ALTER_REVERSE_EXPRESSION Procedure
- 40.1.5.4 APPLY Procedure
- 40.1.5.5 COMPUTE_CONFUSION_MATRIX Procedure
- 40.1.5.6 COMPUTE_CONFUSION_MATRIX_PART Procedure
- 40.1.5.7 COMPUTE_LIFT Procedure
- 40.1.5.8 COMPUTE_LIFT_PART Procedure
- 40.1.5.9 COMPUTE_ROC Procedure
- 40.1.5.10 COMPUTE_ROC_PART Procedure
- 40.1.5.11 CREATE_MODEL Procedure
- 40.1.5.12 CREATE_MODEL2 Procedure
- 40.1.5.13 Create Model Using Registration Information
- 40.1.5.14 DROP_ALGORITHM Procedure
- 40.1.5.15 DROP_PARTITION Procedure
- 40.1.5.16 DROP_MODEL Procedure
- 40.1.5.17 EXPORT_MODEL Procedure
- 40.1.5.18 EXPORT_SERMODEL Procedure
- 40.1.5.19 FETCH_JSON_SCHEMA Procedure
- 40.1.5.20 GET_ASSOCIATION_RULES Function
- 40.1.5.21 GET_FREQUENT_ITEMSETS Function
- 40.1.5.22 GET_MODEL_COST_MATRIX Function
- 40.1.5.23 GET_MODEL_DETAILS_AI Function
- 40.1.5.24 GET_MODEL_DETAILS_EM Function
- 40.1.5.25 GET_MODEL_DETAILS_EM_COMP Function
- 40.1.5.26 GET_MODEL_DETAILS_EM_PROJ Function
- 40.1.5.27 GET_MODEL_DETAILS_GLM Function
- 40.1.5.28 GET_MODEL_DETAILS_GLOBAL Function
- 40.1.5.29 GET_MODEL_DETAILS_KM Function
- 40.1.5.30 GET_MODEL_DETAILS_NB Function
- 40.1.5.31 GET_MODEL_DETAILS_NMF Function
- 40.1.5.32 GET_MODEL_DETAILS_OC Function
- 40.1.5.33 GET_MODEL_SETTINGS Function
- 40.1.5.34 GET_MODEL_SIGNATURE Function
- 40.1.5.35 GET_MODEL_DETAILS_SVD Function
- 40.1.5.36 GET_MODEL_DETAILS_SVM Function
- 40.1.5.37 GET_MODEL_DETAILS_XML Function
- 40.1.5.38 GET_MODEL_TRANSFORMATIONS Function
- 40.1.5.39 GET_TRANSFORM_LIST Procedure
- 40.1.5.40 IMPORT_MODEL Procedure
- 40.1.5.41 IMPORT_SERMODEL Procedure
- 40.1.5.42 JSON Schema for R Extensible Algorithm
- 40.1.5.43 REGISTER_ALGORITHM Procedure
- 40.1.5.44 RANK_APPLY Procedure
- 40.1.5.45 REMOVE_COST_MATRIX Procedure
- 40.1.5.46 RENAME_MODEL Procedure
-
40.2
DBMS_DATA_MINING_TRANSFORM
- 40.2.1 Using DBMS_DATA_MINING_TRANSFORM
- 40.2.2 DBMS_DATA_MINING_TRANSFORM Operational Notes
-
40.2.3
Summary of DBMS_DATA_MINING_TRANSFORM Subprograms
- 40.2.3.1 CREATE_BIN_CAT Procedure
- 40.2.3.2 CREATE_BIN_NUM Procedure
- 40.2.3.3 CREATE_CLIP Procedure
- 40.2.3.4 CREATE_COL_REM Procedure
- 40.2.3.5 CREATE_MISS_CAT Procedure
- 40.2.3.6 CREATE_MISS_NUM Procedure
- 40.2.3.7 CREATE_NORM_LIN Procedure
- 40.2.3.8 DESCRIBE_STACK Procedure
- 40.2.3.9 GET_EXPRESSION Function
- 40.2.3.10 INSERT_AUTOBIN_NUM_EQWIDTH Procedure
- 40.2.3.11 INSERT_BIN_CAT_FREQ Procedure
- 40.2.3.12 INSERT_BIN_NUM_EQWIDTH Procedure
- 40.2.3.13 INSERT_BIN_NUM_QTILE Procedure
- 40.2.3.14 INSERT_BIN_SUPER Procedure
- 40.2.3.15 INSERT_CLIP_TRIM_TAIL Procedure
- 40.2.3.16 INSERT_CLIP_WINSOR_TAIL Procedure
- 40.2.3.17 INSERT_MISS_CAT_MODE Procedure
- 40.2.3.18 INSERT_MISS_NUM_MEAN Procedure
- 40.2.3.19 INSERT_NORM_LIN_MINMAX Procedure
- 40.2.3.20 INSERT_NORM_LIN_SCALE Procedure
- 40.2.3.21 INSERT_NORM_LIN_ZSCORE Procedure
- 40.2.3.22 SET_EXPRESSION Procedure
- 40.2.3.23 SET_TRANSFORM Procedure
- 40.2.3.24 STACK_BIN_CAT Procedure
- 40.2.3.25 STACK_BIN_NUM Procedure
- 40.2.3.26 STACK_CLIP Procedure
- 40.2.3.27 STACK_COL_REM Procedure
- 40.2.3.28 STACK_MISS_CAT Procedure
- 40.2.3.29 STACK_MISS_NUM Procedure
- 40.2.3.30 STACK_NORM_LIN Procedure
- 40.2.3.31 XFORM_BIN_CAT Procedure
- 40.2.3.32 XFORM_BIN_NUM Procedure
- 40.2.3.33 XFORM_CLIP Procedure
- 40.2.3.34 XFORM_COL_REM Procedure
- 40.2.3.35 XFORM_EXPR_NUM Procedure
- 40.2.3.36 XFORM_EXPR_STR Procedure
- 40.2.3.37 XFORM_MISS_CAT Procedure
- 40.2.3.38 XFORM_MISS_NUM Procedure
- 40.2.3.39 XFORM_NORM_LIN Procedure
- 40.2.3.40 XFORM_STACK Procedure
- 40.3 DBMS_PREDICTIVE_ANALYTICS
-
40.1
DBMS_DATA_MINING
- 41 Data Dictionary Views
-
42
SQL Scoring Functions
- 42.1 CLUSTER_DETAILS
- 42.2 CLUSTER_DISTANCE
- 42.3 CLUSTER_ID
- 42.4 CLUSTER_PROBABILITY
- 42.5 CLUSTER_SET
- 42.6 FEATURE_COMPARE
- 42.7 FEATURE_DETAILS
- 42.8 FEATURE_ID
- 42.9 FEATURE_SET
- 42.10 FEATURE_VALUE
- 42.11 ORA_DM_PARTITION_NAME
- 42.12 PREDICTION
- 42.13 PREDICTION_BOUNDS
- 42.14 PREDICTION_COST
- 42.15 PREDICTION_DETAILS
- 42.16 PREDICTION_PROBABILITY
- 42.17 PREDICTION_SET
-
40
PL/SQL Packages