
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
Type
Chapitre d'ouvrageDate
2013Book title
Advances in Knowledge Discovery and ManagementBook author
Guillet, Fabrice; Pinaud, Bruno; Venturini, Gilles; Zighed, Djamel AbdelkaderPublisher
Springer
Published in
Berlin
ISBN
978-3-642-35854-8
Number of pages
221Pages
99-124
Publication identifier
Metadata
Show full item recordAuthor(s)
Aligon, Julien
Laboratoire d'Informatique Fondamentale et Appliquée de Tours [LIFAT]
Marcel, Patrick

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; OLAPRelated items
Showing items related by title and author.
-
Aligon, Julien; Marcel, Patrick; Negre, Elsa (2010) Communication / Conférence
-
Aligon, Julien; Marcel, Patrick; Negre, Elsa (2011) Communication / Conférence
-
Giacometti, Arnaud; Marcel, Patrick; Negre, Elsa (2008) Communication / Conférence
-
Colas, Sonia; Marcel, Patrick; Negre, Elsa (2010) Communication / Conférence
-
Giacometti, Arnaud; Marcel, Patrick; Negre, Elsa (2009) Communication / Conférence