Abstract
Data for decision-making applications are based on dimensions, such as time, customer, and product. These dimensions are naturally related by hierarchies. Hierarchies are crucial to multidimensional modeling. Defining hierarchies using star or snowflake schemas can be misleading, since they are not explicitly well-modeled. However, deriving them from conceptual UML or ER schemas is a non-trivial task since they have no direct equivalent in conceptual models. This paper focuses on the definition of multidimensional hierarchies. We present and illustrate rules for defining multidimensional hierarchies from UML schemas, especially based on aggregation and generalization hierarchies. The definition of hierarchies is part of a data warehouse design method based on the three usual modeling levels : conceptual, logical, and physical. The conceptual schema is based on the UML notation. The logical schema is represented using a unified pivot multidimensional model. The physical schema depends on the target ROLAP or MOLAP tool.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Agrawal, R., Gupta, A., Sarawagi, S.: Modeling multidimensional databases. 13th International Conference on Data Engineering (ICDE’ 97), Birmingham, UK, April.
Baralis, E., Paraboschi, S., Teniente, E.: Materialized view selection in a multidimensional database. Proceedings of the International Conference on Very Large Databases (1997)
Blaschka, M., Sapia, C., Höfling, G., Dinter, B.: Finding your way through multidimensional data models. DEXA Workshop on Data Warehouse Design and OLAP Technology (DWDOT’ 98), Vienna, Austria.
Cabibbo, L.,. Torlone, R.: A Logical Approach to Multidimensional Databases. Proceedings of 6th International Workshop on Extending Database Technology (EDBT’1998), Valencia (Spain), March.
Chaudhuri, S., Dayal, U.: An overview of data warehousing and OLAP Technology. SIGMOD Record, 26(1) (1997)
Gebhardt, M., Jarke, M., Jacobs, S.: A Toolkit for Negotiation Support Interfaces to Multidimensional Data. Proceedings of ACM SIGMOD Conf, Arizona, USA (1997)
Golfarelli, M.,.Maio, D.,.Rizzi, S.: Conceptual design of data warehouses from E/R schemes. 31st Hawaii International Conference on System Sciences, Hawaii, USA (1998)
Golfarelli, M., Rizzi, S.: A methodological framework for data warehousing design. ACM workshop on data warehousing and OLAP (1998)
Gyssens, M., Lakshmanan, L.V.S.: A foundation for multi-dimensional databases. 23rd VLDB Conference, Athens, Greece (1997)
Hüsemann, B., Lechtenbörger, J., Vossen, G.: Conceptual data warehouse design. 2nd International Workshop on Design and Management of Data Warehouses (DMDW 2000), Stockholm, Sweden, June
Jacobson, I., Booch, G., Rumbaugh, J.: The Unified Software Development Process. Addison Wesley Publishing Company
Jagadish, H.V., Lakshmanan, L.V.S., Srivastava, D.: What can Hierarchies do for Data Warehouses ? Proceedings of the 25th VLDB Conference, Edinburgh, Scotland (1999)
Kimball, R.: The data warehouse toolkit. John Wiley & Sons
Kimball, R.: A Dimensional Modeling Manifesto. DBMS on-line. http://dbmsmag.com/
Lehner, W., Albrecht, J., Wedekind, H.: Normal Forms for Multidimensional Databases. Proceedings 10th SSDBM conference, Italy, July (1998)
Li, C., Wang, X.S.: A data model for supporting on-line analytical processing., Proceedings Conference on Information and Knowledge Management (CIKM’1996), Baltimore, USA
Moody, D.L., Kortink, M.A.R.: From Enterprise Models to Dimensional Models: A Methodology for Data Warehouse and Data Mart Design. 2nd International Workshop on Design and Management of Data Warehouses (DMDW 2000), Stockholm, Sweden (2000)
Pedersen, T.B., Jensen, C.S.: Multidimensional data modeling for complex data. 15th International Conference on Data Engineering (ICDE’ 99), Sydney, Australia (1999)
Sapia, C., Blaschka, M., Höfling, G., Dinter, B.: Extending the E/R Model for the Multidimensional Paradigm. International Workshop on Data Warehousing and Data Mining in conjunction with ER98, Singapore (1998)
Smith, JM., Smith, DCP “Database Abstractions: Aggregations and Generalizations”. ACM TODS, 2(2) (1977)
Vassiliadis, P.: Gulliver in the land of data warehousing: practical experiences and observations of a researcher. Proceedings of the International Workshop on Design and Management of Data Warehouses (DMDW’2000), Stockholm, June (1999)
Vassiliadis, P., Sellis, T.: A survey of logical models for OLAP databases. SIGMOD Record, 28(4) December (1999)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2001 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Akoka, J., Comyn-Wattiau, I., Prat, N. (2001). Dimension Hierarchies Design from UML Generalizations and Aggregations. In: S.Kunii, H., Jajodia, S., Sølvberg, A. (eds) Conceptual Modeling — ER 2001. ER 2001. Lecture Notes in Computer Science, vol 2224. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-45581-7_33
Download citation
DOI: https://doi.org/10.1007/3-540-45581-7_33
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-42866-4
Online ISBN: 978-3-540-45581-3
eBook Packages: Springer Book Archive