A Framework for OLAP Content Personalization

A perennial challenge faced by many organizations is the management of their increasingly large multidimensional databases (MDB) that can contain millions of data instances. The problem is exacerbated by the diversity of the users' specific needs. Personalization of MDB content according to how well they match user's preferences becomes an effective approach to make the right information available to the right user under the right analysis context. In this paper, we propose a framework called OLAP Content Personalization (OCP) that aims at deriving a personalized content of a MDB based on user preferences. At query time, the system enhances the query with related user preferences in order to simulate its performance upon an individual content. We discuss results of experimentation with a prototype for content personalization.

[1]  Matteo Golfarelli,et al.  Expressing OLAP Preferences , 2009, SSDBM.

[2]  Olivier Teste,et al.  Personalization and OLAP Databases , 2009, New Trends in Data Warehousing and Data Analysis.

[3]  Barry Smyth,et al.  Personalization techniques for online recruitment services , 2002, CACM.

[4]  Olivier Teste,et al.  Algebraic and Graphic Languages for OLAP Manipulations , 2008, Int. J. Data Warehous. Min..

[5]  Olivier Teste,et al.  Applying Recommendation Technology in OLAP Systems , 2009, ICEIS.

[6]  Arnaud Giacometti,et al.  Recommending Multidimensional Queries , 2009, DaWaK.

[7]  Cécile Favre,et al.  Evolution of Data Warehouses' Optimization: A Workload Perspective , 2007, DaWaK.

[8]  Irene Garrigós,et al.  A Conceptual Modeling Approach for OLAP Personalization , 2009, ER.

[9]  Timos K. Sellis,et al.  State-space optimization of ETL workflows , 2005, IEEE Transactions on Knowledge and Data Engineering.

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

[11]  Olivier Teste,et al.  Preference-Based Recommendations for OLAP Analysis , 2009, DaWaK.

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

[13]  Alberto O. Mendelzon,et al.  Maintaining data cubes under dimension updates , 1999, Proceedings 15th International Conference on Data Engineering (Cat. No.99CB36337).

[14]  Stefano Rizzi.  OLAP preferences: a research agenda , 2007, DOLAP '07.

[15]  Hamid Pirahesh,et al.  Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals , 1996, Data Mining and Knowledge Discovery.

[16]  Olivier Teste,et al.  Management of context-aware preferences in multidimensional databases , 2008, 2008 Third International Conference on Digital Information Management.

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

[18]  Jiawei Han,et al.  Answering top-k queries with multi-dimensional selections: the ranking cube approach , 2006, VLDB.