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 theconceptual level design of data warehouses (DW). Besides offering a novel graph based semantic formultidimensional data representation, the proposed GOOMD model renders a unified realization ofdifferent logical structures of DW like star, snowflake, constellation, etc. The proposed simple butpowerful algebra for GOOMD provides an efficient operational model for Online Analytical Processing (OLAP) to realize different OLAP operations like roll-up, drill-down, slicing, dicing, drill-across anddrill-through. The proposed GOOMD model also supports a formal representation of advanced conceptslike parallel hierarchies, many-to-many associations, additivity constraints etc