METHOD AND SYSTEM FOR MAPPING MULTI-DIMENSIONAL MODEL TO DATA WAREHOUSE SCHEMA

摘要

A system maps a multidimensional model to data warehouse schema. The system includes a multidimensional model editor for defining a multidimensional model based on a conceptual model; a mapping reasoner for generating more simple mappings from basic mappings by reasoning on the conceptual model so as to provide mappings for concerning elements in an ontology path in the multidimensional model; a data warehouse schema analyzer for generating a data structure capable of indicating information of the data warehouse schema by making an analysis on the information of the data warehouse schema; and a mapping composition engine for generating result mappings according to mappings for the concerning elements of the ontology path in the multidimensional model and by searching in the data structure paths corresponding to the concerning elements of the ontology path in the multidimensional model. A method and computer program product are also disclosed.