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. 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.

[1]  Michael E. Senko,et al.  Information Systems Records, Relations, Sets, Entities, and Things , 1975, Inf. Syst..

[2]  Hideko S. Kunii.  Graph data model and its data language , 1990 .

[3]  Matteo Golfarelli,et al.  The Dimensional Fact Model: A Conceptual Model for Data Warehouses , 1998, Int. J. Cooperative Inf. Syst..

[4]  Nectaria Tryfona,et al.  starER: a conceptual model for data warehouse design , 1999, DOLAP '99.

[5]  Anindya Datta,et al.  The cube data model: a conceptual model and algebra for on-line analytical processing in data warehouses , 1999, Decis. Support Syst..

[6]  Ulrike Sattler,et al.  A Data Warehouse Conceptual Data Model for Multidimensional Aggregation , 1999, DMDW.

[7]  Manuel Palomar,et al.  The GOLD definition language (GDL): an object oriented formal specification language for multidimensional databases , 2000, SAC '00.

[8]  A Min Tjoa,et al.  Conceptual multidimensional data model based on object-oriented metacube , 2001, SAC.

[9]  Timos K. Sellis,et al.  MAC: Conceptual data modeling for OLAP , 2001, DMDW.

[10]  Gabor Karsai,et al.  Composing Domain-Specific Design Environments , 2001, Computer.

[11]  Research in data warehouse modeling and design: dead or alive? , 2006, DOLAP '06.

[12]  Swapan Bhattacharya,et al.  GDM: A New Graph Based Data Model Using Functional Abstractionx , 2006, Journal of Computer Science and Technology.

[13]  L. Zepeda,et al.  A model driven approach for data warehouse conceptual design , 2006, 2006 7th International Baltic Conference on Databases and Information Systems.

[14]  Il-Yeol Song,et al.  A UML profile for multidimensional modeling in data warehouses , 2006, Data Knowl. Eng..

[15]  Isabelle Comyn-Wattiau,et al.  A UML-based data warehouse design method , 2006, Decis. Support Syst..

[16]  Arie Shoshani,et al.  Object-extended OLAP querying , 2009, Data Knowl. Eng..

[17]  Swapan Bhattacharya,et al.  Conceptual Level Design of Object Oriented Data Warehouse: Graph Semantic Based Model , 2009 .

[18]  Swapan Bhattacharya,et al.  Object relational implementation of Graph based conceptual level Multidimensional Data Model , 2010, 2010 International Conference on Computer Information Systems and Industrial Management Applications (CISIM).

[19]  Jose-Norberto Mazón,et al.  Extending OCL for OLAP querying on conceptual multidimensional models of data warehouses , 2010, Inf. Sci..