Data Mining Schema Rowsets

 

Applies To: SQL Server 2016 Preview

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 2016, 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]  

Schema RowsetDescription
DMSCHEMA_MINING_COLUMNS RowsetDescribes the individual columns of all defined data mining models that are deployed on the server.
DMSCHEMA_MINING_FUNCTIONS RowsetDescribes 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 RowsetAllows the client application to browse the content of a trained data mining model.
DMSCHEMA_MINING_MODEL_CONTENT_PMML RowsetReturns the XML (PMML 2.1) representation of the mining model content.
DMSCHEMA_MINING_MODEL_XML RowsetReturns 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 RowsetEnumerates the data mining models that are deployed on the server.
DMSCHEMA_MINING_SERVICE_PARAMETERS RowsetProvides 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 RowsetProvides a description of each data mining algorithm that is available on the server.
DMSCHEMA_MINING_STRUCTURE_COLUMNS RowsetDescribes the individual columns of all mining structures that are deployed on the server.
DMSCHEMA_MINING_STRUCTURES RowsetEnumerates information on mining structures.

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

Analysis Services Schema Rowsets
Data Mining Schema Rowsets (SSAs)

Community Additions

ADD
Show: