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 2008, the data mining schema rowsets are also 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.