USER_MINING_MODELS

Example 2-1 describes USER_MINING_MODELS and shows a sample query.

Example 2-1 USER_MINING_MODELS

describe user_mining_models
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 MODEL_NAME                       NOT NULL VARCHAR2(128)
 MINING_FUNCTION                           VARCHAR2(30)
 ALGORITHM                                 VARCHAR2(30)
 CREATION_DATE                    NOT NULL DATE
 BUILD_DURATION                            NUMBER
 MODEL_SIZE                                NUMBER
 COMMENTS                                  VARCHAR2(4000)

The following query returns the models in the user's schema that use the Support Vector Machine algorithm.

SELECT  mining_function, model_name, algorithm
     FROM user_mining_models
     WHERE algorithm IN 'SUPPORT_VECTOR_MACHINES'
     ORDER BY mining_function;

MINING_FUNCTION           MODEL_NAME           ALGORITHM
------------------------- -------------------- ------------------------------
CLASSIFICATION            SVMO_SH_CLAS_SAMPLE  SUPPORT_VECTOR_MACHINES
CLASSIFICATION            T_SVM_CLAS_SAMPLE    SUPPORT_VECTOR_MACHINES
CLASSIFICATION            SVMC_SH_CLAS_SAMPLE  SUPPORT_VECTOR_MACHINES
REGRESSION                SVMR_SH_REGR_SAMPLE  SUPPORT_VECTOR_MACHINES

See Also: