Skip to main content
SpringerLink
Log in

A Unified Object Constraint Model for Designing and Implementing Multidimensional Systems

  • Chapter
Journal on Data Semantics XIII

Part of the book series: Lecture Notes in Computer Science ((JODS,volume 5530))

Abstract

Models for representing multidimensional systems usually consider that facts and dimensions are two different things. In this paper we propose a model based on UML which unifies the representations of fact and of dimension members. Since a given element can play the role of a fact or of a dimension member, this model allows for more flexibility in the design and the implementation of multidimensional systems. Moreover this model offers the possibility to express various constraints to guarantee desirable properties for data. We then show that this model is able to handle most of the hierarchies which have been suggested to take real situations into account and to characterize certain properties of summarizability. Using this model we propose a complete development cycle of a multidimensional system. It appears that this cycle can be partially automated and that an end user can control the design and the implementation of his system himself.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Abelló, A., Samos, J., Saltor, F.: Understanding Analysis Dimensions in a Multidimensional Object-Oriented Model. In: Proc. of Intl. Workshop on Design and Management of Multidimensional structures, DMDW 2001, Interlaken, Switzerland, June 4 (2001)

    Google Scholar 

  2. Abelló, A., Samos, J., Saltor, F.: A framework for the classification and description of multidimensional data models. In: Mayr, H.C., Lazanský, J., Quirchmayr, G., Vogel, P. (eds.) DEXA 2001. LNCS, vol. 2113, pp. 668–677. Springer, Heidelberg (2001)

    Chapter  Google Scholar 

  3. Abelló, A., Samos, J., Saltor, F.: Understanding facts in a multidimensional object-oriented model. In: Proceedings of the 4th ACM International Workshop on Data Warehousing and OLAP (DOLAP 2001), pp. 32–39 (2001)

    Google Scholar 

  4. Abelló, A., Samos, J., Saltor, F.: YAM2: A Multidimensional Conceptual Model Extending UML. Information Systems 31, 541–567 (2006)

    Article  Google Scholar 

  5. Agrawal, R., Gupta, A., Sarawagi, S.: Modelling Multidimensional Databases. In: 13th International Conference on Data Engineering, ICDE 1997, Birmingham, UK, April 7-11, pp. 232–243 (1997)

    Google Scholar 

  6. Balsters, H.: Modelling Database Views with Derived Classes in the UML/OCL-Framework. In: Stevens, P., Whittle, J., Booch, G. (eds.) UML 2003. LNCS, vol. 2863, pp. 295–309. Springer, Heidelberg (2003)

    Google Scholar 

  7. Blaschka, M., Sapia, C., Hofling, G., Dinter, B.: Finding your way through multidimensional data models. In: Quirchmayr, G., Bench-Capon, T.J.M., Schweighofer, E. (eds.) DEXA 1998. LNCS, vol. 1460, pp. 198–203. Springer, Heidelberg (1998)

    Google Scholar 

  8. Carpani, F., Ruggia, R.: An Integrity Constraints Language for a Conceptual Multidimensional Data Model. In: 13th International Conference on Software Engineering and Knowledge Engineering (SEKE 2001), pp. 220–227 (2001)

    Google Scholar 

  9. Datta, A., Thomas, H.: The Cube Data Model: A Conceptual Model and Algebra for on-line Analytical Processing in Multidimensional structures. Decision Support Systems 27(3), 289–301 (1999)

    Article  Google Scholar 

  10. Demuth, B., Hußmann, H., Loecher, S.: OCL as a specification language for business rules in database applications. In: Gogolla, M., Kobryn, C. (eds.) UML 2001. LNCS, vol. 2185, pp. 104–117. Springer, Heidelberg (2001)

    Chapter  Google Scholar 

  11. Giovinazzo, W.A.: Object-oriented data warehouse design: building a star schema. Prentice Hall PTR, Upper Saddle River (2000)

    Google Scholar 

  12. Ghozzi, F., Ravat, F., Teste, O., Zurfluh, G.: Constraints and Multidimensional Databases. In: ICEIS, pp. 104–111 (2003)

    Google Scholar 

  13. Golfarelli, M., Maio, D., Rizzi, S.: Conceptual Design of Multidimensional structures from E/R Schemes. In: Proc. of the 32th HICSS (1998)

    Google Scholar 

  14. Gyssens, M., Lakshmanan, V.S.: A Foundation for Multi-dimensional Databases. In: Proc. of the 23rd Conference on Very Large Databases, pp. 106–115 (1997)

    Google Scholar 

  15. Hahn, K., Sapia, C., Blaschka, M.: Automatically Generating OLAP Schemata from Conceptual Graphical Models. In: Proc. of the 3rd ACM International Workshop on Data Warehousing and OLAP, DOLAP 2000, McLean, Virginia, USA (2000)

    Google Scholar 

  16. Herden, O.: A Design Methodology for Data Warehouses. In: Proc. of the CAISE Doctoral Consortium, Stockholm (2000)

    Google Scholar 

  17. Hurtado, C.A., Mendelzon, A.O.: OLAP Dimension Constraints. In: PODS 2002, pp. 169–179 (2002)

    Google Scholar 

  18. Hurtado, C.A., Gutiérrez, C., Mendelzon, A.O.: Capturing summarizability with integrity constraints in OLAP. ACM Trans. Database Syst. (TODS) 30(3), 854–886 (2005)

    Article  Google Scholar 

  19. Hùsemann, B., Lechtenbörger, J., Vossen, G.: Conceptual Multidimensional Structures Design. In: Proc. of Intl. Workshop on Design and Management of Multidimensional structures (DMDW 2000), Stockholm, Sweden, June 5-6 (2000)

    Google Scholar 

  20. Jensen, M.R., Holmgren, T., Pedersen, T.B.: Discovering multidimensional structure in relational data. In: Kambayashi, Y., Mohania, M., Wöß, W. (eds.) DaWaK 2004. LNCS, vol. 3181, pp. 138–148. Springer, Heidelberg (2004)

    Google Scholar 

  21. Kimball, R.: The Data Warehouse Toolkit. John Wiley & Sons Inc., New York (1996)

    Google Scholar 

  22. Kimball, R., Reeves, L., Ross, M., Thornwaite, W.: The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses. John Wiley & Sons Inc., New York (1998)

    Google Scholar 

  23. Klasse Objecten: OCL tools Web site (2005), http://www.klasse.nl/ocl

  24. Lechtenbôrger, J., Vossen, G.: Multidimensional Normal Forms for Multidimensional structure Design. Information Systems 28(5) (2003)

    Google Scholar 

  25. Lehner, W.: Modeling Large Scale OLAP Scenarios. In: Schek, H.-J., Saltor, F., Ramos, I., Alonso, G. (eds.) EDBT 1998. LNCS, vol. 1377, pp. 153–167. Springer, Heidelberg (1998)

    Chapter  Google Scholar 

  26. Lehner, W., Albrecht, J., Wedekind, H.: Normal Forms for Multidimensional Data Bases. In: l0th Intl. Conference on Scientific and Statistical Data Management (SSDBM 1998), Capri, Italy, pp. 63–72 (1998)

    Google Scholar 

  27. Lenz, H.J., Shoshani, A.: Summarizability in OLAP and Statistical Data Bases. In: Proc. of the 9th SSDBM, pp. 132–143 (1997)

    Google Scholar 

  28. Levene, M., Loizou, G.: Why is the Star Schema a Good Multidimensional structure Design (1999), http://citeseer.ni.nec.com/457156.html

  29. Levene, M., Loizou, G.: Why is the Snowflake Schema a Good Multidimensional structure Design. Information Systems 28(3), 225–240 (2003)

    Article  Google Scholar 

  30. Li, C., Wang, X.S.: A Data Model for Supporting on-line Analytical Processing. In: Proc. of the Fifth International Conference on Information and Knowledge Management, pp. 81–88 (1996)

    Google Scholar 

  31. Luján-Mora, S., Trujillo, J., Song, I.Y.: A UML Profile for Multidimensional Modeling in Data Warehouses. Data & Knowledge Engineering 59, 725–769 (2006)

    Article  Google Scholar 

  32. Malinowski, E., Zimányi, E.: Hierarchies in a multidimensional model: From conceptual modeling to logical representation. Data Knowl. Eng. (DKE) 59(2), 348–377 (2006)

    Article  Google Scholar 

  33. Malinowski, E., Zimanyi, E.: Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications, 435 pages. Springer, Heidelberg (2008)

    MATH  Google Scholar 

  34. Mansmann, S., Scholl, M.H.: Empowering the OLAP Technology to Support Complex Dimension Hierarchies. International Journal of Data Warehousing and Mining 3(4), 31–50 (2007)

    Google Scholar 

  35. Mansmann, S., Scholl, M.H.: Extending the Multidimensional Data Model to Handle Complex Data. Journal of Computing Science and Engineering 1(2), 125–160 (2007)

    Google Scholar 

  36. Mazon, J.N., Trujillo, J.: An MDA Approach for the Development of Data Warehouses. Decision Support Systems (45), 41–58 (2008)

    Article  Google Scholar 

  37. Moody, L.D., Kortink, M.A.R.: From Enterprise Models to Dimensional Models: A Methodology for Multidimensional Structure and Data Mart Design. In: Proc. of the International Workshop on Design and Management of Multidimensional structures, DMDW 2000, Stockholm, Sweden (2000)

    Google Scholar 

  38. Niemi, T., Nummenmaa, J.: Logical Multidimensional Database Design for Ragged and Unbalanced Aggregation Hierarchies. In: Proc. of the International Workshop on Design and Management of Multidimensional structures, DMDW 2001, Interlaken, Switzerland (2001)

    Google Scholar 

  39. Nguyen, T.B., Tjoa, A.M., Wagner, R.: An Object Oriented Multidimensional Data Model for OLAP. In: Lu, H., Zhou, A. (eds.) WAIM 2000. LNCS, vol. 1846, pp. 69–82. Springer, Heidelberg (2000)

    Chapter  Google Scholar 

  40. OMG: OCL 2.0 specification version 2.0. OMG specification, 185 pages (2005), http://www.omg.org

  41. Pedersen, T.B., Jensen, C.S.: Multidimensional Data Modelling for Complex Data. In: Proc. of the Intl. Conference on Data Engineering, ICDE 1999, pp. 336–345 (1999)

    Google Scholar 

  42. Pedersen, T.B., Jensen, C.S., Dyreson, C.E.: A foundation for capturing and querying complex multidimensional data. Information Systems 26(5), 383–423 (2001)

    Article  MATH  Google Scholar 

  43. Pourabbas, E., Rafanelli, M.: Characterization of Hierarchies and some Operators in OLAP Environment. In: DOLAP 1999, Kansas City, USA, pp. 54–59 (1999)

    Google Scholar 

  44. Prat, N., Akoka, A., Comyn-Wattiau, I.: A UML-based data warehouse design method. Decision Support Systems (DSS) 42(3), 1449–1473 (2006)

    Article  Google Scholar 

  45. Rafanelli, M., Shoshani, A.: STORM: A Statistical Object Representation Model. In: Statistical and Scientific Data Base Management Conference (SSDBM), pp. 14–29 (1990)

    Google Scholar 

  46. Song, I.Y., Medsker, C., Rowen, W., Ewen, E.: An Analysis of Many-to-Many Relationships Between Fact and Dimension Tables in Dimension Modeling. In: Proceedings of the Int’l. Workshop on Design and Management of Data Warehouses, pp. 6-1–6-13 (2001)

    Google Scholar 

  47. Vassiliadis, P., Skiadopoulos, S.: Modelling and Optimisation Issues for Multidimensional Databases. In: Proc. of the 12th Intl. Conference CAISE, Stockholm, Sweden, pp. 482–497 (2000)

    Google Scholar 

  48. Theodoratos, D., Ligoudistianos, S., Sellis, T.: View selection for designing the global Multidimensional structure. Data & Knowledge Engineering 39, 219–240 (2001)

    Article  MATH  Google Scholar 

  49. Trujillo, J., Palomar, M.: An object Oriented Approach to Multidimensional Database Conceptual Modeling (OOMD). In: Proc. of the 1st ACM international workshop on Data warehousing and OLAP, Washington, pp. 16–21 (1998)

    Google Scholar 

  50. Tsois, A., Karayannidis, N., Sellis, T.: MAC: Conceptual Data Modeling for OLAP. In: Proc. of the Intl Workshop on Design and Management of Multidimensional structures (DMDW 2001), Interlaken, Switzerland, June 4 (2001)

    Google Scholar 

  51. Warmer, J., Kleppe, A.: OCL: The constraint language of the UML. Journal of Object-Oriented Programming 12, 13–28 (1999)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Cemagref, 24 Avenue des Landais, 63172, Aubière Cedex, France

    François Pinet & Michel Schneider

  2. LIMOS, Complexe des Cézeaux, 63173, Aubière Cedex, France

    Michel Schneider

Authors
  1. François Pinet
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Michel Schneider
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. EPFL-IC, Database Laboratory, École Polytechnique Fédérale de Lausanne, 1015, Lausanne, Switzerland

    Stefano Spaccapietra

  2. Department of Computer and Decision Engineering,, Université Libre de Bruxelles, 50av. F.D. Roosevelt, 1050, Bruxelles, Belgium

    Esteban Zimányi

  3. College of Information Science and Technology,, Drexel University, 19104, Philadelphia, PA, USA

    Il-Yeol Song

Rights and permissions

Reprints and permissions

Copyright information

© 2009 Springer-Verlag Berlin Heidelberg

About this chapter

Cite this chapter

Pinet, F., Schneider, M. (2009). A Unified Object Constraint Model for Designing and Implementing Multidimensional Systems. In: Spaccapietra, S., Zimányi, E., Song, IY. (eds) Journal on Data Semantics XIII. Lecture Notes in Computer Science, vol 5530. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-03098-7_2

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-03098-7_2

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-03097-0

  • Online ISBN: 978-3-642-03098-7

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation