Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 Oracle PL/SQL: CLUSTER_PROBABILITY Jump to:  
Category: >> Oracle PL/SQL >> CLUSTER_PROBABILITY Bookmark and Share

<< lastnext >>

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.
 
*/


Free
Oracle Magazine
Subscriptions
and Oracle White Papers


SQL University.net courses meet the most demanding needs of the business world for advanced education in a cost-effective manner. SQL University.net courses are available immediately for IT professionals and can be taken without disruption of your workplace schedule or processes.

Compared to traditional travel-based training, SQL University.net saves time and valuable corporate resources, allowing companies to do more with less. That's our mission, and that's what we deliver.

Click here to find out more
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 89 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?