Benchmarking Exploratory OLAP

Mahfoud Djedaini (1) , Pedro Furtado (2) , Nicolas Labroche (1) , Patrick Marcel (1) , Veronika Peralta (1)

1 BDTLN - Bases de données et traitement des langues naturelles
2 UC - University of Coimbra [Portugal]

Supporting interactive database exploration (IDE) is a problem that attracts lots of attention these days. Exploratory OLAP (On- Line Analytical Processing) is an important use case where tools sup- port navigation and analysis of the most interesting data, using the best possible perspectives. While many approaches were proposed (like query recommendation, reuse, steering, personalization or unexpected data recommendation), a recurrent problem is how to assess the effectiveness of an exploratory OLAP approach. In this paper we propose a benchmark framework to do so, that relies on an extensible set of user-centric metrics that relate to the main dimensions of exploratory analysis. Namely, we describe how to model and simulate user activity, how to formalize our metrics and how to build exploratory tasks to properly evaluate an IDE system under test (SUT). To the best of our knowledge, this is the first proposal of such a benchmark. Experiments are two-fold: first we evaluate the benchmark protocol and metrics based on synthetic SUTs whose behavior is well known. Second, we concentrate on two different recent SUTs from IDE literature that are evaluated and compared with our benchmark. Finally, potential extensions to produce an industry- strength benchmark are listed in the conclusion.

Domaines: Base de données [cs.DB]

Mahfoud Djedaini, Pedro Furtado, Nicolas Labroche, Patrick Marcel, Veronika Peralta. Benchmarking Exploratory OLAP. Eighth TPC Technology Conference on Performance Evaluation & Benchmarking (TPCTC 2016), Sep 2016, New Delhi, India. ⟨hal-01398959⟩