DMSCHEMA_MINING_MODEL_CONTENT Rowset

APPLIES TO:yesSQL Server Analysis ServicesnoAzure Analysis Services

Allows the client application to browse the content of a data mining model. Client applications can use the special tree operation restrictions described at the end of this topic to navigate the content of the mining model.

Rowset Columns

The DMSCHEMA_MINING_MODEL_CONTENT rowset contains the following columns.

Column name Type indicator Length Description
MODEL_CATALOG DBTYPE_WSTR The catalog name. Microsoft SQL Server Analysis Services populates this column with the name of the database of which the model is a member.
MODEL_SCHEMA DBTYPE_WSTR The unqualified schema name. This column is not supported by Analysis Services; it always contains VT_NULL.
MODEL_NAME DBTYPE_WSTR The name of the model with which the content described by this row is associated.
ATTRIBUTE_NAME DBTYPE_WSTR The names of the attributes that correspond to this node.
NODE_NAME DBTYPE_WSTR The name of the node. Currently, this column contains the same value as NODE_UNIQUE_NAME, though this may change in future releases.
NODE_UNIQUE_NAME DBTYPE_WSTR The unique name of the node.
NODE_TYPE DBTYPE_I4 The type of the node. Will generate one of the following values (3rd party data mining algorithms can extend this list):

DM_NODE_TYPE_CLASSIFICATION_TREE_ROOT (2)

DM_NODE_TYPE_TREE_INTERIOR (3)

DM_NODE_TYPE_TREE_DISTRIBUTION (4)

DM_NODE_TYPE_CLUSTER (5)

DM_NODE_TYPE_UNKNOWN (6)

DM_NODE_TYPE_ITEMSET (7)

DM_NODE_TYPE_ASSOCIATION_RULE (8)

DM_NODE_TYPE_NB_PREDICTABLE_ATTRIBUTE (9)

DM_NODE_TYPE_NB_INPUT_ATTRIBUTE (10)

DM_NODE_TYPE_NB_INPUT_ATTRIBUTE_STATE (11)

DM_NODE_TYPE_SEQUENCE (13)

DM_NODE_TYPE_TRANSITION (14)

DM_NODE_TYPE_TIME_SERIES (15)

DM_NODE_TYPE_TS_TREE (16)

DM_NODE_TYPE_NN_SUBNETWORK (17) Neural network, subnetwork

DM_NODE_TYPE_NN_INPUT_LAYER (18) Neural network, input layer (parent of input nodes)

DM_NODE_TYPE_NN_HIDDEN_LAYER (19) Neural network, hidden layer (parent of hidden nodes)

DM_NODE_TYPE_NN_OUTPUT_LAYER (20) Neural network, output layer (parent of output nodes)

DM_NODE_TYPE_NN_INPUT_NODE (21) Neural network, input node

DM_NODE_TYPE_NN_HIDDEN_NODE (22) Neural network, hidden node

DM_NODE_TYPE_NN_OUTPUT_NODE (23) Neural network, output node

DM_NODE_TYPE_NN_MARGINAL_STAT_NODE (24) Neural network, marginal stat node

DM_NODE_TYPE_REGRESSION_TREE_ROOT (25)

DM_NODE_TYPE_NB_MARGINAL_STAT_NODE (26) Neural network, marginal stat node
NODE_GUID DBTYPE_GUID The node GUID. This column is not supported by Analysis Services; it always contains NULL.
NODE_CAPTION DBTYPE_WSTR A label or a caption associated with the node. This property is primarily for display purposes.
CHILDREN_CARDINALITY DBTYPE_UI4 An estimate of the number of children that the node has.
PARENT_UNIQUE_NAME DBTYPE_WSTR The unique name of the node's parent. NULL is returned for any nodes at the root level.
NODE_DESCRIPTION DBTYPE_WSTR A user-friendly description of the node.
NODE_RULE DBTYPE_WSTR An XML description of the rule that is embedded in the node.
MARGINAL_RULE DBTYPE_WSTR An XML description of the rule that is moving to the node from the parent node.
NODE_PROBABILITY DBTYPE_R8 The probability associated with this node.
MARGINAL_PROBABILITY DBTYPE_R8 The probability of reaching the node from the parent node.
NODE_DISTRIBUTION DBTYPE_HCHAPTER A table that contains the probability histogram of the node.
NODE_SUPPORT DBTYPE_R8 The number of cases that support this node.
MSOLAP_MODEL_COLUMN DBTYPE_WSTR The name of the column from the model definition to which this node pertains.
MSOLAP_NODE_SCORE DBTYPE_R8 The score that was computed for this node.
MSOLAP_NODE_SHORT_CAPTION DBTYPE_WSTR A short caption for the node that can be used for display purposes to improve readability.

Restriction Columns

The DMSCHEMA_MINING_MODEL_CONTENT rowset can be restricted on the columns listed in the following table.

Column name Type indicator Restriction State
MODEL_CATALOG DBTYPE_WSTR Optional.
MODEL_SCHEMA DBTYPE_WSTR Optional.
MODEL_NAME DBTYPE_WSTR Optional.
ATTRIBUTE_NAME DBTYPE_WSTR Optional.
NODE_NAME DBTYPE_WSTR Optional.
NODE_UNIQUE_NAME DBTYPE_WSTR Optional.
NODE_TYPE DBTYPE_I4 Optional.
NODE_GUID DBTYPE_WSTR Optional.
NODE_CAPTION DBTYPE_WSTR Optional.
TREE_OPERATION DBTYPE_UI4 Optional. See below for additional remarks.

The restriction, TREE_OPERATION, is not on any particular column of the DMSCHEMA_MINING_MODEL_CONTENT rowset; rather, it specifies a tree operator. The consumer can specify a NODE_UNIQUE_NAME restriction and the tree operator (ANCESTORS, CHILDREN, SIBLINGS, PARENT, DESCENDANTS, SELF) to obtain the requested set of members. The SELF operator includes the row for the node itself in the list of returned rows. The following table describes the constants that make up the bitmap definition for the TREE_OPERATION restriction. They can be combined using the logical OR operator.

Constant Value
DMTREEOP_ANCESTORS 0x00000020
DMTREEOP_CHILDREN 0x00000001
DMTREEOP_SIBLINGS 0x00000002
DMTREEOP_PARENT 0x00000004
DMTREEOP_SELF 0x00000008
DMTREEOP_DESCENDANTS 0x00000010

See Also

Data Mining Schema Rowsets