Content Element (ASSL)

 

Applies To: SQL Server 2016 Preview

Describes the content of the column in the MiningStructure element.

  
<ScalarMiningStructureColumn>  
   ...  
   <Content>...</Content>  
   ...  
</ScalarMiningStructureColumn>  

CharacteristicDescription
Data type and lengthString (enumeration)
Default valueNone
Cardinality1-1: Required element that can occur once and only once.
RelationshipElement
Parent elementScalarMiningStructureColumn
Child elementsNone

This enumeration describes the type of content represented by a mining structure column, and can be extended as needed by mining algorithm providers. For more information about content types, see Content Types (Data Mining).

The values listed in the following table are typically supported by all mining algorithm providers.

ValueDescription
DiscreteThe column contains discrete values.
ContinuousThe values for the column define a continuous set of numeric data.
DiscretizedThe values in the column represent groups (or buckets) of values derived from a continuous column.
OrderedThe values for the column define an ordered set.
CyclicalThe values for the column define a cyclical ordered set.
ProbabilityThe values for the column specify a probability for the columns contained in the ClassifiedColumns element of the parent ScalarMiningStructureColumn.
VarianceThe values for the column specify a variance for the columns contained in the ClassifiedColumns element of the parent ScalarMiningStructureColumn.
StdDevThe values for the column specify a standard deviation for the columns contained in the ClassifiedColumns element of the parent ScalarMiningStructureColumn.
ProbabilityVarianceThe values for the column specify a probability variance for the columns contained in the ClassifiedColumns element of the parent ScalarMiningStructureColumn.
ProbabilityStdDevThe values for the column specify a probability standard deviation for the columns contained in the ClassifiedColumns element of the parent ScalarMiningStructureColumn.
SupportThe values for the column specify support information for the column contained in the ClassifiedColumns element of the parent ScalarMiningStructureColumn.

Note: This column is provided as part of the standard for third party mining algorithm providers. Microsoft provided algorithms do not make use of this column.
KeyThe column is a key column.

Note: This content type is applicable only to key columns, in which the IsKey element is set to True.

In addition to these standard values, mining algorithm providers included with Microsoft SQL Server Analysis Services support the values in the following table.

ValueDescription
Key SequenceThe column is a key column, and the values for the column represent a sequence of events.

Note: This content type is applicable only to key columns, in which the IsKey element is set to True.
Key TimeThe column is a key column, and the values for the column represent time measurement units.

Note: This content type is applicable only to key columns, in which the IsKey element is set to True.
SequenceThe values for the column represent a sequence of events.
TimeThe values for the column represent time measurement units.

The enumeration corresponding to the allowed values for Content in the Analysis Management Objects (AMO) object model is ScalarMiningStructureColumn.

ClassifiedColumns Element (ASSL)
Properties (ASSL)

Community Additions

ADD
Show: