DBMS_PREDICTIVE_ANALYTICS

The DBMS_PREDICTIVE_ANALYTICS package contains routines that perform an automated form of data mining known as predictive analytics. With predictive analytics, you do not need to be aware of model building or scoring. All mining activities are handled internally by the procedure. The DBMS_PREDICTIVE_ANALYTICS package includes these routines:

EXPLAIN ranks attributes in order of influence in explaining a target column.
PREDICT predicts the value of a target column based on values in the input data.
PROFILE generates rules that describe the cases from the input data.

The EXPLAIN statement in Example 2-6 lists attributes in the view mining_data_build_v in order of their importance in predicting affinity_card.

Example 2-6 Sample EXPLAIN Statement

BEGIN 
    DBMS_PREDICTIVE_ANALYTICS.EXPLAIN( 
        data_table_name      => 'mining_data_build_v', 
        explain_column_name  => 'affinity_card', 
        result_table_name    => 'explain_results'); 
END; 
/