Ask a question?why i always get the same result?

when I use sqlserver 2005 do the prediction with Microsoft_Association_Rules.

I found that I alwayes get the same result(same dataset) using the SQL statement such

as:

SELECT
Predict([movies],INCLUDE_STATISTICS,10)
From
[Movie Prediction]
NATURAL PREDICTION JOIN
(SELECT (SELECT '12 Angry Men' AS [Movie]) AS [Movies]) AS t

or

SELECT
Predict([movies],INCLUDE_STATISTICS,10)
From
[Movie Prediction]
NATURAL PREDICTION JOIN
(SELECT (SELECT 'Sport-100' AS [Movie]) AS [Movies]) AS t

the result don't very by the parameter of movie name.

wish expert give me some help.

thank you!

The most likely cause is that your model has not detected any rule having '12 Angry Men' or 'Sport-100' on the left hand side. In this case (no rule matches your input) the model will return a prediction based on the most popular items across the whole training set. To find more rules, you could tweak some algorithm parameters:

- By reducing the value of the minimum probability parameter, the algorithm will generate more rules

- By reducing the minimum support parameter, the algorithm will consider less popular itemsets to generate rules

The minimum support parameter may represent a percentage (if the value is between 0 and 1) or an absolute number (value is greater than 1)

thanks

bogdan

|||

thanks very much!