OracleODM Data Mining notes

I recently learned about Oracle Data Mining and found that there is very little information on the Internet. I suggest you sort it out by yourself. DataMiningPLSQLPackagesOracle Data Mining support

I recently learned about Oracle Data Mining and found that there is very little information on the Internet. I suggest you do it yourself. Data Mining PL/SQL PackagesOracle Data Mining support

I recently learned about Oracle Data Mining and found that there is very little information on the Internet. Please do it yourself.

Data Mining PL/SQL Packages

Oracle Data Mining supports supervised and unsupervised data mining. Supervised Data Mining predicts the target value based on historical data. Unsupervised Data Mining discovers unknown fields or uncertain targets.

Supervised functions:
Classification
Regression
Attribute Importance

Unsupervised functions:
Clustering
Association
Feature Extraction
Anomaly Detection (one-class classification)

There are three packages
DBMS_DATA_MINING, the primary interface to Oracle Data Mining
DBMS_DATA_MINING_TRANSFORM, convenience routines for data transformation
DBMS_PREDICTIVE_ANALYTICS, predictive analytics

View the content in the package
Select * from all_source where type = 'package ';

Related views:

View the data model user_mining_models;
View the data model attributes USER_MINING_MODEL_ATTRIBUTES
Set and control various Feature Mining models USER_MINING_MODEL_SETTINGS

Data dictionary not supported in 11g

Replace GET_DEFAULT_SETTINGS with USER/ALL/DBA_MINING_MODEL_SETTINGS
Replace GET_MODEL_SETTINGS with: USER/ALL/DBA_MINING_MODEL_SETTINGS
Replace GET_MODEL_SIGNATURE with USER/ALL/DBA_MINING_MODEL_ATTRIBUTES
Replace DM_USER_MODELS with USER/ALL/DBA_MINING_MODELS