• xmlui.mirage2.page-structure.header.title
    • français
    • English
  • Help
  • Login
  • Language 
    • Français
    • English
View Item 
  •   BIRD Home
  • LAMSADE (UMR CNRS 7243)
  • LAMSADE : Publications
  • View Item
  •   BIRD Home
  • LAMSADE (UMR CNRS 7243)
  • LAMSADE : Publications
  • View Item
JavaScript is disabled for your browser. Some features of this site may not work without it.

Browse

BIRDResearch centres & CollectionsBy Issue DateAuthorsTitlesTypeThis CollectionBy Issue DateAuthorsTitlesType

My Account

LoginRegister

Statistics

Most Popular ItemsStatistics by CountryMost Popular Authors
Thumbnail

Query Recommendations for OLAP Discovery-Driven Analysis

Giacometti, Arnaud; Marcel, Patrick; Negre, Elsa; Soulet, Arnaud (2011), Query Recommendations for OLAP Discovery-Driven Analysis, International Journal of Data Warehousing and Mining, 7, 2, p. 1-25. http://dx.doi.org/10.4018/jdwm.2011040101

View/Open
IJDWM10.pdf (1020.Kb)
Type
Article accepté pour publication ou publié
Date
2011
Journal name
International Journal of Data Warehousing and Mining
Volume
7
Number
2
Publisher
IGI Global
Pages
1-25
Publication identifier
http://dx.doi.org/10.4018/jdwm.2011040101
Metadata
Show full item record
Author(s)
Giacometti, Arnaud
Marcel, Patrick cc
Negre, Elsa
Soulet, Arnaud cc
Abstract (EN)
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.
Subjects / Keywords
MDX queries; collaborative filtering; query recommendation; discovery-driven analysis; OLAP

Related items

Showing items related by title and author.

  • Thumbnail
    Query Recommendations for OLAP Discovery-Driven Analysis 
    Giacometti, Arnaud; Marcel, Patrick; Negre, Elsa; Soulet, Arnaud (2009) Communication / Conférence
  • Thumbnail
    A framework for recommending OLAP queries 
    Giacometti, Arnaud; Marcel, Patrick; Negre, Elsa (2008) Communication / Conférence
  • Thumbnail
    OLAP : un pas vers la navigation 
    Giacometti, Arnaud; Marcel, Patrick; Negre, Elsa (2006) Communication / Conférence
  • Thumbnail
    A survey of query recommendation techniques for data warehouse exploration 
    Marcel, Patrick; Negre, Elsa (2011) Communication / Conférence
  • Thumbnail
    Context-based exploitation of data warehouses 
    Choong, Yeow Wei; Giacometti, Arnaud; Laurent, Dominique; Marcel, Patrick; Negre, Elsa; Spyratos, Nicolas (2007) Communication / Conférence
Dauphine PSL Bibliothèque logo
Place du Maréchal de Lattre de Tassigny 75775 Paris Cedex 16
Phone: 01 44 05 40 94
Contact
Dauphine PSL logoEQUIS logoCreative Commons logo