Share via


Data Mining Schema Rowsets

A server that is running Microsoft SQL Server Analysis Services supports the following data mining schema rowsets. To check whether a particular XML/A provider supports a specific rowset, use the DISCOVER_ENUMERATORS rowset with the Discover method.

In SQL Server 2012, the data mining schema rowsets are exposed as tables in the Transact-SQL language, in the $SYSTEM schema. For example, the following query on an Analysis Services instance returns a list of the schemas that are available on the current instance.

SELECT * FROM [$system].[DBSCHEMA_TABLES]

In This Section

Schema Rowset

Description

DMSCHEMA_MINING_COLUMNS Rowset

Describes the individual columns of all defined data mining models that are deployed on the server.

DMSCHEMA_MINING_FUNCTIONS Rowset

Describes the prediction functions and mining functions that can be used with each data mining algorithm that is installed on the server.

DMSCHEMA_MINING_MODEL_CONTENT Rowset

Allows the client application to browse the content of a trained data mining model.

DMSCHEMA_MINING_MODEL_CONTENT_PMML Rowset

Returns the XML (PMML 2.1) representation of the mining model content.

DMSCHEMA_MINING_MODEL_XML Rowset

Returns the XML (PMML 2.1) structure of the mining model. This is the same schema as DMSCHEMA_MINING_MODEL_PMML, which is preserved for backward compatibility.

DMSCHEMA_MINING_MODELS Rowset

Enumerates the data mining models that are deployed on the server.

DMSCHEMA_MINING_SERVICE_PARAMETERS Rowset

Provides a list of parameters that can be used to configure the behavior of each data mining algorithm that is installed on the server.

DMSCHEMA_MINING_SERVICES Rowset

Provides a description of each data mining algorithm that is available on the server.

DMSCHEMA_MINING_STRUCTURE_COLUMNS Rowset

Describes the individual columns of all mining structures that are deployed on the server.

DMSCHEMA_MINING_STRUCTURES Rowset

Enumerates information on mining structures.

All the schema rowsets listed here are supported by the server that is running SQL Server Analysis Services.

See Also

Reference

Analysis Services Schema Rowsets

Concepts

Querying the Data Mining Schema Rowsets (Analysis Services - Data Mining)

Other Resources

Querying the SQL Server System Catalog