DMSCHEMA_MINING_MODEL_CONTENT Rowset

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 2005 Analysis Services (SSAS) 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

Reference

Data Mining Schema Rowsets

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release	History
14 April 2006	Changed content: Updated technical information in many of the column descriptions.