3.1.4.2.2.1.3.22.1 Columns

  • Article

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

  • DM_NODE_TYPE_MODEL (1) – The root node of a decision tree model.

  • DM_NODE_TYPE_CLASSIFICATION_TREE_ROOT (2) - The node corresponds to the root of the tree for an output attribute in a classification model.

  • DM_NODE_TYPE_TREE_INTERIOR (3) - The node corresponds to an interior node (non-leaf/non-root) in the tree for an output attribute in a classification/regression model (including Decision Trees and Time Series models).

  • DM_NODE_TYPE_TREE_DISTRIBUTION (4) - The node corresponds to a leaf node in the tree for an output attribute in a classification model that includes the distribution of the output attribute at that branch of the tree.

  • DM_NODE_TYPE_CLUSTER (5) - The node corresponds to a cluster discovered by a clustering model.

  • DM_NODE_TYPE_UNKNOWN (6) – Not supported.

  • DM_NODE_TYPE_ITEMSET (7) – The node represents a frequent itemset in an association rules model.

  • DM_NODE_TYPE_ASSOCIATION_RULE (8) – The node represents a rule discovered by an association rules model.

  • DM_NODE_TYPE_NB_PREDICTABLE_ATTRIBUTE (9) – The node represents an output attribute in a Naïve Bayes model.

  • DM_NODE_TYPE_NB_INPUT_ATTRIBUTE (10) – The node represents an input attribute in a Naïve Bayes model.

  • DM_NODE_TYPE_NB_INPUT_ATTRIBUTE_STATE (11) – The node represents a specific state of an input attribute in a Naïve Bayes model.

  • DM_NODE_TYPE_SEQUENCE (13) – The node represents a sequence in a Sequence Clustering model.

  • DM_NODE_TYPE_TRANSITION (14) – The node represents a state transition in a Sequence Clustering model.

  • DM_NODE_TYPE_TIME_SERIES (15) – The node represents the summary for a time series model.

  • DM_NODE_TYPE_TS_TREE (16) – The node represents the root of the regression tree for a Time Series model.

  • DM_NODE_TYPE_NN_SUBNETWORK (17) - The node represents Neural network, subnetwork.

  • DM_NODE_TYPE_NN_INPUT_LAYER (18) – The node represents Neural network, input layer (parent of input nodes).

  • DM_NODE_TYPE_NN_HIDDEN_LAYER (19) The node represents Neural network, hidden layer (parent of hidden nodes).

  • DM_NODE_TYPE_NN_OUTPUT_LAYER (20) – The node represents Neural network, output layer (parent of output nodes).

  • DM_NODE_TYPE_NN_INPUT_NODE (21) – The node represents Neural network, input node.

  • DM_NODE_TYPE_NN_HIDDEN_NODE (22) – The node represents Neural network, hidden node.

  • DM_NODE_TYPE_NN_OUTPUT_NODE (23) – The node represents Neural network, output node.

  • DM_NODE_TYPE_NN_MARGINAL_STAT_NODE (24) – The node represents Neural network, marginal stat node.

  • DM_NODE_TYPE_REGRESSION_TREE_ROOT (25) – The node corresponds to the root of the tree for a continuous output attribute in a Decision Tree (regression tree) model.

  • DM_NODE_TYPE_NB_MARGINAL_STAT_NODE (26) – The node represents Neural network, marginal stat node.

  • DM_NODE_TYPE_ARIMA_ROOT (27) – The root node of an Autoregressive Integrated Moving Average (ARIMA) model.<264>

  • DM_NODE_TYPE_ARIMA_PERIODICSTRUCTURE (28) – A single ARIMA periodic structure node.<265>

  • DM_NODE_TYPE_ARIMA_AUTOREGRESSIVE (29) – An autoregressive node of an ARIMA model.<266>

  • DM_NODE_TYPE_ARIMA_MOVINGAVERAGE (30) – A moving average node of an ARIMA model.<267>

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:

  • 0 - Auto Detect

  • 1 - Missing

  • 2 - Existing

  • 3 - Continuous

  • 4 - Discrete

  • 5 - Discretized

  • 6 - Boolean

  • 7 - Coefficient

  • 8 - Score gain

  • 9 - Statistics

  • 10 - Node unique name

  • 11 - Intercept

  • 12 - Periodicity

  • 13 - Autoregressive order

  • 14 - Moving average order

  • 15 - Difference order

  • 16 - Other

  • -1 - Prerendered string

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>