DMSCHEMA_MINING_MODELS Rowset

 

Applies To: SQL Server 2016 Preview

Enumerates the data mining models in the current catalog. The DMSCHEMA_MINING_MODELS rowset includes information such as model names, processing date, and the mining algorithm associated with each mining model.

. The DMSCHEMA_MINING_MODELS schema rowset is very similar to the DBSCHEMA_TABLES schema rowset and can be used the same way.

The DMSCHEMA_MINING_MODELS rowset contains the following columns.

Column nameType indicatorDescription
MODEL_CATALOGDBTYPE_WSTRThe catalog name. Populated with the name of the database of which the model is a member.
MODEL_SCHEMADBTYPE_WSTRThe unqualified schema name. This column is not supported by Microsoft SQL Server Analysis Services; it always contains NULL.
MODEL_NAMEDBTYPE_WSTRThe mining model name. This column contains the name of the mining model, and it is never empty.
MODEL_TYPEDBTYPE_WSTRThe model type.
MODEL_GUIDDBTYPE_GUIDThe GUID of the model.
DESCRIPTIONDBTYPE_WSTRA user-friendly description of the model.
MODEL_PROPIDDBTYPE_UI4The property ID of the model. This column is not supported by Analysis Services; it always contains NULL.
DATE_CREATEDDBTYPE_DBTIMESTAMPThe date on which the model was created.
DATE_MODIFIEDDBTYPE_DBTIMESTAMPThe date on which the model definition was last modified.
SERVICE_TYPE_IDDBTYPE_UI4An 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 (1)

 DM_SERVICETYPE_SEGMENTATION(2)

 DM_SERVICETYPE_ ASSOCIATION(4)

 DM_SERVICETYPE_ DENSITY_ESTIMATE(8)

 DM_SERVICETYPE_SEQUENCE(16)
SERVICE_NAMEDBTYPE_WSTRThe provider-specific name for the data mining algorithm that is used by the model.
CREATION_STATEMENTDBTYPE_WSTRThe statement that was used to create the mining model.
PREDICTION_ENTITYDBTYPE_WSTRA comma-delimited list indicating which mining columns can be predicted.
IS_POPULATEDDBTYPE_BOOLA Boolean flag that indicates whether the model is populated.

 TRUE if the model is populated; otherwise, FALSE.
MINING_PARAMETERSDBTYPE_WSTRA comma-separated list of the parameters that were used when the model was created.
MINING_STRUCTUREDBTYPE_WSTRThe ID of the mining structure on which the model is based.
LAST_PROCESSEDDBTYPE_DBTIMESTAMPThe date the model was last processed.
MSOLAP_IS_DRILLTHROUGH_ENABLEDDBTYPE_BOOLA Boolean flag that indicates whether the model supports drillthrough.
FILTERDBTYPE_WSTRThe filter expression that is associated with the mining model.

NULL or empty string indicates that no filter is applied.
TRAINING_SET_SIZEDBTYPE_UISThe number of cases that are contained in the mining model training set after the structure has been processed and after any filters have been applied to the model.

The DMSCHEMA_MINING_MODELS rowset can be restricted on the columns in the following table.

Column nameType indicatorRestriction State
MODEL_CATALOGDBTYPE_WSTROptional.
MODEL_SCHEMADBTYPE_WSTROptional.
MODEL_NAMEDBTYPE_WSTROptional.
MODEL_TYPEDBTYPE_WSTROptional.
SERVICE_NAMEDBTYPE_WSTROptional.
SERVICE_TYPE_IDDBTYPE_UI4Optional.
MINING_STRUCTUREDBTYPE_WSTROptional.

For examples of how to query this rowset, see Query the Parameters Used to Create a Mining Model.

Data Mining Schema Rowsets

Community Additions

ADD
Show: