MiningStructure Element (ASSL)

Article
10/31/2023

Defines the structure for a set of mining models.

Syntax

  
<MiningStructures>  
   <MiningStructure>  
      <Name>...</Name>  
      <ID>...</ID>  
      <Description>...</<Description>  
      <Source>...</Source>  
      <CreatedTimestamp>...</<CreatedTimestamp>  
      <LastSchemaUpdate>...</LastSchemaUpdate>  
      <LastProcessed>...</LastProcessed>  
      <Translations>...</Translations>  
      <Language>...</Language>  
            <Collation>...</Collation>  
      <ErrorConfiguration>...</ErrorConfiguration>  
      <CacheMode>...</CacheMode>  
            <Columns>...</Columns>  
      <State>...</State>  
      <HoldoutActualSize>...</HoldoutActualSize>  
      <HoldoutMaxCases>...</HoldoutMaxCases>  
      <HoldoutMaxPercent>...</HoldoutMaxPercent>  
      <HoldoutSeed>...</HoldoutSeed>        
            <MiningStructurePermissions>...</<MiningStructurePermissions>  
            <MiningModels>...</MiningModels>  
            <Annotations>...</Annotations>  
   </MiningStructure>  
</MiningStructures>

Element Characteristics

Characteristic	Description
Data type and length	None
Default value	None
Cardinality	0-n: Optional element that can occur more than once.

Element Relationships

Relationship	Element
Parent elements	MiningStructures
Child elements	Annotations, CacheMode, Collation, Columns, CreatedTimestamp, Description, ErrorConfiguration, HoldoutActualSize, HoldoutMaxCases, HoldoutMaxPercent, HoldoutSeed, ID, Language, LastProcessed, LastSchemaUpdate, MiningModels, MiningStructurePermissions, Name, Source, State, Translations

Remarks

The mining structure defines the columns and the bindings. After defining a mining structure, you can use that structure to define many mining models. The mining structure, and each mining model it contains, can be processed independently.

Note

The holdout properties, HoldoutMaxCases, HoldoutMaxPercent, HoldoutSeed, and HoldoutActualSize enable you to define a partition on a mining structure that acts as the test set for all the mining models that are associated with the structure. SQL Server 2005 does not support these properties. Therefore, if you try to use these properties on an instance of SQL Server 2005,Analysis Services will return an error.

Drillthrough to Structure Columns

In SQL Server 2008, a new permission element has been added to the MiningStructurePermissions Element (ASSL) collection. If you add AllowDrillthrough permission to both the MiningStructurePermissions and MiningModelPermission collections, drillthrough is enabled from the mining model to the structure, in such a way that members of a role that has AllowDrillthrough permissions on the model can query the data mining model, and return structure columns that were not included in the model.

Therefore, to protect sensitive data or personal information, you should construct your data source view to mask sensitive information, and grant AllowDrillthrough permission on a mining structure only when necessary. For more information, see AllowDrillThrough Element (ASSL).

The corresponding element in the Analysis Management Objects (AMO) object model is MiningStructure.

Share via