FEATURE_ID

Syntax

Description of the illustration feature_id.gif

mining_attribute_clause:=

Description of the illustration mining_attribute_clause.gif

Purpose

This function is for use with feature extraction models that have been created using the DBMS_DATA_MINING package or with the Oracle Data Mining Java API. It returns an Oracle NUMBER that is the identifier of the feature with the highest coefficient value.

The mining_attribute_clause behaves as described for the PREDICTION function. Please refer to mining_attribute_clause.

Examples

The following example lists the features and corresponding count of customers in a dataset.

This example and the prerequisite data mining operations, including creation of the nmf_sh_sample model and nmf_sh_sample_apply_prepared view, can be found in the demo file $ORACLE_HOME/rdbms/demo/dmnmdemo.sql. General information on data mining demo files is available in Oracle Data Mining Administrator's Guide. The example is presented here to illustrate the syntactic use of the function.

SELECT FEATURE_ID(nmf_sh_sample USING *) AS feat, COUNT(*) AS cnt
  FROM nmf_sh_sample_apply_prepared
GROUP BY FEATURE_ID(nmf_sh_sample USING *)
ORDER BY cnt DESC;

      FEAT        CNT
---------- ----------
         7       1443
         2         49
         3          6
         1          1
         6          1