|Oracle® Database SQL Language Reference
11g Release 2 (11.2)
Part Number E17118-03
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 value in the row.
mining_attribute_clause behaves as described for the
PREDICTION function. Refer to mining_attribute_clause.
Oracle Data Mining Concepts for detailed information about Oracle Data Mining
Oracle Data Mining Administrator's Guide for information on the demo programs available in the code
Oracle Data Mining Application Developer's Guide for detailed information about real-time scoring with the Data Mining SQL functions
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