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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Kimball, R., Ross, M.: The Data Warehouse Toolkit. Wiley & Sons, Chichester (2002)
Jarke, M., Lenzerini, M., Vassiliou, Y., Vassiliadis, P.: Fundamentals of Data Warehouses. Springer, Heidelberg (2000)
Choong, Y.W., Laurent, D., Marcel, P.: Computing appropriate representations for multidimensional data. Data Knowl. Eng. 45(2), 181–203 (2003)
Rizzi, S., Abelló, A., Lechtenbörger, J., Trujillo, J.: Research in data warehouse modeling and design: dead or alive? In: Song, I.Y., Vassiliadis, P. (eds.) DOLAP, pp. 3–10. ACM, New York (2006)
Stefanidis, K., Pitoura, E., Vassiliadis, P.: Modeling and Storing Context-Aware Preferences. In: ADBIS, pp. 124–140 (2006)
Rizzi, S.: OLAP preferences: a research agenda. In: DOLAP, pp. 99–100 (2007)
Mouloudi, H., Bellatreche, L., Giacometti, A., Marcel, P.: Personalization of mdx queries. In: BDA (2006)
Kießling, W.: Foundations of Preferences in Database Systems. In: VLDB, pp. 311–322 (2002)
Bellatreche, L., Giacometti, A., Marcel, P., Mouloudi, H., Laurent, D.: A personalization framework for OLAP queries. In: Song, I.Y., Trujillo, J. (eds.) DOLAP, pp. 9–18. ACM, New York (2005)
Ioannidis, Y.E., Koutrika, G.: Personalized systems: Models and methods from an ir and db perspective. In: VLDB, p. 1365 (2005)
Jerbi, H., Ravat, F., Teste, O., Zurfluh, G.: Management of context-aware preferences in multidimensional databases. In: ICDIM, pp. 669–675 (2008)
Ravat, F., Teste, O.: Personalization and OLAP databases. In: Volume New Trends in Data Warehousing and Data Analysis of Annals of Information Systems, pp. 71–92. Springer, Heidelberg (2009)
Luján-Mora, S., Trujillo, J., Song, I.-Y.: A UML profile for multidimensional modeling in data warehouses.. Data Knowl. Eng. 59(3), 725–769 (2006)
Kappel, G., Pröll, B., Retschitzegger, W., Schwinger, W.: Modelling Ubiquitous Web Applications - The WUML Approach. In: ER (Workshops), pp. 183–197 (2001)
Garrigós, I.: A-OOH: Extending Web Application Design with Dynamic Personalization. PhD thesis, University of Alicante, Spain (2008)
Garrigós, I., Cruz, C., Gómez, J.: A prototype tool for the automatic generation of adaptive websites. In: Casteleyn, S., Daniel, F., Dolog, P., Matera, M., Houben, G.J., Troyer, O.D. (eds.) AEWSE. CEUR Workshop Proceedings, CEUR-WS.org., vol. 267 (2007)
Soler, E., Stefanov, V., Mazón, J.-N., Trujillo, J., Fernández-Medina, E., Piattini, M.: Towards comprehensive requirement analysis for data warehouses: Considering security requirements. In: ARES, pp. 104–111. IEEE Computer Society, Los Alamitos (2008)
Pardillo, J., Mazón, J.-N., Trujillo, J.: Bridging the semantic gap in OLAP models: platform-independent queries. In: DOLAP, pp. 89–96 (2008)
Object Management Group: Unified Modeling Language (UML), version 2.1.1. (February 2007), http://www.omg.org/technology/documents/formal/uml.htm
Pardillo, J., Mazón, J.-N., Trujillo, J.: Model-driven metadata for OLAP cubes from the conceptual modelling of data warehouses. In: Song, I.-Y., Eder, J., Nguyen, T.M. (eds.) DaWaK 2008. LNCS, vol. 5182, pp. 13–22. Springer, Heidelberg (2008)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2009 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Garrigós, I., Pardillo, J., Mazón, JN., Trujillo, J. (2009). A Conceptual Modeling Approach for OLAP Personalization. In: Laender, A.H.F., Castano, S., Dayal, U., Casati, F., de Oliveira, J.P.M. (eds) Conceptual Modeling - ER 2009. ER 2009. Lecture Notes in Computer Science, vol 5829. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-04840-1_30
Download citation
DOI: https://doi.org/10.1007/978-3-642-04840-1_30
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-04839-5
Online ISBN: 978-3-642-04840-1
eBook Packages: Computer ScienceComputer Science (R0)