• 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

Summarizing and Querying Logs of OLAP Queries

Aligon, Julien; Marcel, Patrick; Negre, Elsa (2013), Summarizing and Querying Logs of OLAP Queries, in Guillet, Fabrice; Pinaud, Bruno; Venturini, Gilles; Zighed, Djamel Abdelkader, Advances in Knowledge Discovery and Management, Springer : Berlin, p. 99-124. 10.1007/978-3-642-35855-5_6

View/Open
akdm2011.pdf (318.5Kb)
Type
Chapitre d'ouvrage
Date
2013
Book title
Advances in Knowledge Discovery and Management
Book author
Guillet, Fabrice; Pinaud, Bruno; Venturini, Gilles; Zighed, Djamel Abdelkader
Publisher
Springer
Published in
Berlin
ISBN
978-3-642-35854-8
Number of pages
221
Pages
99-124
Publication identifier
10.1007/978-3-642-35855-5_6
Metadata
Show full item record
Author(s)
Aligon, Julien cc
Laboratoire d'Informatique Fondamentale et Appliquée de Tours [LIFAT]
Marcel, Patrick cc
Laboratoire d'Informatique Fondamentale et Appliquée de Tours [LIFAT]
Negre, Elsa
Laboratoire d'analyse et modélisation de systèmes pour l'aide à la décision [LAMSADE]
Abstract (EN)
Leveraging query logs benefits the users analyzing large data warehouses with OLAP queries. But so far nothing exists to allow the user to have concise and usable representations of what is in the log. In this article, we present a framework for summarizing and querying OLAP query logs. The basic idea is that a query summarizes another query and that a log, which is a sequence of queries, summarizes another log. Our formal framework includes a language to declaratively specify a summary, and a language for querying and manipulating logs. We also propose a simple measure based on precision and recall, to assess the quality of summaries, and two strategies for automatically computing log summaries of good quality. Finally we show how some simple properties on the summaries can be used to query the log efficiently. The framework is implemented using the Mondrian open source OLAP engine. Its interest is illustrated with experiments on synthetic yet realistic MDX query logs.
Subjects / Keywords
datawarehouse analysis; query logs; OLAP

Related items

Showing items related by title and author.

  • Thumbnail
    A framework for summarizing a log of OLAP queries 
    Aligon, Julien; Marcel, Patrick; Negre, Elsa (2010) Communication / Conférence
  • Thumbnail
    Résumés et interrogations de logs de requête OLAP 
    Aligon, Julien; Marcel, Patrick; Negre, Elsa (2011) Communication / Conférence
  • Thumbnail
    A framework for recommending OLAP queries 
    Giacometti, Arnaud; Marcel, Patrick; Negre, Elsa (2008) Communication / Conférence
  • Thumbnail
    Organisation de log de requêtes OLAP sous forme de site web 
    Colas, Sonia; Marcel, Patrick; Negre, Elsa (2010) Communication / Conférence
  • Thumbnail
    Recommending Multidimensional Queries 
    Giacometti, Arnaud; Marcel, Patrick; Negre, Elsa (2009) 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