基于聚类的OLAP多维分析查询推荐方法研究

Research on recommendation of OLAP queries based on clustering

为提高用户在使用OLAP(联机分析处理)时的查询效率,改善用户体验,对OLAP中的MDX(多维表达式)查询语言进行了研究,提出了在MDX查询语言的基础上,对OLAP用户的历史查询记录进行聚类的方法,建立了查询操作的分级推荐机制,提供给当前用户候选查询作为推荐,帮助用户设计下一步查询操作。介绍了该方法的推荐机制构架,并表明了该方法的可行性。

In order to increase the efficiency of query during the use of OLAP and improve the experience of the user,based on the study of the MDX（mutil-dimensional expressions） query language of OLAP,it clusters the history of the OLAP users＇queries to establish the classified recommend of query,and provide candidate recommendations to the current user,as well as helps the user to design the forthcoming query.An approach for the recommend mechanism is presented,and the feasibility of it is proven.