3.1.4.2.2.1.3.19.1 Columns

  • Article

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>

  • NORMAL

  • LOG NORMAL

  • UNIFORM

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>

  • KEY – Uniquely identifies a case in a mining model.

  • DISCRETE – Specifies discrete values.

  • CONTINUOUS – Specifies continuous values.

  • DISCRETIZED – Specifies discretized values.

  • ORDERED – Not supported.

  • KEY SEQUENCE - Uniquely identifies a step in a sequence of events that constitute the current case.

  • CYCLICAL – Not supported.

  • PROBABILITY – Not supported.

  • VARIANCE – Not supported.

  • STDEV – Not supported.

  • SUPPORT – Not supported.

  • PROBABILITY VARIANCE – Not supported.

  • PROBABILITY STDEV – Not supported.

  • KEY TIME – Represents a time slice in time series data.

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>

  • KEY – Uniquely identifies a case in a mining model.

  • DISCRETE – Specifies discrete values.

  • CONTINUOUS – Specifies continuous values.

  • DISCRETIZED – Specifies discretized values.

  • ORDERED – Not supported.

  • KEY SEQUENCE - Uniquely identifies a step in a sequence of events that constitute the current case.

  • CYCLICAL – Not supported.

  • PROBABILITY – Not supported.

  • VARIANCE – Not supported.

  • STDEV – Not supported.

  • SUPPORT – Not supported.

  • PROBABILITY VARIANCE – Not supported.

  • PROBABILITY STDEV – Not supported.

  • KEY TIME - Represents a time slice in time series data.

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:

  • MODEL_EXISTENCE_ONLY - Model the column as a binary ("value exists for this column", "value does not exist for this column").

  • REGRESSOR - Mark the column for inclusion as an explicit term in the regression equation for output attributes in the model.

  • NOT NULL – The column does not contain null 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:

  • 0 - DM_TRAINING_COMPLEXITY_LOW indicates that the running time is relatively short, and that it is proportional to input.

  • 1 - DM_TRAINING_COMPLEXITY_MEDIUM indicates that the running time might be long, but that it is generally proportional to input.

  • 2 - DM_TRAINING_COMPLEXITY_HIGH indicates that the running time is long and that it might grow exponentially in relationship to the number of training cases.

PREDICTION_COMPLEXITY

xsd:int

The length of time that prediction is expected to take is as follows:

  • 0 -DM_PREDICTION_COMPLEXITY_LOW indicates that the running time is relatively short, and that it is proportional to input.

  • 1 - DM_PREDICTION_COMPLEXITY_MEDIUM indicates that the running time might be long, but that it is generally proportional to input.

  • 2 - DM_PREDICTION_COMPLEXITY_HIGH indicates that the running time is long and that it might grow exponentially in relationship to the number of training cases.

EXPECTED_QUALITY

xsd:int

The expected quality of the model produced with this algorithm is as follows:

  • 0 - DM_EXPECTED_QUALITY_LOW indicates that the average accuracy of models produced by this algorithm is low.

  • 1 - DM_EXPECTED_QUALITY_MEDIUM indicates that the average accuracy of models produced by this algorithm is medium.

  • 2 - DM_EXPECTED_QUALITY_HIGH indicates that the average accuracy of models produced by this algorithm is high.

SCALING

xsd:int

The scalability of the algorithm is as follows:

  • 0 - DM_SCALING_LOW indicates that the algorithm scales to small data sets.

  • 1 - DM_SCALING_MEDIUM indicates that the algorithm scales to large data sets.

  • 2 - DM_SCALING_HIGH indicates that the algorithm scales to very large data sets.

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:

  • DM_CONTROL_NONE (0) indicates that the algorithm cannot be canceled after it starts to train the model.

  • DM_CONTROL_CANCEL (1) indicates that the algorithm can be canceled after it starts to train the model, but that it MUST be restarted to resume training.

  • DM_CONTROL_SUSPENDRESUME (2) indicates that the algorithm can be canceled and resumed at any time, but that results are not available until training is complete.

  • DM_CONTROL_SUSPENDWITHRESULT (3) indicates that the algorithm can be canceled and resumed at any time, and that any incremental results can be obtained.

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>