期刊名称:International Journal of Computer Information Systems and Industrial Management Applications
印刷版ISSN:2150-7988
电子版ISSN:2150-7988
出版年度:2011
卷号:3
页码:127-136
出版社:Machine Intelligence Research Labs (MIR Labs)
摘要: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.