Mining Model Properties
Applies To: SQL Server 2016
Mining models have the following kinds of properties:
Properties that are inherited from the mining structure that define the data type and content type of the data used by the model;
Properties that are related to the algorithm used to create the mining model, including any customer parameters;
Properties that define a filter on the model used to train the model.
The properties of a mining model are initially defined when you create the model; however, you can alter most properties later, including the algorithm parameters, filters, and column usage properties. You change properties by using the Mining Models tab of Data Mining Designer, or by using AMO or XMLA.
Whenever you change any property of a model, you must reprocess the model for the changes to be reflected in the model. Reprocessing is required even if the change only involves metadata, such as adding a column alias or description.
The following table describes the properties that are specific to mining models. Additionally, there are properties that you can set on individual columns in the mining
|Algorithm||Sets the algorithm type for the mining model.|
|AlgorithmParameters||Sets values for algorithm parameters that are available for each algorithm type.|
|Filter||Sets a filter that is applied to the data that is used for training and testing the mining model. The filter definition is stored with the model and can be used optionally when you create prediction queries, or when you test the accuracy of the model.|
The model filter is not optional when training the model.
|Name||Sets the name of the mining model.|
|AllowDrillThrough||Specifies whether drill through is enabled on the mining model.|
You can set the following data mining-specific properties for each column in a mining model. You can set these properties to a different value for each mining model in a mining structure.
|Description||Describes the purpose of the mining column.|
|Name||Sets the name of the mining model column. You can type a new name, to provide an alias for the mining model column.|
|ModelingFlags||Sets any algorithm-specific flags for the column.|
|SourceColumnID||Indicates the name of the mining structure column on which the model column is based.|
This property is read-only.
|Usage||Sets how the column will be used by the mining model.|
Mining Model Columns
Mining Structures (Analysis Services - Data Mining)
Mining Model Tasks and How-tos
Change the Properties of a Mining Model
Data Mining Tools
Create a Relational Mining Structure
Create an Alias for a Model Column