MiningStructure Element (ASSL)
Applies To: SQL Server 2016 Preview
Defines the structure for a set of mining models.
<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>
|Data type and length||None|
|Cardinality||0-n: Optional element that can occur more than once.|
|Child elements||Annotations, CacheMode, Collation, Columns, CreatedTimestamp, Description, ErrorConfiguration,|
ID, Language, LastProcessed, LastSchemaUpdate, MiningModels, MiningStructurePermissions, Name, Source, State, Translations
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.
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.