An Ontology based Hybrid Approach to Derive Multidimensional Schema for Data warehouse
Due to the diversity of data source data integration has become a challenging task. Data warehouse system plays a vital role to integrate the data for making important business decisions. Data within the data warehouse is arranged as multidimensional schema. In past many works exist to carry out the design of the multidimensional schema for data warehouse from either requirements and/or data sources. These approaches are either manual or automated which work with only relational sources. But as today the data warehouse system needs to deal with semi-structured and unstructured sources, the design task becomes much tedious. Recently, ontology has been very useful for different data integration projects. The use of ontology could solve the syntactic and semantic conflicts that arise from heterogeneous sources.