Operation sequence mining based OLAP query recommendation method

Chen Ling,Chen Yuanzhong,Chen Gencai
DOI: https://doi.org/10.3969/j.issn.1001-0505.2011.03.013
2011-01-01
Abstract:An operation sequence mining based OLAP(online analytical processing) query recommendation method is proposed to counter the low efficiency problem caused by the complexity of OLAP query operations.First,query sequences in the form of numerical array are extracted from continuous MDX(multidimensional expression) query operations.Then,the PrefixSpan mining algorithm is exploited to obtain the frequent sequential patterns from query sequences,and a matrix of probabilities is established upon mined patterns and their sub-patterns.Finally,the next operation of current user is predicted by searching candidate patterns matched with the user's query operation or query sequence,and the prediction results are ranked according to the magnitude of probabilities.The performance of the proposed query recommendation method is evaluated with an OLAP query operation dataset recorded by seven professional OLAP users.The results show that with user-specific recommendation models,the average accuracy rates of the top five recommendations and the first recommendation are 92.20% and 77.06%,respectively.
What problem does this paper attempt to address?