Skip to content

Latest commit

 

History

History
97 lines (82 loc) · 6.71 KB

File metadata and controls

97 lines (82 loc) · 6.71 KB
title MiningStructure Element (ASSL) | Microsoft Docs
ms.custom
ms.date 03/06/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
analysis-services
docset-sql-devref
ms.tgt_pltfrm
ms.topic reference
apiname
MiningStructure Element
apilocation
apitype Schema
applies_to
SQL Server 2016 Preview
f1_keywords
MiningStructure
helpviewer_keywords
MiningStructure element
ms.assetid b943cd92-0ed8-4bd8-8fbc-7dab0534aede
caps.latest.revision 48
author Minewiskan
ms.author owend
manager erikre

MiningStructure Element (ASSL)

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, were introduced in [!INCLUDEssKatmai]. They 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. [!INCLUDEssVersion2005] does not support these properties. Therefore, if you try to use these properties on an instance of [!INCLUDEssVersion2005], [!INCLUDEssASnoversion] will return an error.

Drillthrough to Structure Columns

In [!INCLUDEssKatmai], 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 xref:Microsoft.AnalysisServices.MiningStructure.

See Also

MiningModel Element (ASSL)
Objects (ASSL)
SELECT (DMX)