Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Enumerates the data mining models in the current catalog. The DMSCHEMA_MINING_MODELS schema rowset is very similar to the DBSCHEMA_TABLES schema rowset and can be used the same way. Use the DMSCHEMA_MINING_MODELS rowset to obtain information about the mining models contained in a database. The DMSCHEMA_MINING_MODELS rowset can include information such as the names, types, and mining algorithms associated with each mining model.
Rowset Columns
The DMSCHEMA_MINING_MODELS rowset contains the following columns.
Column name |
Type indicator |
Length |
Description |
|---|---|---|---|
MODEL_CATALOG |
DBTYPE_WSTR |
The catalog name. Populated with the name of the database of which the model is a member. |
|
MODEL_SCHEMA |
DBTYPE_WSTR |
The unqualified schema name. This column is not supported by Microsoft SQL Server Analysis Services; it always contains NULL. |
|
MODEL_NAME |
DBTYPE_WSTR |
The mining model name. This column contains the name of the mining model, and it is never empty. |
|
MODEL_TYPE |
DBTYPE_WSTR |
The model type. |
|
MODEL_GUID |
DBTYPE_GUID |
The GUID of the model. |
|
DESCRIPTION |
DBTYPE_WSTR |
A user-friendly description of the model. |
|
MODEL_PROPID |
DBTYPE_UI4 |
The property ID of the model. This column is not supported by Analysis Services; it always contains NULL. |
|
DATE_CREATED |
DBTYPE_DBTIMESTAMP |
The date on which the model was created. |
|
DATE_MODIFIED |
DBTYPE_DBTIMESTAMP |
The date on which the model definition was last modified. |
|
SERVICE_TYPE_ID |
DBTYPE_UI4 |
An enumeration that identifies the type of data mining algorithm that is used by the model. This type can be one of the following values:
|
|
SERVICE_NAME |
DBTYPE_WSTR |
The provider-specific name for the data mining algorithm that is used by the model. |
|
CREATION_STATEMENT |
DBTYPE_WSTR |
The statement that was used to create the mining model. |
|
PREDICTION_ENTITY |
DBTYPE_WSTR |
A comma-delimited list indicating which mining columns can be predicted. |
|
IS_POPULATED |
DBTYPE_BOOL |
A Boolean flag that indicates whether the model is populated. TRUE if the model is populated; otherwise, FALSE. |
|
MINING_PARAMETERS |
DBTYPE_WSTR |
A list of the parameters that were used when the model was created. |
|
MINING_STRUCTURE |
DBTYPE_WSTR |
The ID of the mining structure on which the model is based. |
|
LAST_PROCESSED |
DBTYPE_DBTIMESTAMP |
The date the model was last processed. |
|
MSOLAP_IS_DRILLTHROUGH_ENABLED |
DBTYPE_BOOL |
A Boolean flag that indicates whether the model supports drillthrough. |
|
FILTER |
DBTYPE_WSTR |
The filter expression that is associated with the mining model. NULL or empty string indicates that no filter is applied. |
|
TRAINING_SET_SIZE |
DBTYPE_UIS |
The number of cases that are contained in the mining model training set after the structure has been processed and any filters have been applied to the model. |
Restriction Columns
The DMSCHEMA_MINING_MODELS rowset can be restricted on the columns in the following table.
Column name |
Type indicator |
Restriction State |
|---|---|---|
MODEL_CATALOG |
DBTYPE_WSTR |
Optional. |
MODEL_SCHEMA |
DBTYPE_WSTR |
Optional. |
MODEL_NAME |
DBTYPE_WSTR |
Optional. |
MODEL_TYPE |
DBTYPE_WSTR |
Optional. |
SERVICE_NAME |
DBTYPE_WSTR |
Optional. |
SERVICE_TYPE_ID |
DBTYPE_UI4 |
Optional. |
MINING_STRUCTURE |
DBTYPE_WSTR |
Optional. |