A collaborative filtering approach for recommending OLAP sessions

Julien Aligon (1) , Enrico Gallinucci (2) , Matteo Golfarelli (2) , Patrick Marcel (1) , Stefano Rizzi (2)

1 LIFAT - Laboratoire d'Informatique Fondamentale et Appliquée de Tours
2 DISI - Department of Computer Science and Engineering [Bologna]

While OLAP has a key role in supporting effective exploration of multidimensional cubes, the huge number of aggregations and selections that can be operated on data may make the user experience disorientating. To address this issue, in the paper we propose a recommendation approach stemming from collaborative filtering. We claim that the whole sequence of queries belonging to an OLAP session is valuable because it gives the user a compound and synergic view of data; for this reason, our goal is not to recommend single OLAP queries but OLAP sessions. Like other collaborative approaches, ours features three phases: (i) search the log for sessions that bear some similarity with the one currently being issued by the user; (ii) extract the most relevant subsessions; and (iii) adapt the top-ranked subsession to the current user's session. However, it is the first that treats sessions as first-class citizens, using new techniques for comparing sessions, finding meaningful recommendation candidates, and adapting them to the current session. After describing our approach, we discuss the results of a large set of effectiveness and efficiency tests based on different measures of recommendation quality.

Mots clés: OLAP; Similarity measures; Query recommendation; Personalization

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

Julien Aligon, Enrico Gallinucci, Matteo Golfarelli, Patrick Marcel, Stefano Rizzi. A collaborative filtering approach for recommending OLAP sessions. Decision Support Systems, 2015, pp.20. ⟨10.1016/j.dss.2014.11.003⟩. ⟨hal-01170959⟩