This topic has not yet been rated - Rate this topic

SELECT FROM <model>.CONTENT (DMX)

SQL Server 2005

SQL Server 2012

Returns the mining model schema rowset for the specified data mining model.


SELECT [FLATTENED] [TOP <n>] <expression list> FROM <model>.CONTENT 
[WHERE <condition expression>]
[ORDER BY <expression> [DESC|ASC]]

Arguments

n: Optional. An integer specifying how many rows to return.

expression list: A comma-separated list of columns derived from the Content schema rowset.

model: A model identifier.

condition expression: Optional. A condition to restrict the values that are returned from the column list.

expression: Optional. An expression that returns a scalar value.

Remarks

The SELECT FROM <model>.CONTENT statement returns content that is specific to each algorithm. For example, you may want to use the descriptions of all the rules of an association rules model in a custom application. You can use a SELECT FROM <model>.CONTENT statement to return values in the NODE_RULE column of the model.

The following table provides a general description of the columns that are included in the mining model content.

Note:
Algorithms may interpret the columns differently in order to properly represent the content.

CONTENT rowset column	Description
MODEL_CATALOG	A catalog name. NULL if the provider does not support catalogs.
MODEL_SCHEMA	An unqualified schema name. NULL if the provider does not support schemas.
MODEL_NAME	A model name. This column cannot contain a NULL.
ATTRIBUTE_NAME	The names of the attributes that correspond to this node.
NODE_NAME	The name of the node.
NODE_UNIQUE_NAME	A unique name of the node.
NODE_TYPE	The type of the node, which is algorithm-specific.
NODE_GUID	The node GUID. NULL if no GUID.
NODE_CAPTION	A label or a caption that is associated with the node. Used primarily for display purposes. If a caption does not exist, NODE_NAME is returned.
CHILDREN_CARDINALITY	The number of children that the node has.
PARENT_UNIQUE_NAME	A unique name of the node's parent. NULL is returned for any nodes at the root level.
NODE_DESCRIPTION	A readable description of the node.
NODE_RULE	An XML description of the rule embedded in the node. The format of the XML string is based on the PMML standard.
MARGINAL_RULE	An XML description of the rule moving to the node from the parent node.
NODE_PROBABILITY	The probability for reaching the node.
MARGINAL_PROBABILITY	The probability of reaching the node from the parent node.
NODE_DISTRIBUTION	A table containing the probability histogram of the node.
NODE_SUPPORT	The number of cases in support of this node.

For More Information: Data Mining Schema Rowsets

Examples

The following code returns all the columns that define the Target Mail mining model for nodes that are descended from the node identified by '00000000100'.

SELECT * FROM [TM Decision Tree].CONTENT
WHERE ISDESCENDANT('00000000100')

Reference

SELECT (DMX)
Data Mining Extensions (DMX) Data Manipulation Statements
Data Mining Extensions (DMX) Statement Reference

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD