Recommending Next Query in an OLAP Session

Invariably, users formulate a sequence of OLAP queries, referred to as a session, in order to arrive at the intended analysis of the data in a data warehouse. Formulating this sequence is considered a formidable task. OLAP query recommendation addresses the formulation of the next query in an ongoing session. In this paper, to recommend the next query to the user, we apply the collaborative filtering strategy which takes into account the former queries issued by all the users. Our framework relies on similarity between query sessions and recommends a query from the closest session based on its proximity to the last query in the current session. A set of experiments show the effectiveness of our approach.