3.1.4.2.2.1.3.25.1 Columns

The DMSCHEMA_MINING_MODELS rowset contains the following columns.

Name

Type

Restriction

Description

MODEL_CATALOG

xsd:string

Yes

The catalog name.

MODEL_SCHEMA

xsd:string

Yes

The unqualified schema name.<278>

MODEL_NAME

xsd:string

Yes

The mining model name.

MODEL_TYPE

xsd:string

Yes

The model type.<279>

MODEL_GUID

uuid

The GUID of the model.

DESCRIPTION

xsd:string

The human-readable description of the model.

MODEL_PROPID

xsd:unsignedInt

The property ID of the model.

DATE_CREATED

xsd:dateTime

The date on which the model was created.

DATE_MODIFIED

xsd:dateTime

The date on which the model definition was last modified.

SERVICE_TYPE_ID

xsd:unsignedInt

Yes

An enumeration that identifies the type of data mining algorithm that is used by the model. This type can be one of the following values:

  • DM_SERVICETYPE_CLASSIFICATION (0x1)

  • DM_SERVICETYPE_ CLUSTERING (0x2)

  • DM_SERVICETYPE_ ASSOCIATION (0x4)

  • DM_SERVICETYPE_ DENSITY_ESTIMATE (0x8)

  • DM_SERVICETYPE_SEQUENCE (0x10)

SERVICE_NAME

xsd:string

Yes

The server-specific name for the data mining algorithm that is used by the model.

CREATION_STATEMENT

xsd:string

The statement that was used to create the mining model.

PREDICTION_ENTITY

xsd:string

A comma-delimited list that indicates which mining columns can be predicted.

IS_POPULATED

xsd:boolean

 Indicates whether the model is populated.

The value is true if the model is populated; otherwise, false.

MINING_PARAMETERS

xsd:string

A comma-delimited list of the parameters that were used when the model was created.

MINING_STRUCTURE

xsd:string

Yes

The ID of the mining structure on which the model is based.

LAST_PROCESSED

xsd:dateTime

The date when the model was last processed.

MSOLAP_IS_DRILLTHROUGH_ENABLED

xsd:boolean

When true, indicates that the model supports drillthrough; otherwise false.

FILTER

xsd:string

The filter expression that is associated with the mining model.

NULL or empty string indicates that no filter is applied.

TRAINING_SET_SIZE

xsd:unsignedLong

The number of cases that are contained in the mining model training set after the structure has been processed and any filters have been applied to the model.

First, the rowset is sorted by mining structure name, which is not a column in the rowset. Then, the rowset is sorted on MODEL_CATALOG, MODEL_SCHEMA, and MODEL_NAME.

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="MODEL_CATALOG" name="MODEL_CATALOG" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="MODEL_SCHEMA" name="MODEL_SCHEMA" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="MODEL_NAME" name="MODEL_NAME" type="xsd:string" />
           <xsd:element sql:field="MODEL_TYPE" name="MODEL_TYPE" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="MODEL_GUID" name="MODEL_GUID" type="uuid" minOccurs="0" />
           <xsd:element sql:field="DESCRIPTION" name="DESCRIPTION" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="MODEL_PROPID" name="MODEL_PROPID" 
                            type="xsd:unsignedInt" minOccurs="0" />
           <xsd:element sql:field="DATE_CREATED" name="DATE_CREATED" 
                            type="xsd:dateTime" minOccurs="0" />
           <xsd:element sql:field="DATE_MODIFIED" name="DATE_MODIFIED" 
                            type="xsd:dateTime" minOccurs="0" />
           <xsd:element sql:field="SERVICE_TYPE_ID" name="SERVICE_TYPE_ID" 
                            type="xsd:unsignedInt" />
           <xsd:element sql:field="SERVICE_NAME" name="SERVICE_NAME" type="xsd:string" />
           <xsd:element sql:field="CREATION_STATEMENT" name="CREATION_STATEMENT" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="PREDICTION_ENTITY" name="PREDICTION_ENTITY" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="IS_POPULATED" name="IS_POPULATED" type="xsd:boolean" />
           <xsd:element sql:field="MINING_PARAMETERS" name="MINING_PARAMETERS" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="MINING_STRUCTURE" name="MINING_STRUCTURE" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="LAST_PROCESSED" name="LAST_PROCESSED" 
                            type="xsd:dateTime" minOccurs="0" />
           <xsd:element sql:field="MSOLAP_IS_DRILLTHROUGH_ENABLED" 
                            name="MSOLAP_IS_DRILLTHROUGH_ENABLED" 
                            type="xsd:boolean" />
           <xsd:element sql:field="FILTER" name="FILTER" type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="TRAINING_SET_SIZE" name="TRAINING_SET_SIZE" 
                            type="xsd:unsignedLong" minOccurs="0" />
         </xsd:sequence>
       </xsd:complexType>