Personalization of MDX Queries

Answers of OLAP queries often cannot be visualized entirely and the user has to navigate through them to find relevant facts. One possible way to solve this problem is to personalize the queries. The basic idea behind the process of query personalization is that different users may find and see the facts they prefer without having to navigate. In this paper, we propose a framework for personalizing MDX queries. MDX allows the user to express complex queries on multidi- mensional data and to specify how the result will be presented on the screen. In this work, we present a preference model which allows the user to define his preferred dimensions and members. In addition, we provide an algorithm that, given an MDX query, a user profile and a visualization constraint, computes and displays the best answer to a user w.r.t. his (her) preferences and the constraints.

[1]  Werner Kießling,et al.  Foundations of Preferences in Database Systems , 2002, VLDB.

[2]  Georgia Koutrika,et al.  Constrained optimalities in query personalization , 2005, SIGMOD '05.

[3]  Ronen I. Brafman,et al.  CP-nets: A Tool for Representing and Reasoning withConditional Ceteris Paribus Preference Statements , 2011, J. Artif. Intell. Res..

[4]  Riccardo Torlone,et al.  Finding the Best when it's a Matter of Preference , 2002, SEBD.

[5]  Vagelis Hristidis,et al.  PREFER: a system for the efficient execution of multi-parametric ranked queries , 2001, SIGMOD '01.

[6]  Jan Chomicki,et al.  Preference formulas in relational queries , 2003, TODS.

[7]  Ramakrishnan Srikant,et al.  Fast Algorithms for Mining Association Rules in Large Databases , 1994, VLDB.

[8]  Georgia Koutrika,et al.  Personalization of queries in database systems , 2004, Proceedings. 20th International Conference on Data Engineering.

[9]  Arnaud Giacometti,et al.  A new way of optimizing OLAP queries , 2004, BDA.

[10]  Patrick Marcel,et al.  Modeling and querying multidimensional databases: an overview , 1999 .

[11]  Arnaud Giacometti,et al.  A personalization framework for OLAP queries , 2005, DOLAP '05.

[12]  Rakesh Agrawal,et al.  A framework for expressing and combining preferences , 2000, SIGMOD '00.

[13]  Nic Wilson,et al.  Extending CP-Nets with Stronger Conditional Preference Statements , 2004, AAAI.

[14]  Georgia Koutrika,et al.  Personalized queries under a generalized preference model , 2005, 21st International Conference on Data Engineering (ICDE'05).