Data Management

Object Oriented Multidimensional Model for a Data Warehouse with Operators

Download Now Date Added: Dec 2010
Format: PDF

Data warehouse is organized as collection of multidimensional cube, which represents data in the form of data values, called measures, associated with multiple dimensions and their multiple classification levels. In multidimensional cube, object oriented approach may be used for structuring the data. In this paper object oriented multidimensional data model is defined for description of data which include aggregation, generalization, multiple path hierarchies, multiplicity etc. Seven operators over the model are introduced, necessary to make a query and format results: intersection, difference, symmetric difference, restriction, union, join and projection. These operators are minimal means none can be expressed in terms of others nor can anyone be dropped without sacrificing functionality. This paper extends the work of Alexander which includes only four operators: Restriction, union, join and projection.