.png)
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]
Schema Rowset | Description |
|---|---|
Describes the individual columns of all defined data mining models that are deployed on the server. | |
Describes the prediction functions and mining functions that can be used with each data mining algorithm that is installed on the server. | |
Allows the client application to browse the content of a trained data mining model. | |
Returns the XML (PMML 2.1) representation of the mining model content. | |
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. | |
Enumerates the data mining models that are deployed on the server. | |
Provides a list of parameters that can be used to configure the behavior of each data mining algorithm that is installed on the server. | |
Provides a description of each data mining algorithm that is available on the server. | |
Describes the individual columns of all mining structures that are deployed on the server. | |
Enumerates information on mining structures. |
All the schema rowsets listed here are supported by the server that is running SQL Server Analysis Services.
