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

<< lastnext >>

Snippet Name: FEATURE_SET

Description: FEATURE_SET returns a varray of objects containing all possible features. Each object in the varray is a pair of scalar values containing the feature ID and the feature value. The object fields are named FEATUREĀ­_ID and VALUE, and both are Oracle NUMBER.

This function is used with feature extraction models that have been created using the DBMS_DATA_MINING package or with the Oracle Data Mining Java API.

The optional topN argument is a positive integer that restricts the set of features to those that have one of the top N values. If there is a tie at the Nth value, then the database still returns only N values. If you omit this argument, then the function returns all features.

The optional cutoff argument restricts the returned features to only those that have a feature value greater than or equal to the specified cutoff. To filter only by cutoff, specify NULL for topN and the desired cutoff for cutoff.

Also see:
» PREDICTION_SET
» PREDICTION_PROBABILITY
» PREDICTION_DETAILS
» PREDICTION_COST
» PREDICTION_BOUNDS
» PREDICTION
» FEATURE_ID
» CLUSTER_SET
» CLUSTER_PROBABILITY
» CLUSTER_ID

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 07th, 2009

FEATURE_SET(<schema.model>, <top N>, <cutoff>
<mining_attribute_clause>)
 
WITH
feat_tab AS (
SELECT F.feature_id fid,
       A.attribute_name attr,
       TO_CHAR(A.attribute_value) val,
       A.coefficient coeff
  FROM TABLE(DBMS_DATA_MINING.GET_MODEL_DETAILS_NMF('nmf_sh_sample')) F,
       TABLE(F.attribute_set) A
 WHERE A.coefficient > 0.25
),
feat AS (
SELECT fid,
       CAST(COLLECT(Featattr(attr, val, coeff))
         AS Featattrs) f_attrs
  FROM feat_tab
GROUP BY fid
),
cust_10_features AS (
SELECT T.cust_id, S.feature_id, S.VALUE
  FROM (SELECT cust_id, FEATURE_SET(nmf_sh_sample, 10 USING *) pset
          FROM nmf_sh_sample_apply_prepared
         WHERE cust_id = 100002) T,
       TABLE(T.pset) S
)
SELECT A.VALUE, A.feature_id fid,
       B.attr, B.val, B.coeff
  FROM cust_10_features A,
       (SELECT T.fid, F.*
          FROM feat T,
               TABLE(T.f_attrs) F) B
 WHERE A.feature_id = B.fid
ORDER BY A.VALUE DESC, A.feature_id ASC, coeff DESC, attr ASC, val ASC;
 
   VALUE  FID ATTR                      VAL                    COEFF
-------- ---- ------------------------- -------------------- -------
  6.8409    7 YRS_RESIDENCE                                   1.3879
  6.8409    7 BOOKKEEPING_APPLICATION                          .4388
  6.8409    7 CUST_GENDER               M                      .2956
  6.8409    7 COUNTRY_NAME              United States OF Ame   .2848
                                        rica
 
  6.4975    3 YRS_RESIDENCE                                   1.2668
  6.4975    3 BOOKKEEPING_APPLICATION                          .3465
  6.4975    3 COUNTRY_NAME              United States OF Ame   .2927
                                        rica
 
  6.4886    2 YRS_RESIDENCE                                   1.3285
  6.4886    2 CUST_GENDER               M                      .2819
  6.4886    2 PRINTER_SUPPLIES                                 .2704
  6.3953    4 YRS_RESIDENCE                                   1.2931
  5.9640    6 YRS_RESIDENCE                                   1.1585
  5.9640    6 HOME_THEATER_PACKAGE                             .2576
  5.2424    5 YRS_RESIDENCE                                   1.0067
  2.4714    8 YRS_RESIDENCE                                    .3297
  2.3559    1 YRS_RESIDENCE                                    .2768
  2.3559    1 FLAT_PANEL_MONITOR                               .2593
 
17 rows selected.
 


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 298 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?