Implementation of Graph Semantic Based Multidimensional Data Model: An Object Relational Approach
Data Warehouse (DW) design demands a methodical support for the designer of DW to specify the execution system efficiently from its conceptual level design. The authors 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.