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:
|
|
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>