Automatically Generating OLAP Schemata from Conceptual Graphical Models

Generating tool specific schemata and configuration information for OLAP database tools from conceptual graphical models is an important prerequisite for a comprehensive tool support for computer aided data warehouse engineering (CAWE). This paper describes the design and implementation of such a generation component in the context of our BabelFish data warehouse design tool environment. It identifies the principal issues that are involved in the design and implementation of such a component and discusses possible solutions. The paper lists typical mismatches between the data model of commercial OLAP tools and conceptual graphical modeling notations, and proposes methods to overcome these expressive differences during the generation process. Further topics are the use of graph grammars for specifying and parsing graphical MD schema descriptions and the integration of the generation process into a metadata centered modeling tool environment. Categories and Subject Descriptors H.2.1 [Da...

• Type: Conference
• Year: 2000
• Where: DOLAP
• Authors: Karl Hahn, Carsten Sapia, Markus Blaschka
• Keywords: Conceptual Graphical Models, Data Warehouse, DOLAP 2000, Information Management, Tool