Snippet Name: CLUSTER_PROBABILITY
Description: CLUSTER_PROBABILITY returns a measure of the degree of confidence of membership of an input row in a cluster associated with the specified model.
This function is for use with clustering models that have been created with the DBMS_DATA_MINING package or with the Oracle Data Mining Java API.
This example can be found in the demo file $ORACLE_HOME/rdbms/demo/dmkmdemo.sql.
Also see:
» PREDICTION_SET
» PREDICTION_PROBABILITY
» PREDICTION_DETAILS
» PREDICTION_COST
» PREDICTION_BOUNDS
» PREDICTION
» FEATURE_SET
» FEATURE_ID
» CLUSTER_SET
» CLUSTER_ID
Comment: (none)
Language: PL/SQL
Highlight Mode: PHP
Last Modified: March 07th, 2009
|
CLUSTER_PROBABILITY(<schema.model>, <cluster_id> <mining_attribute_clause>)
CLUSTER_PROBABILITY ( [ schema . ] model
[ , cluster_id ] mining_attribute_clause )
SELECT *
FROM (SELECT cust_id, CLUSTER_PROBABILITY(km_sh_clus_sample, 2 USING *) prob
FROM km_sh_sample_apply_prepared
ORDER BY prob DESC)
WHERE ROWNUM < 11;
/*
For cluster_id, specify the identifier of the cluster in the
model. The function returns the probability for the specified
cluster. If you omit this clause, then the function returns
the probability associated with the best predicted cluster.
You can use the form without cluster_id in conjunction with
the CLUSTER_ID function to obtain the best predicted pair of
cluster ID and probability.
The mining_attribute_clause behaves as described for the
PREDICTION function.
*/ |
