Query Recommendations for OLAP Discovery-Driven Analysis-Reference-Cited by-同舟云学术

Query Recommendations for OLAP Discovery-Driven Analysis

Published:2013 Issue: Volume: Page:66-90
ISSN:
Container-title:Developments in Data Extraction, Management, and Analysis
language:
Short-container-title:

Author:

Giacometti Arnaud¹,Marcel Patrick¹,Negre Elsa¹,Soulet Arnaud¹

Affiliation:

1. Université François Rabelais Tours, Laboratoire d’Informatique, France

Abstract

Recommending database queries is an emerging and promising field of research and is of particular interest in the domain of OLAP systems, where the user is left with the tedious process of navigating large datacubes. In this paper, the authors present a framework for a recommender system for OLAP users that leverages former users’ investigations to enhance discovery-driven analysis. This framework recommends the discoveries detected in former sessions that investigated the same unexpected data as the current session. This task is accomplished by (1) analysing the query log to discover pairs of cells at various levels of detail for which the measure values differ significantly, and (2) analysing a current query to detect if a particular pair of cells for which the measure values differ significantly can be related to what is discovered in the log. This framework is implemented in a system that uses the open source Mondrian server and recommends MDX queries. Preliminary experiments were conducted to assess the quality of the recommendations in terms of precision and recall, as well as the efficiency of their on-line computation.

Publisher

IGI Global

Reference27 articles.

1. Toward the next generation of recommender systems: a survey of the state-of-the-art and possible extensions

2. Bellatreche, L., Giacometti, A., Marcel, P., Mouloudi, H., & Laurent, D. (2005). A personalization framework for OLAP queries. In Proceedings of the 8th ACM International Workshop on Data Warehousing and OLAP (pp. 9–18). New York, NY: ACM.

3. Cariou, V., Cubillé, J., Derquenne, C., Goutier, S., Guisnel, F., & Klajnmic, H. (2007). Built-in indicators to automatically detect interesting cells in a cube. In Proceedings of the 9th International Conference on Data Warehousing and Knowledge Discovery (LNCS 4654, pp. 123–134).

4. Cariou, V., Cubillé, J., Derquenne, C., Goutier, S., Guisnel, F., & Klajnmic, H. (2008). Built-in indicators to discover interesting drill paths in a cube. In Proceedings of the 10th International Conference on Data Warehousing and Knowledge Discovery (LNCS 5182, pp. 33–44).