The following example describes ALL_MINING_MODEL_ATTRIBUTES and shows a sample query. Attributes are the predictors or conditions that are used to create models and score data.
Example 2-2 ALL_MINING_MODEL_ATTRIBUTES
describe ALL_MINING_MODEL_ATTRIBUTES Name Null? Type ----------------------------------------- -------- ---------------------------- OWNER NOT NULL VARCHAR2(128) MODEL_NAME NOT NULL VARCHAR2(128) ATTRIBUTE_NAME NOT NULL VARCHAR2(128) ATTRIBUTE_TYPE VARCHAR2(11) DATA_TYPE VARCHAR2(106) DATA_LENGTH NUMBER DATA_PRECISION NUMBER DATA_SCALE NUMBER USAGE_TYPE VARCHAR2(8) TARGET VARCHAR2(3) ATTRIBUTE_SPEC VARCHAR2(4000)
The following query returns the attributes of an SVM classification model named T_SVM_CLAS_SAMPLE. The model has both categorical and numerical attributes and includes one attribute that is unstructured text.
SELECT attribute_name, attribute_type, target
FROM all_mining_model_attributes
WHERE model_name = 'T_SVM_CLAS_SAMPLE'
ORDER BY attribute_name;
ATTRIBUTE_NAME ATTRIBUTE_TYPE TAR
------------------------- -------------------- ---
AFFINITY_CARD CATEGORICAL YES
AGE NUMERICAL NO
BOOKKEEPING_APPLICATION NUMERICAL NO
BULK_PACK_DISKETTES NUMERICAL NO
COMMENTS TEXT NO
COUNTRY_NAME CATEGORICAL NO
CUST_GENDER CATEGORICAL NO
CUST_INCOME_LEVEL CATEGORICAL NO
CUST_MARITAL_STATUS CATEGORICAL NO
EDUCATION CATEGORICAL NO
FLAT_PANEL_MONITOR NUMERICAL NO
HOME_THEATER_PACKAGE NUMERICAL NO
HOUSEHOLD_SIZE CATEGORICAL NO
OCCUPATION CATEGORICAL NO
OS_DOC_SET_KANJI NUMERICAL NO
PRINTER_SUPPLIES NUMERICAL NO
YRS_RESIDENCE NUMERICAL NO
Y_BOX_GAMES NUMERICAL NO See Also:
ALL_MINING_MODEL_ATTRIBUTES in Oracle Database Reference