Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-01 |
|
|
View PDF |
Syntax
mining_attribute_clause:=
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.
See Also:
|
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