Oracle ODM Data Mining notes

Source: Internet
Author: User

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.

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.