Design Graph Multi-Dimensional Data Model of a Data Warehouse and conversion of its equivalent Object - Oriented Schema

摘要

This paper proposes Graph Multi -Dimensional Data Model (GMDDM) of a Data Warehouse and conversion of its equivalent Object - Oriented Schema. Data warehouse representation is complex itself. Thus the pictorial representation of the Data Warehouse should increase the understandability to the warehouse designer. The warehouse representation through graph G [V, E] may be an effective approach that reduces the inherent complexity of any multi - dimensional data model. But there is no need to develop this model from scratch, rather, in contrast, it may be considered as a software layer on the top of any standard data model representation. Here the scope of the project work is to form a software tool that is able to convert the Graph based Data Warehouse representation to its equivalent Object - Oriented representation. Hence the tool helps the warehouse designer to interact with the graph without knowing anything about Object - Oriented representation and thus ease the entire complex design mechanism. The project work contains a detailed Graph based representation of an Online Shopping House and its equivalent Object - Oriented Schema. It also provides the generic rules for conversion of any Graph based representation to Object - Oriented Schema.