文档介绍:Modeling Object Oriented Multidimensional
Data Model for OLAP
Nguyen Thanh Binh, A Min Tjoa
Institute of Software Technology (E188)
Vienna University of Technology
Favoritenstrasse 9-11/18, A-1040 Vienna, Austria
Email : {binh, tjoa}***@
Abstract (RDBMS), which are well standardized and meet the
needs of storing large amounts of data. Dimensions
In this paper, we use UML (Unified Modeling and facts are mapped into relational tables, called fact
Language) to model a new object oriented and dimension tables, organized as Star Schema
multidimensional data model for OLAP. The UML and/or Snowflake Schema [12]. Therefore in many
class diagrams are used to specify multidimensional cases, ROLAP products are not suitable for handling
data objects, such as dimensions, measures and data dimensions with multihierarchical and unbalanced
cubes and relationships among them. Based on the structures. [9] clearly demonstrated the mismatch
formal representation of the class specifications in between multidimensional operations and SQL.
UML, the design and implementation of the data Although MOLAP (Multidimensional OLAP)
model for object oriented databases are easily supports dimensions with multiple and
straightforward. unbalanced hierarchical structures and MOLAP
queries are very powerful and flexible in terms of
1. Introduction