Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

CREATE MINING STRUCTURE (DMX)

Creates a new mining structure in a database. You can then use the ALTER MINING STRUCTURE (DMX) statement to add models to the mining structure.


CREATE [SESSION] MINING STRUCTURE <structure>
(
    [(<column definition list>)]
)
[(<parameter list>)]

structure

A unique name for the structure.

column definition list

A comma-separated list of column definitions.

parameter list

Optional. A comma-separated list of provider-defined parameters for the algorithm.

You define a mining structure column by including the following information for each column in the column definition list:

  • Name (mandatory)
  • Data type (mandatory)
  • Distribution
  • List of modeling flags
  • Content type (mandatory)
  • Relationship to an attribute column (mandatory only if it applies), indicated by the RELATED TO clause

Use the following syntax for the column definition list, to define a single column:

<column name>    <data type>    [<Distribution>]    [<Modeling Flags>]    <Content Type>    [<column relationship>]

Use the following syntax for the column definition list, to define a nested table column:

<column name>    TABLE    ( <non-table column definition list> )

Except for modeling flags, you can use no more than one clause from a particular group to define a column. You can define multiple modeling flags for a column.

For a list of the data types, content types, column distributions, and modeling flags that you can use to define a structure column, see the following topics:

You can add a clause to the statement to describe the relationship between two columns. Analysis Services supports using the following <Column relationship> clause.

RELATED TO

This form indicates a value hierarchy. The target of a RELATED TO column can be a key column in a nested table, a discretely-valued column in the case row, or another column with a RELATED TO clause, which indicates a deeper hierarchy.

The following example creates a mining structure called New Mailing, without creating any associated mining models. To learn how to add a mining model to the structure, see ALTER MINING STRUCTURE (DMX).

CREATE MINING STRUCTURE [New Mailing]
(
    CustomerKey LONG KEY, 
    Gender TEXT DISCRETE,
    [Number Cars Owned] LONG DISCRETE,
    [Bike Buyer] LONG DISCRETE 
) 

Community Additions

ADD
Show:
© 2015 Microsoft