MINING_MODEL_CONTENT
This schema 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.
| Column name | Type indicator | Description |
| MODEL_CATALOG | DBTYPE_WSTR | The catalog name. Microsoft® SQL Server™ 2000 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 name(s) of the attribute(s) corresponding to this node. For a model node, this is a list of predictable attributes. For a leaf distribution node, this is an attribute to which the distribution corresponds. |
| 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. It can be one of the following values:
|
| NODE_GUID | DBTYPE_GUID | The node GUID. This column is not supported by Analysis Services; it always contains VT_NULL. |
| NODE_CAPTION | DBTYPE_WSTR | A label or a caption associated with the node. This property is used primarily for display purposes. If a caption does not exist, the contents of the NODE_NAME column is returned. |
| 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. VT_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 that this node pertains to. |
| 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. |
Default Sort Order
MODEL_CATALOG
MODEL_SCHEMA
MODEL_NAME
ATTRIBUTE_NAME
Restriction Columns
The MINING_MODEL_CONTENT schema rowset can have ten restrictions. The first nine are columns in the rowset described in the table.
MODEL_CATALOG
MODEL_SCHEMA
MODEL_NAME
ATTRIBUTE_NAME
NODE_NAME
NODE_UNIQUE_NAME
NODE_TYPE
NODE_GUID
NODE_CAPTION
The tenth restriction, TREE_OPERATION, is not on any particular column of the 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 |