2011年9月19日 上午 06:33
is there any possibility to show results of my own data mining algorithm in built-in Microsoft Association Rules Viewer?
I created very simple algorithm which does nothing and AlgorithmNavigator (parent of AlgorithmNavigationBase) builds the same tree as Microsoft Association Rules Algorithm for two frequent items.
When I want to look at rules, I get this error: No data exists for the row/column. This error may be related to GetStatistics() procedure which for MS AR returns some table, but for my algorithm it returns only empty table.
Could somebody help, please?
2011年9月19日 上午 08:48
Can you show us your statement?
Regards, Ryan Lambatan
Please "Mark as Answer" or "Vote as Helpful"
2011年9月19日 上午 09:00Could you tell me, what statement do you mean, please?
2011年9月19日 下午 10:57解答者
I don't think this will be supported by Microsoft. If you what to try to make it work
1. Attach Profiler to SQL Server when viewer is loading and review all the queries that the viewer sends. Make sure that they work for your algorithm and return similar data (column names, data types etc)
2. Try returning table with one row instead of empty table, see if it will make things better.
Can you describe the problem you are trying to solve? Why do you have to implement new algorithm? How is it different from AR?
Tatyana Yakushev [PredixionSoftware.com]
- 已提議為解答 Jerry NeeModerator 2011年9月21日 上午 09:11
2011年9月22日 上午 08:23
My algorithm gets cross-level hierarchical association rules from data, it's primarily optimized for IP addresses and domains. I cannot use built-in AR algorithm for that.
When I look into the profiler results I can see that for Microsoft Association Rules Viewer is called:
returns table with columns MAX_PAGE_SIZE, MIN_SUPPORT, MAX_SUPPORT, MIN_ITEMSET_SIZE, ... and values 2000, 2, 2, ...
Then is called
CALL System.Microsoft.AnalysisServices.System.DataMining.AssociationRules.GetRules('Ar', 0, 1999, 1, 1, 0.17, '', True)
For my algorithm there is called ...GetStatistics('hAR') only, which returns empty table. What I don't know is if I can somehow generate this table and its data. Maybe is there any chance to create this stored procedure and return the same data as Microsoft Algorithm returns? Is it real reason why GetRules() is not called?
2012年4月1日 下午 08:33
so what is the verdict, can my managed plugin algorithm used built-in Microsoft Association Rules Viewer?
- 已編輯 tisonet 2012年4月1日 下午 08:37
2012年4月2日 下午 07:16
I guess that I can used Microsoft Association Rules Viewer, but I have to have Mining.Content in the same format like ms assoc. rule algortihm.
I did custom managed plugin for mining sequential rules. And I would like to use Microsoft Association Rules Viewer for view results. I did navigator that returns content in the same format like ms assoc. rule algortihm, but procedure System.Microsoft.AnalysisServices.System.DataMining.AssociationRules.GetStatistics('MyModel') always return no data/rows.
So where can be problem? Mayby proc. GetStatistics has some constraints and my content did not pass that constraints.
Thanks for reply.