Object relational implementation of Graph based conceptual level Multidimensional Data Model

Data Warehouse (DW) design demands a methodical support for the designer of DW to specify the execution system efficiently from its conceptual level design. This paper proposes a systematic approach of object relational implementation for Graph Object Oriented Multidimensional Data Model (GOOMD model). The approach is governed by some set of conversion rules to specify the GOOMD model construct in SQL 2003 compatible Object Relational 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.