3.1.4.2.2.1.3.22.1 Columns
The DMSCHEMA_MINING_MODEL_CONTENT 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.<263> |
MODEL_NAME |
xsd:string |
Yes |
The name of the model with which the content described by this row is associated. |
ATTRIBUTE_NAME |
xsd:string |
Yes |
The name of the attribute that corresponds to this node. |
NODE_NAME |
xsd:string |
Yes |
The name of the node. This column contains the same value as NODE_UNIQUE_NAME. |
NODE_UNIQUE_NAME |
xsd:string |
Yes |
The unique name of the node. |
NODE_TYPE |
xsd:int |
Yes |
The type of the node. Will generate one of the following values (third-party data mining algorithms can extend this list):
|
NODE_GUID |
uuid |
Yes |
The node GUID.<268> |
NODE_CAPTION |
xsd:string |
Yes |
A label or a caption associated with the node. This property is primarily for display purposes. |
CHILDREN_CARDINALITY |
xsd:unsignedInt |
|
An estimate of the number of children that the node has. |
PARENT_UNIQUE_NAME |
xsd:string |
|
The unique name of the node's parent. NULL is returned for any nodes at the root level. |
NODE_DESCRIPTION |
xsd:string |
|
The human-readable description of the node. |
NODE_RULE |
xsd:string |
|
An XML description of the rule that is embedded in the node. |
MARGINAL_RULE |
xsd:string |
|
An XML description of the rule that is moving to the node from the parent node. |
NODE_PROBABILITY |
xsd:double |
|
The probability associated with this node. |
MARGINAL_PROBABILITY |
xsd:double |
|
The probability of reaching the node from the parent node. |
NODE_DISTRIBUTION |
nested rowset |
|
A table that contains the probability histogram of the node. |
ATTRIBUTE_NAME |
xsd:string |
|
The name part of key-value pair. |
ATTRIBUTE_VALUE |
xsd:anyType |
|
The value part of key-value pair. |
SUPPORT |
xsd:double |
|
The count of the cases that have this attribute-value pair, or that contain this itemset or rule. |
PROBABILITY |
xsd:double |
|
Indicates the probability for this specific node within the entire model. |
VARIANCE |
xsd:double |
|
Indicates the variance of the values within the node. By definition, variance is always zero for discrete values. If the model supports continuous values, variance is computed as σ (sigma), using the denominator n, representing the number of cases in the node. |
VALUETYPE |
xsd:int |
|
Indicates the data type of the value or an attribute, and the usage of the value. Certain value types apply only to certain model types:
|
NODE_SUPPORT |
xsd:double |
|
The number of cases that support this node. |
MSOLAP_MODEL_COLUMN |
xsd:string |
|
The name of the column from the model definition to which this node pertains. |
MSOLAP_NODE_SCORE |
xsd:double |
|
The score that was computed for this node. |
MSOLAP_NODE_SHORT_CAPTION |
xsd:string |
|
A short caption for the node that can be used for display purposes to improve readability. |
The rowset is sorted on MODEL_CATALOG and MODEL_SCHEMA.
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" /> <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="ATTRIBUTE_NAME" name="ATTRIBUTE_NAME" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="NODE_NAME" name="NODE_NAME" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="NODE_UNIQUE_NAME" name="NODE_UNIQUE_NAME" type="xsd:string" /> <xsd:element sql:field="NODE_TYPE" name="NODE_TYPE" type="xsd:int" /> <xsd:element sql:field="NODE_GUID" name="NODE_GUID" type="uuid" minOccurs="0" /> <xsd:element sql:field="NODE_CAPTION" name="NODE_CAPTION" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="CHILDREN_CARDINALITY" name="CHILDREN_CARDINALITY" type="xsd:unsignedInt" /> <xsd:element sql:field="PARENT_UNIQUE_NAME" name="PARENT_UNIQUE_NAME" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="NODE_DESCRIPTION" name="NODE_DESCRIPTION" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="NODE_RULE" name="NODE_RULE" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="MARGINAL_RULE" name="MARGINAL_RULE" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="NODE_PROBABILITY" name="NODE_PROBABILITY" type="xsd:double" minOccurs="0" /> <xsd:element sql:field="MARGINAL_PROBABILITY" name="MARGINAL_PROBABILITY" type="xsd:double" minOccurs="0" /> <xsd:element sql:field="NODE_DISTRIBUTION" name="NODE_DISTRIBUTION" minOccurs="0" maxOccurs="unbounded"> <xsd:complexType> <xsd:sequence> <xsd:element sql:field="ATTRIBUTE_NAME" name="ATTRIBUTE_NAME" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="ATTRIBUTE_VALUE" name="ATTRIBUTE_VALUE" minOccurs="0" /> <xsd:element sql:field="SUPPORT" name="SUPPORT" type="xsd:double" minOccurs="0" /> <xsd:element sql:field="PROBABILITY" name="PROBABILITY" type="xsd:double" minOccurs="0" /> <xsd:element sql:field="VARIANCE" name="VARIANCE" type="xsd:double" minOccurs="0" /> <xsd:element sql:field="VALUETYPE" name="VALUETYPE" type="xsd:int" minOccurs="0" /> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:element sql:field="NODE_SUPPORT" name="NODE_SUPPORT" type="xsd:double" minOccurs="0" /> <xsd:element sql:field="MSOLAP_MODEL_COLUMN" name="MSOLAP_MODEL_COLUMN" type="xsd:string" minOccurs="0" /> <xsd:element sql:field="MSOLAP_NODE_SCORE" name="MSOLAP_NODE_SCORE" type="xsd:double" minOccurs="0" /> <xsd:element sql:field="MSOLAP_NODE_SHORT_CAPTION" name="MSOLAP_NODE_SHORT_CAPTION" type="xsd:string" minOccurs="0" /> </xsd:sequence> </xsd:complexType>