|Oracle® Database SQL Language Reference
11g Release 2 (11.2)
|PDF · Mobi · ePub|
This function is for use with feature extraction models created by the
DBMS_DATA_MINING package or with Oracle Data Miner. It returns an Oracle
NUMBER that is the identifier of the feature with the highest value in the row.
mining_attribute_clause behaves as described for the
PREDICTION function. 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 DESC; FEAT CNT ---------- ---------- 7 1443 2 49 3 6 6 1 1 1