Conceptual Level Design of Object Oriented Data Warehouse: Graph Semantic Based Model

This paper proposes a Graph semantic based Object Oriented Multidimensional Data Model (GOOMD). The model defines a set of graph based formal constructs that are used to specify the conceptual level design of Data Warehouses (DW). Besides offering a novel graph based semantic for multidimensional data representation, the proposed GOOMD model renders a unified realization of different logical structures of DW like star, snowflake, constellation, etc. The proposed simple but powerful algebra for GOOMD provides an efficient operational model for On-Line Analytical Processing (OLAP) to realize different OLAP operations like roll-up, drill-down, slicing, dicing, drill-across and drill-through.