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 Techniques
- 3 Regression
- 4 Classification
- 5 Clustering
- 6 Anomaly Detection
- 7 Ranking
- 8 Association
- 9 Feature Selection
- 10 Embedding
- 11 Feature Extraction
- 12 Row Importance
- 13 Time Series
-
Part III Algorithms
- 14 Apriori
- 15 CUR Matrix Decomposition
- 16 Decision Tree
- 17 Expectation Maximization
- 18 Explicit Semantic Analysis
- 19 Exponential Smoothing
-
20
Generalized Linear Model
- 20.1 About Generalized Linear Model
- 20.2 GLM in Oracle Machine Learning
- 20.3 Scalable Feature Selection
- 20.4 Tuning and Diagnostics for GLM
- 20.5 GLM Solvers
- 20.6 Data Preparation for GLM
- 20.7 Linear Regression
-
20.8
Logistic Regression
- 20.8.1 Logit Link Function
- 20.8.2 Probit Link Function
- 20.8.3 Cloglog Link Function
- 20.8.4 Cauchit Link Function
- 20.8.5 Reference Class
- 20.8.6 Class Weights
- 20.8.7 Coefficient Statistics for Logistic Regression
- 20.8.8 Global Model Statistics for Logistic Regression
- 20.8.9 Row Diagnostics for Logistic Regression
- 21 k-Means
- 22 Minimum Description Length
- 23 Multivariate State Estimation Technique - Sequential Probability Ratio Test
- 24 Naive Bayes
- 25 Neural Network
- 26 Non-Negative Matrix Factorization
- 27 O-Cluster
- 28 R Extensibility
- 29 Random Forest
- 30 Singular Value Decomposition
- 31 Support Vector Machine
- 32 XGBoost
-
Part IV Using the Oracle Machine Learning for SQL API
- 33 Oracle Machine Learning With SQL
- 34 About the Oracle Machine Learning for SQL API
- 35 Prepare the Data
-
36
Create a Model
- 36.1 Before Creating a Model
- 36.2 Automatic Data Preparation
- 36.3 Embed Transformations in a Model
- 36.4 Understand Reverse Transformations
- 36.5 The CREATE_MODEL Procedure
- 36.6 The CREATE_MODEL2 Procedure
- 36.7 Specify Model Settings
-
36.8
Model Detail Views
- 36.8.1 Model Detail Views for Association Rules
- 36.8.2 Model Detail View for Frequent Itemsets
- 36.8.3 Model Detail Views for Transactional Itemsets
- 36.8.4 Model Detail View for Transactional Rule
- 36.8.5 Model Detail Views for Classification Algorithms
- 36.8.6 Model Detail Views for Decision Tree
- 36.8.7 Model Detail Views for Generalized Linear Model
- 36.8.8 Model Detail View for Multivariate State Estimation Technique - Sequential Probability Ratio Test
- 36.8.9 Model Detail Views for Naive Bayes
- 36.8.10 Model Detail Views for Neural Network
- 36.8.11 Model Detail Views for Random Forest
- 36.8.12 Model Detail View for Support Vector Machine
- 36.8.13 Model Detail Views for XGBoost
- 36.8.14 Model Detail Views for Clustering Algorithms
- 36.8.15 Model Detail Views for Expectation Maximization
- 36.8.16 Model Detail Views for k-Means
- 36.8.17 Model Detail Views for O-Cluster
- 36.8.18 Model Detail Views for CUR Matrix Decomposition
- 36.8.19 Model Detail Views for Explicit Semantic Analysis
- 36.8.20 Model Detail Views for Exponential Smoothing
- 36.8.21 Model Detail Views for Non-Negative Matrix Factorization
- 36.8.22 Model Detail Views for Singular Value Decomposition
- 36.8.23 Model Detail Views for Minimum Description Length
- 36.8.24 Model Detail Views for Binning
- 36.8.25 Model Detail Views for Global Information
- 36.8.26 Model Detail Views for Normalization and Missing Value Handling
- 36.8.27 Model Detail Views for ONNX Models
- 37 Scoring and Deployment
- 38 Machine Learning Operations on Unstructured Text
- 39 Integration of ONNX Runtime
-
40
Administrative Tasks for Oracle Machine Learning for SQL
- 40.1 Install and Configure a Database for Oracle Machine Learning for SQL
- 40.2 Upgrade or Downgrade Oracle Machine Learning for SQL
-
40.3
Export and Import Oracle Machine Learning for SQL Models
- 40.3.1 About Exporting Models
- 40.3.2 About Oracle Data Pump
- 40.3.3 Options for Exporting and Importing Oracle Machine Learning for SQL Models
- 40.3.4 Directory Objects for EXPORT_MODEL and IMPORT_MODEL
- 40.3.5 Use EXPORT_MODEL and IMPORT_MODEL
- 40.3.6 EXPORT and IMPORT Serialized Models
- 40.3.7 Import From PMML
- 40.4 Secure
- 40.5 Audit and Add Comments to Oracle Machine Learning for SQL Models
- 41 Examples
-
Part V Oracle Machine Learning for SQL API Reference
-
42
PL/SQL Packages
-
42.1
DBMS_DATA_MINING
- 42.1.1 DBMS_DATA_MINING Overview
- 42.1.2 DBMS_DATA_MINING Security Model
- 42.1.3 DBMS_DATA_MINING — Machine Learning Functions
- 42.1.4 DBMS_DATA_MINING — Model Settings
-
42.1.5
DBMS_DATA_MINING — Algorithm Specific Model Settings
- 42.1.5.1 DBMS_DATA_MINING — Algorithm Settings: ALGO_EXTENSIBLE_LANG
- 42.1.5.2 DBMS_DATA_MINING — Algorithm Settings: CUR Matrix Decomposition
- 42.1.5.3 DBMS_DATA_MINING — Algorithm Settings: Decision Tree
- 42.1.5.4 DBMS_DATA_MINING — Algorithm Settings: Expectation Maximization
- 42.1.5.5 DBMS_DATA_MINING — Algorithm Settings: Explicit Semantic Analysis
- 42.1.5.6 DBMS_DATA_MINING — Algorithm Settings: Exponential Smoothing
- 42.1.5.7 DBMS_DATA_MINING — Algorithm Settings: Generalized Linear Model
- 42.1.5.8 DBMS_DATA_MINING — Algorithm Settings: k-Means
- 42.1.5.9 DBMS_DATA_MINING - Algorithm Settings: Multivariate State Estimation Technique - Sequential Probability Ratio Test
- 42.1.5.10 DBMS_DATA_MINING — Algorithm Settings: Naive Bayes
- 42.1.5.11 DBMS_DATA_MINING — Algorithm Settings: Neural Network
- 42.1.5.12 DBMS_DATA_MINING — Algorithm Settings: Non-Negative Matrix Factorization
- 42.1.5.13 DBMS_DATA_MINING — Algorithm Settings: O-Cluster
- 42.1.5.14 DBMS_DATA_MINING — Algorithm Settings: Random Forest
- 42.1.5.15 DBMS_DATA_MINING — Algorithm Constants and Settings: Singular Value Decomposition
- 42.1.5.16 DBMS_DATA_MINING — Algorithm Settings: Support Vector Machine
- 42.1.5.17 DBMS_DATA_MINING — Algorithm Settings: XGBoost
- 42.1.6 DBMS_DATA_MINING — Solver Settings
- 42.1.7 DBMS_DATA_MINING Datatypes
-
42.1.8
Summary of DBMS_DATA_MINING
Subprograms
- 42.1.8.1 ADD_COST_MATRIX Procedure
- 42.1.8.2 ADD_PARTITION Procedure
- 42.1.8.3 ALTER_REVERSE_EXPRESSION Procedure
- 42.1.8.4 APPLY Procedure
- 42.1.8.5 COMPUTE_CONFUSION_MATRIX Procedure
- 42.1.8.6 COMPUTE_CONFUSION_MATRIX_PART Procedure
- 42.1.8.7 COMPUTE_LIFT Procedure
- 42.1.8.8 COMPUTE_LIFT_PART Procedure
- 42.1.8.9 COMPUTE_ROC Procedure
- 42.1.8.10 COMPUTE_ROC_PART Procedure
- 42.1.8.11 CREATE_MODEL Procedure
- 42.1.8.12 CREATE_MODEL2 Procedure
- 42.1.8.13 Create Model Using Registration Information
- 42.1.8.14 DROP_ALGORITHM Procedure
- 42.1.8.15 DROP_PARTITION Procedure
- 42.1.8.16 DROP_MODEL Procedure
- 42.1.8.17 EXPORT_MODEL Procedure
- 42.1.8.18 EXPORT_SERMODEL Procedure
- 42.1.8.19 FETCH_JSON_SCHEMA Procedure
- 42.1.8.20 GET_ASSOCIATION_RULES Function
- 42.1.8.21 GET_FREQUENT_ITEMSETS Function
- 42.1.8.22 GET_MODEL_COST_MATRIX Function
- 42.1.8.23 GET_MODEL_DETAILS_AI Function
- 42.1.8.24 GET_MODEL_DETAILS_EM Function
- 42.1.8.25 GET_MODEL_DETAILS_EM_COMP Function
- 42.1.8.26 GET_MODEL_DETAILS_EM_PROJ Function
- 42.1.8.27 GET_MODEL_DETAILS_GLM Function
- 42.1.8.28 GET_MODEL_DETAILS_GLOBAL Function
- 42.1.8.29 GET_MODEL_DETAILS_KM Function
- 42.1.8.30 GET_MODEL_DETAILS_NB Function
- 42.1.8.31 GET_MODEL_DETAILS_NMF Function
- 42.1.8.32 GET_MODEL_DETAILS_OC Function
- 42.1.8.33 GET_MODEL_SETTINGS Function
- 42.1.8.34 GET_MODEL_SIGNATURE Function
- 42.1.8.35 GET_MODEL_DETAILS_SVD Function
- 42.1.8.36 GET_MODEL_DETAILS_SVM Function
- 42.1.8.37 GET_MODEL_DETAILS_XML Function
- 42.1.8.38 GET_MODEL_TRANSFORMATIONS Function
- 42.1.8.39 GET_TRANSFORM_LIST Procedure
- 42.1.8.40 IMPORT_MODEL Procedure
- 42.1.8.41 IMPORT_SERMODEL Procedure
- 42.1.8.42 IMPORT_ONNX_MODEL Procedure
- 42.1.8.43 JSON Schema for R Extensible Algorithm
- 42.1.8.44 REGISTER_ALGORITHM Procedure
- 42.1.8.45 RANK_APPLY Procedure
- 42.1.8.46 REMOVE_COST_MATRIX Procedure
- 42.1.8.47 RENAME_MODEL Procedure
-
42.2
DBMS_DATA_MINING_TRANSFORM
- 42.2.1 Using DBMS_DATA_MINING_TRANSFORM
- 42.2.2 DBMS_DATA_MINING_TRANSFORM Operational Notes
-
42.2.3
Summary of DBMS_DATA_MINING_TRANSFORM Subprograms
- 42.2.3.1 CREATE_BIN_CAT Procedure
- 42.2.3.2 CREATE_BIN_NUM Procedure
- 42.2.3.3 CREATE_CLIP Procedure
- 42.2.3.4 CREATE_COL_REM Procedure
- 42.2.3.5 CREATE_MISS_CAT Procedure
- 42.2.3.6 CREATE_MISS_NUM Procedure
- 42.2.3.7 CREATE_NORM_LIN Procedure
- 42.2.3.8 DESCRIBE_STACK Procedure
- 42.2.3.9 GET_EXPRESSION Function
- 42.2.3.10 INSERT_AUTOBIN_NUM_EQWIDTH Procedure
- 42.2.3.11 INSERT_BIN_CAT_FREQ Procedure
- 42.2.3.12 INSERT_BIN_NUM_EQWIDTH Procedure
- 42.2.3.13 INSERT_BIN_NUM_QTILE Procedure
- 42.2.3.14 INSERT_BIN_SUPER Procedure
- 42.2.3.15 INSERT_CLIP_TRIM_TAIL Procedure
- 42.2.3.16 INSERT_CLIP_WINSOR_TAIL Procedure
- 42.2.3.17 INSERT_MISS_CAT_MODE Procedure
- 42.2.3.18 INSERT_MISS_NUM_MEAN Procedure
- 42.2.3.19 INSERT_NORM_LIN_MINMAX Procedure
- 42.2.3.20 INSERT_NORM_LIN_SCALE Procedure
- 42.2.3.21 INSERT_NORM_LIN_ZSCORE Procedure
- 42.2.3.22 SET_EXPRESSION Procedure
- 42.2.3.23 SET_TRANSFORM Procedure
- 42.2.3.24 STACK_BIN_CAT Procedure
- 42.2.3.25 STACK_BIN_NUM Procedure
- 42.2.3.26 STACK_CLIP Procedure
- 42.2.3.27 STACK_COL_REM Procedure
- 42.2.3.28 STACK_MISS_CAT Procedure
- 42.2.3.29 STACK_MISS_NUM Procedure
- 42.2.3.30 STACK_NORM_LIN Procedure
- 42.2.3.31 XFORM_BIN_CAT Procedure
- 42.2.3.32 XFORM_BIN_NUM Procedure
- 42.2.3.33 XFORM_CLIP Procedure
- 42.2.3.34 XFORM_COL_REM Procedure
- 42.2.3.35 XFORM_EXPR_NUM Procedure
- 42.2.3.36 XFORM_EXPR_STR Procedure
- 42.2.3.37 XFORM_MISS_CAT Procedure
- 42.2.3.38 XFORM_MISS_NUM Procedure
- 42.2.3.39 XFORM_NORM_LIN Procedure
- 42.2.3.40 XFORM_STACK Procedure
- 42.3 DBMS_PREDICTIVE_ANALYTICS
-
42.1
DBMS_DATA_MINING
- 43 Data Dictionary Views
-
44
SQL Scoring Functions
- 44.1 CLUSTER_DETAILS
- 44.2 CLUSTER_DISTANCE
- 44.3 CLUSTER_ID
- 44.4 CLUSTER_PROBABILITY
- 44.5 CLUSTER_SET
- 44.6 FEATURE_COMPARE
- 44.7 FEATURE_DETAILS
- 44.8 FEATURE_ID
- 44.9 FEATURE_SET
- 44.10 FEATURE_VALUE
- 44.11 ORA_DM_PARTITION_NAME
- 44.12 PREDICTION
- 44.13 PREDICTION_BOUNDS
- 44.14 PREDICTION_COST
- 44.15 PREDICTION_DETAILS
- 44.16 PREDICTION_PROBABILITY
- 44.17 PREDICTION_SET
- 44.18 VECTOR_EMBEDDING
-
42
PL/SQL Packages
- Glossary