3.1.4.2.2.1.3.19.1 Columns
The DMSCHEMA_MINING_SERVICES rowset contains the following columns.
Name |
Type |
Restriction |
Description |
---|---|---|---|
SERVICE_NAME |
xsd:string |
Yes |
The name of the algorithm. |
SERVICE_TYPE_ID |
xsd:unsignedInt |
Yes |
This column contains a binary value that describes the mining service.<256> |
SERVICE_DISPLAY_NAME |
xsd:string |
|
A localizable display name for the algorithm. |
SERVICE_GUID |
uuid |
|
The GUID for the algorithm. |
DESCRIPTION |
xsd:string |
|
A human-readable description of the algorithm. |
PREDICTION_LIMIT |
xsd:unsignedInt |
|
The maximum number of predictions the model and algorithm can provide. |
SUPPORTED_DISTRIBUTION_FLAGS |
xsd:string |
|
A comma-delimited list of flags that describe the statistical distributions supported by the algorithm. This column contains one or more of the following values:<257>
|
SUPPORTED_INPUT_CONTENT_TYPES |
xsd:string |
|
A comma-delimited list of flags that describe the input content types that are supported by the algorithm. This column contains one or more of the following values:<258>
|
SUPPORTED_PREDICTION_CONTENT_TYPES |
xsd:string |
|
A comma-delimited list of flags that describe the prediction content types that are supported by the algorithm. This column contains one or more of the following values:<259>
|
SUPPORTED_MODELING_FLAGS |
xsd:string |
|
A comma-delimited list of the modeling flags that are supported by the algorithm. Currently defined flags will include one or more of the following values:
Server-specific flags can also appear in this column. |
SUPPORTED_SOURCE_QUERY |
xsd:string |
|
Reserved for future use. |
TRAINING_COMPLEXITY |
xsd:int |
|
The length of time that training is expected to take is as follows:
|
PREDICTION_COMPLEXITY |
xsd:int |
|
The length of time that prediction is expected to take is as follows:
|
EXPECTED_QUALITY |
xsd:int |
|
The expected quality of the model produced with this algorithm is as follows:
|
SCALING |
xsd:int |
|
The scalability of the algorithm is as follows:
|
ALLOW_INCREMENTAL_INSERT |
xsd:boolean |
|
When true, indicates that the algorithm supports incremental training, that is, updating the discovered patterns based on new factual data, rather than fully rediscovering the patterns; otherwise false. |
ALLOW_PMML_INITIALIZATION |
xsd:boolean |
|
When true, indicates that mining models can be created based on a Predictive Model Markup Language (PMML) 2.1 string; otherwise false. When true, the mining algorithm supports initialization from PMML 2.1 content. |
CONTROL |
xsd:int |
|
The support given by the service if training is interrupted is as follows:
|
ALLOW_DUPLICATE_KEY |
xsd:boolean |
|
When true, indicates that cases are allowed to contain duplicate keys; otherwise false. |
VIEWER_TYPE |
xsd:string |
|
The recommended viewer for this model. |
HELP_FILE |
xsd:string |
|
The name of the file that contains the documentation for this service. The HELP_FILE column is optional. |
HELP_CONTEXT |
xsd:int |
|
The Help context ID for this service. The HELP_CONTEXT column is optional. |
MSOLAP_SUPPORTS_ANALYSIS_SERVICES_DDL |
xsd:string |
|
The version of DDL supported. The string "zero" indicates no DDL support. |
MSOLAP_SUPPORTS_OLAP_MINING_MODELS |
xsd:boolean |
|
When true, indicates that OLAP mining models can be created and MSOLAP_SUPPORTS_ANALYSIS_SERVICES_DDL MUST be non-zero; otherwise false. |
MSOLAP_SUPPORTS_DATA_MINING_DIMENSIONS |
xsd:boolean |
|
When true, indicates that data mining dimensions can be created; otherwise false. |
MSOLAP_SUPPORTS_DRILLTHROUGH |
xsd:boolean |
|
When true, indicates that the service supports drillthrough capabilities; otherwise false. |
The rowset is not sorted.
The response has the following definition.
-
<xsd:element name="root"> <xsd:complexType> <xsd:sequence minOccurs="0" maxOccurs="unbounded"> <xsd:element name="row" type="row" /> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:simpleType name="uuid"> <xsd:restriction base="xsd:string"> <xsd:pattern value="[0-9a-zA-Z]{8}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{4}- [0-9a-zA-Z]{4}-[0-9a-zA-Z]{12}" /> </xsd:restriction> </xsd:simpleType> <xsd:complexType name="row"> <xsd:sequence> <xsd:element sql:field="SERVICE_NAME" name="SERVICE_NAME" type="xsd:string" /> <xsd:element sql:field="SERVICE_TYPE_ID" name="SERVICE_TYPE_ID" type="xsd:unsignedInt" /> <xsd:element sql:field="SERVICE_DISPLAY_NAME" name="SERVICE_DISPLAY_NAME" type="xsd:string" /> <xsd:element sql:field="SERVICE_GUID" name="SERVICE_GUID" type="uuid" minOccurs="0" /> <xsd:element sql:field="DESCRIPTION" name="DESCRIPTION" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="PREDICTION_LIMIT" name="PREDICTION_LIMIT" type="xsd:unsignedInt" /> <xsd:element sql:field="SUPPORTED_DISTRIBUTION_FLAGS" name="SUPPORTED_DISTRIBUTION_FLAGS" type="xsd:string" /> <xsd:element sql:field="SUPPORTED_INPUT_CONTENT_TYPES" name="SUPPORTED_INPUT_CONTENT_TYPES" type="xsd:string" /> <xsd:element sql:field="SUPPORTED_PREDICTION_CONTENT_TYPES" name="SUPPORTED_PREDICTION_CONTENT_TYPES" type="xsd:string" /> <xsd:element sql:field="SUPPORTED_MODELING_FLAGS" name="SUPPORTED_MODELING_FLAGS" type="xsd:string" /> <xsd:element sql:field="SUPPORTED_SOURCE_QUERY" name="SUPPORTED_SOURCE_QUERY" type="xsd:string" /> <xsd:element sql:field="TRAINING_COMPLEXITY" name="TRAINING_COMPLEXITY" type="xsd:int" /> <xsd:element sql:field="PREDICTION_COMPLEXITY" name="PREDICTION_COMPLEXITY" type="xsd:int" /> <xsd:element sql:field="EXPECTED_QUALITY" name="EXPECTED_QUALITY" type="xsd:int" /> <xsd:element sql:field="SCALING" name="SCALING" type="xsd:int" /> <xsd:element sql:field="ALLOW_INCREMENTAL_INSERT" name="ALLOW_INCREMENTAL_INSERT" type="xsd:boolean" /> <xsd:element sql:field="ALLOW_PMML_INITIALIZATION" name="ALLOW_PMML_INITIALIZATION" type="xsd:boolean" /> <xsd:element sql:field="CONTROL" name="CONTROL" type="xsd:int" /> <xsd:element sql:field="ALLOW_DUPLICATE_KEY" name="ALLOW_DUPLICATE_KEY" type="xsd:boolean" /> <xsd:element sql:field="VIEWER_TYPE" name="VIEWER_TYPE" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="HELP_FILE" name="HELP_FILE" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="HELP_CONTEXT" name="HELP_CONTEXT" type="xsd:int" minOccurs="0" /> <xsd:element sql:field="MSOLAP_SUPPORTS_ANALYSIS_SERVICES_DDL" name="MSOLAP_SUPPORTS_ANALYSIS_SERVICES_DDL" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="MSOLAP_SUPPORTS_OLAP_MINING_MODELS" name="MSOLAP_SUPPORTS_OLAP_MINING_MODELS" type="xsd:boolean" minOccurs="0" /> <xsd:element sql:field="MSOLAP_SUPPORTS_DATA_MINING_DIMENSIONS" name="MSOLAP_SUPPORTS_DATA_MINING_DIMENSIONS" type="xsd:boolean" minOccurs="0" /> <xsd:element sql:field="MSOLAP_SUPPORTS_DRILLTHROUGH" name="MSOLAP_SUPPORTS_DRILLTHROUGH" type="xsd:boolean" minOccurs="0" /> </xsd:sequence> </xsd:complexType>