Oracle® Database SQL Language Reference 11g Release 2 (11.2) Part Number E17118-04 |
|
|
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 value in the row.
The mining_attribute_clause
behaves as described for the PREDICTION
function. Refer to mining_attribute_clause.
See Also:
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