ALL_MINING_MODEL_ATTRIBUTES
describes the attributes of the mining models accessible to the current user.
Attributes correspond to the columns of data used to build a model. Columns with the same names and data types should be available in any data set to which the model is applied.
DBA_MINING_MODEL_ATTRIBUTES
describes the attributes of all mining models in the database.
USER_MINING_MODEL_ATTRIBUTES
describes the attributes of the mining models owned by the current user. This view does not display the OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the mining model |
MODEL_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the mining model |
ATTRIBUTE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the attribute |
ATTRIBUTE_TYPE |
VARCHAR2(11) |
Logical type of the attribute. The type is identified during the model build or apply process:
|
|
DATA_TYPE |
VARCHAR2(12) |
Data type of the attribute:
|
|
DATA_LENGTH |
NUMBER |
Length of the data type | |
DATA_PRECISION |
NUMBER |
Precision of a fixed point number. Precision, which is the total number of significant decimal digits, is represented as p in the data type NUMBER(p,s) . |
|
DATA_SCALE |
NUMBER |
Scale of a fixed point number. Scale, which is the number of digits from the decimal to the least significant digit, is represented as s in the data type NUMBER(p,s) . |
|
USAGE_TYPE |
VARCHAR2(8) |
Indicates whether the attribute was used to construct the model (ACTIVE ) or not (INACTIVE ). Some attributes may be eliminated by transformations or algorithmic processing. The *_MINING_MODEL_ATTRIBUTES view only lists the attributes used by the model, therefore the value of this column is always ACTIVE . |
|
TARGET |
VARCHAR2(3) |
Indicates whether the attribute is the target of a predictive model (YES ) or not (NO ). The target describes the result that is produced when the model is applied. |
See Also:
Oracle Data Mining Concepts for information about model attributes