Implementation of Graph Semantic Based Multidimensional Data Model: An Object Relational Approach

Abstract

Data Warehouse (DW) design demands a methodical support for the designer of DW to specify the execution system efficiently from its conceptual level design. In [19], we have proposed a generic model for Data warehouse at conceptual level named Graph Object Oriented Multidimensional Data Model (GOOMD). This paper proposes a systematic approach for object relational implementation of the GOOMD model. The approach is governed by some set of conversion rules to specify the GOOMD model construct in SQL 2003 compatible Object Relational (OR) Schemas. Moreover, the set of OLAP operators defined in GOOMD model have been mapped using OR SQL which will operate on the OR schemas. The concept of GOOMD model also has been implemented in Generic Modeling Environment (GME) and an interpreter has been developed to automate the proposed approach.