|Oracle® Database SQL Reference
10g Release 2 (10.2)
|PDF · Mobi · ePub|
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.
mining_attribute_clause behaves as described for the
PREDICTION function. Please refer to mining_attribute_clause.
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