DMSCHEMA_MINING_MODELS Rowset

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: DM_SERVICETYPE_CLASSIFICATION DM_SERVICETYPE_SEGMENTATION
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. The filter is used when training 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. If a holdout data set has been defined on the mining structure, that data will not be included in the training data set.

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.

See Also

Reference

Data Mining Schema Rowsets