YAM2: a multidimensional conceptual model extending UML

This paper presents a multidimensional conceptual Object-Oriented model for Data Warehousing and OLAP tools, its structures, integrity constraints and query operations. It has been developed as an extension of UML core metaclasses to facilitate its usage, and try to fill the absence of a standard model. Being a UML extension allows reusing modeling constructs and techniques, and integrating multidimensional modeling in more general modeling processes. Moreover, while existing multidimensional models are restricted to the modeling of isolated stars, this paper investigates the representation of several semantically related star schemas. Summarizability and identification constraints can also be represented in the model, and a closed and complete set of algebraic operations has been defined in terms of functions (so that mathematical properties of functions can be smoothly applied).

[1]  Bernhard Thalheim,et al.  Modelling Data Warehouses and OLAP Applications by Means of Dialogue Objects , 1999, ER.

[2]  Sunita Sarawagi,et al.  Modeling multidimensional databases , 1997, Proceedings 13th International Conference on Data Engineering.

[3]  Laks V. S. Lakshmanan,et al.  A Foundation for Multi-dimensional Databases , 1997, VLDB.

[4]  Chun Zhang,et al.  Storing and querying ordered XML using a relational database system , 2002, SIGMOD '02.

[5]  Luca Cabibbo,et al.  A Logical Approach to Multidimensional Databases , 1998, EDBT.

[6]  Barbara Dinter,et al.  Extending the E/R Model for the Multidimensional Paradigm , 1998, ER Workshops.

[7]  W. H. Inmon,et al.  Building the data warehouse , 1992 .

[8]  Nectaria Tryfona,et al.  starER: a conceptual model for data warehouse design , 1999, DOLAP '99.

[9]  José Samos,et al.  YAM/sup 2/ (yet another multidimensional model): an extension of UML , 2002, Proceedings International Database Engineering and Applications Symposium.

[10]  Panos Vassiliadis,et al.  Modeling multidimensional databases, cubes and cube operations , 1998, Proceedings. Tenth International Conference on Scientific and Statistical Database Management (Cat. No.98TB100243).

[11]  Wolfgang Lehner,et al.  Modelling Large Scale OLAP Scenarios , 1998, EDBT.

[12]  José Samos,et al.  Understanding Analysis Dimensions in a Multidimensional Object-Oriented Model , 2001, DMDW.

[13]  Ulrike Sattler,et al.  A Data Warehouse Conceptual Data Model for Multidimensional Aggregation , 1999, DMDW.

[14]  Enrico Franconi,et al.  The GMD Data Model for Multidimensional Information: a brief introduction , 2003, SEBD.

[15]  Anindya Datta,et al.  A Conceptual Model and Algebra for On-Line Analytical Processing in Decision Support Databases , 2001, Inf. Syst. Res..

[16]  Arie Shoshani,et al.  Summarizability in OLAP and statistical data bases , 1997, Proceedings. Ninth International Conference on Scientific and Statistical Database Management (Cat. No.97TB100150).

[17]  Manuel Palomar,et al.  An object oriented approach to multidimensional database conceptual modeling (OOMD) , 1998, DOLAP '98.

[18]  Serge Abiteboul,et al.  Foundations of Databases , 1994 .

[19]  Panos Vassiliadis,et al.  Data Warehouse Modeling and Quality Issues , 2000 .

[20]  Barbara Dinter,et al.  Finding your way through multidimensional data models , 1998, Proceedings Ninth International Workshop on Database and Expert Systems Applications (Cat. No.98EX130).

[21]  Il-Yeol Song,et al.  An Analysis of Many-to-Many Relationships Between Fact and Dimension Tables in Dimensional Modeling , 2001, DMDW.

[22]  David Maier,et al.  Towards an effective calculus for object query languages , 1995, SIGMOD '95.

[23]  José Samos,et al.  Implementing operations to navigate semantic star schemas , 2003, DOLAP '03.

[24]  Torben Bach Pedersen,et al.  Multidimensional data modeling for complex data , 1999, Proceedings 15th International Conference on Data Engineering (Cat. No.99CB36337).

[25]  Matteo Golfarelli,et al.  Conceptual design of data warehouses from E/R schemes , 1998, Proceedings of the Thirty-First Hawaii International Conference on System Sciences.

[26]  W. H. Inmon,et al.  Building the data warehouse (2nd ed.) , 1996 .

[27]  Fèlix Saltor,et al.  Suitability of datamodels as canonical models for federated databases , 1991, SGMD.

[28]  José Samos,et al.  Understanding facts in a multidimensional object-oriented model , 2001, DOLAP '01.

[29]  Torben Bach Pedersen,et al.  Aspects of Data Modeling and Query Processing for Complex Multidimensional Data , 2000 .

[30]  Sergio Luján-Mora,et al.  Extending the UML for Multidimensional Modeling , 2002, UML.

[31]  Timos K. Sellis,et al.  A survey of logical models for OLAP databases , 1999, SGMD.

[32]  Ulrike Sattler,et al.  An object-centered multi-dimensional data model with hierarchically structured dimensions , 1997, Proceedings 1997 IEEE Knowledge and Data Engineering Exchange Workshop.

[33]  Matteo Golfarelli,et al.  The Dimensional Fact Model: A Conceptual Model for Data Warehouses , 1998, Int. J. Cooperative Inf. Syst..

[34]  Chang Li,et al.  A data model for supporting on-line analytical processing , 1996, CIKM '96.

[35]  A Min Tjoa,et al.  An Object Oriented Multidimensional Data Model for OLAP , 2000, Web-Age Information Management.