Share via


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