PredictorModels Table
The actual models and the parameters used to build them are stored in this table by the Predictor resource when the models are built. The models are displayed in Commerce Server Manager when the Models node, under the Predictor resource, is selected. In/Out specifies whether the parameter is an input or output parameter. The Model Type specifies which model type uses that parameter. The last column, Data, is a Blob containing the binary representation for the actual model data.
Column Name | Data Type | In/ Out |
Model Type |
Description | Required? |
ModelName | DBTYPE_WSTR | In | Both | Model name. | Yes |
ModelCfgName | DBTYPE_WSTR | In | Both | Model configuration name (foreign key to the PredictorModelCfgs table). | Yes |
ModelType | DBTYPE_UI2 | In | Both | Algorithm used to build the model. Default is Prediction.
Valid values are:
|
No |
BuildTime | DBTYPE_UI4 | Out | Both | Time spent building model (milliseconds). | No |
ComplexityPenality | DBTYPE_UI4 | In | Prediction | Larger values prevent trees from growing too large (Prediction models only).
Valid range is 1 to MaxInt. Default = 100 |
No |
DataFitScore | DBTYPE_R8 | Out | Prediction | Measures the accuracy of the model when predicting missing data. The higher the score, the better the model.
Valid range is minus infinity to plus infinity. |
No |
DateCreated | DBTYPE_DB TIMESTAMP |
Out | Both | Date model was built.
Default is getdate() |
Yes |
InputAttributeFraction | DBTYPE_R8 | In | Both | Fraction of properties used for feature selection as input to predictions.
Valid range is 0 to 1.
|
No |
K | DBTYPE_UI4 | In | Segment | Number of segments to build.
The default is 10. Valid range is 1 to 32756. |
No |
MaxBufferSize | DBTYPE_UI4 | In | Segment | Maximum buffer size in Mbytes.
Default is 1 MB. |
No |
MeasuredAccuracy MaxPredictions |
DBTYPE_UI4 | In | Both | Maximum number of recommendations to be shown to user (used for determining Recommendation Score).
Valid range is 1 to MaxInt. Default is 10. |
No |
MeasuredAccuracy SampleFraction |
DBTYPE_R8 | In | Both | Fraction of sample data to hold out for automatic accuracy measurement.
Valid range is 0 to 1. Default is 40% (0.4) of all cases or 1000, whichever is less. |
No |
MinimumCasesToSplit | DBTYPE_UI4 | In | Prediction | Minimum number of cases at a node in a decision tree in order for a split to be possible at that node.
Default = 5 |
No |
OutputAttributeFraction | DBTYPE_R8 | In | Both | Fraction of properties used for feature selection as output of predictions.
Valid range is 0 to 1.
|
No |
RecommendScore | DBTYPE_R8 | Out | Prediction | Measures the quality of a ranked list of recommendations. The higher the score, the better the model.
Valid range is 0 to 1. |
No |
SampleSize | DBTYPE_UI4 | In | Both | Number of cases to randomly sample from the input data.
Default is -1 (use all data) or 20,000, whichever is less. |
No |
Data | DBTYPE_BYTES | Blob containing the model data. | No |
Copyright © 2005 Microsoft Corporation.
All rights reserved.