Abstract
Data warehouses and OLAP systems form an integral part of modern decision support systems. In order to exploit both systems to their full capabilities hierarchies must be clearly defined. Hierarchies are important in analytical applications, since they provide users with the possibility to represent data at different abstraction levels. However, even though there are different kinds of hierarchies in real-world applications and some are already implemented in commercial tools, there is still a lack of a well-accepted conceptual model that allows decision-making users express their analysis needs. In this paper, we show how the conceptual multidimensional model can be used to facilitate the representation of complex hierarchies in comparison to their representation in the relational model and commercial OLAP tool, using as an example Microsoft Analysis Services.
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
Abelló, A., Samos, J., Saltor, F.: YAM2 (yet another multidimensional model): An extension of UML. Information Systems 32(6), 541–567 (2006)
Golfarelli, M., Rizzi, S.: A methodological framework for data warehouse design. In: Proc. of the 1st ACM Int. Workshop on Data Warehousing and OLAP, pp. 3–9 (1998)
Hümmer, W., Lehner, W., Bauer, A., Schlesinger, L.: A decathlon in multidimensional modeling: Open issues and some solutions. In: Kambayashi, Y., Winiwarter, W., Arikawa, M. (eds.) DaWaK 2002. LNCS, vol. 2454, pp. 275–285. Springer, Heidelberg (2002)
Hurtado, C., Gutierrez, C.: Handling structural heterogeneity in OLAP. In: Wrembel, R., Koncilia, C. (eds.) Data Warehouses and OLAP: Concepts, Architectures and Solutions, ch. 2, pp. 27–57. IRM Press (2007)
Hüsemann, B., Lechtenbörger, J., Vossen, G.: Conceptual data warehouse design. In: Proc. of the Int. Workshop on Design and Management of Data Warehouses, p. 6 (2000)
Luján-Mora, S., Trujillo, J., Song, I.: A UML profile for multidimensional modeling in data warehouses. Data & Knowledge Engineering 59(3), 725–769 (2006)
Malinowski, E., Zimányi, E.: Advanced Datawarehouse Design: From Conventional to Spatial and Temporal Applications. Springer, Heidelberg (2008)
Microsoft Corporation. SQL Server 2005. Books Online (2003), http://technet.microsoft.com/en-us/sqlserver/bb895969.aspx
Pedersen, T., Jensen, C., Dyreson, C.: A foundation for capturing and querying complex multidimensional data. Information Systems 26(5), 383–423 (2001)
Pourabbas, E., Rafanelli, M.: Hierarchies. In: Rafanelli, M. (ed.) Multidimensional Databases: Problems and Solutions, pp. 91–115. Idea Group Publishing (2003)
Rizzi, S.: Open problems in data warehousing: 8 years later. In: Proc. of the 5th Int. Workshop on Design and Management of Data Warehouses (2003)
Sapia, C., Blaschka, M., Höfling, G., Dinter, B.: Extending the E/R model for multidimensional paradigm. In: Proc. of the 17th Int. Conf. on Conceptual Modeling, pp. 105–116 (1998)
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
Malinowski, E. (2009). Improving Expression Power in Modeling OLAP Hierarchies. In: Prasad, S.K., Routray, S., Khurana, R., Sahni, S. (eds) Information Systems, Technology and Management. ICISTM 2009. Communications in Computer and Information Science, vol 31. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-00405-6_6
Download citation
DOI: https://doi.org/10.1007/978-3-642-00405-6_6
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-00404-9
Online ISBN: 978-3-642-00405-6
eBook Packages: Computer ScienceComputer Science (R0)