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 |
|---|---|
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.
See Also
Reference
Analysis Services Schema Rowsets
Concepts
Querying the Data Mining Schema Rowsets (Analysis Services - Data Mining)