Object Oriented Approach using Multidimensional OLAP Data Model
Main Article Content
Abstract
The introduction of metadata management concept is given which is based on the object-oriented paradigm for modelling and
querying multidimensional OLAP-data. In this model we apply the basic concepts of the object-oriented model including object, class, and
relationship between objects to describe objects of multidimensional data and the OLAP operations. In our approach the multidimensional
OLAP-data is modelled as a fact and a set of dimensions that are organized into class-hierarchy. On-line Analytical Processing (OLAP) is
emerging as the most important approach in Data Warehousing. OLAP allows modelling data in a multidimensional way as a cube and to query
and analyze data from many different perspectives. Multidimensional OLAP data is presented as a multidimensional data cube. The
Multidimensional data cube can be modelled by using facts and set of dimensions based on the notion of dimension hierarchy. In this approach
multidimensional cube class is organized into class-hierarchy, which consists of three layers and each layer has an independent function. This
approach provides advantages from the several positive aspects of object-oriented modelling, such as security, reusable software, etc.
Multidimensional database and OLAP scenarios are becoming very popular these days. OLAP systems impose different requirements than Online
Transactional Processing (OLTP) systems, and therefore, different data models and implementation methods are required for each type of
system. There have been several different multidimensional data models proposed recently. However, there are certain key issues in
multidimensional modelling, such as derived measures, derived dimension attributes and the additively on fact attributes along dimensions,
which are not considered by these proposals.
Â
Â
Keywords: OLAP, Multidimensional Data, Dimensions, Facts, Data Cube, OOMD
Downloads
Article Details
COPYRIGHT
Submission of a manuscript implies: that the work described has not been published before, that it is not under consideration for publication elsewhere; that if and when the manuscript is accepted for publication, the authors agree to automatic transfer of the copyright to the publisher.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work
- The journal allows the author(s) to retain publishing rights without restrictions.
- The journal allows the author(s) to hold the copyright without restrictions.