A Conceptual Modeling Approach for OLAP Personalization

  • Authors:
  • Irene Garrigós;Jesús Pardillo;Jose-Norberto Mazón;Juan Trujillo

  • Affiliations:
  • Lucentia Research Group, Department of Software and Computing Systems --- DLSI, University of Alicante, Spain;Lucentia Research Group, Department of Software and Computing Systems --- DLSI, University of Alicante, Spain;Lucentia Research Group, Department of Software and Computing Systems --- DLSI, University of Alicante, Spain;Lucentia Research Group, Department of Software and Computing Systems --- DLSI, University of Alicante, Spain

  • Venue:
  • ER '09 Proceedings of the 28th International Conference on Conceptual Modeling
  • Year:
  • 2009

Quantified Score

Hi-index 0.00

Visualization

Abstract

Data warehouses rely on multidimensional models in order to provide decision makers with appropriate structures to intuitively analyze data with OLAP technologies. However, data warehouses may be potentially large and multidimensional structures become increasingly complex to be understood at a glance. Even if a departmental data warehouse (also known as data mart) is used, these structures would be also too complex. As a consequence, acquiring the required information is more costly than expected and decision makers using OLAP tools may get frustrated. In this context, current approaches for data warehouse design are focused on deriving a unique OLAP schema for all analysts from their previously stated information requirements, which is not enough to lighten the complexity of the decision making process. To overcome this drawback, we argue for personalizing multidimensional models for OLAP technologies according to the continuously changing user characteristics, context, requirements and behaviour. In this paper, we present a novel approach to personalizing OLAP systems at the conceptual level based on the underlying multidimensional model of the data warehouse, a user model and a set of personalization rules. The great advantage of our approach is that a personalized OLAP schema is provided for each decision maker contributing to better satisfy their specific analysis needs. Finally, we show the applicability of our approach through a sample scenario based on our CASE tool for data warehouse development.