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 |
|---|---|
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.