A Tool for Data Warehouse Multidimensional Schema Design using Ontology
Muthuveerappan Thenmozhi, K. Vivekanandan · 2013
The data warehouse has become a necessary component for an effective analysis of large businesses. It is widely accepted that the data warehouse must be structured according to the multidimensional model to facilitate OLAP analysis. The two driving force for the design of a multidimensional model are data source and business requirements. In recent years in addition to operational databases, web data has become an important source for data warehouse. The web data may be semi-structured or unstructured and exhibit several heterogeneity issues. Hence the design of multidimensional model has become a tedious task. The use of semantic web technologies such as ontology helps to represent such web data into coherent information which can be incorporated in a data Warehouse. Ontology also helps to represent the business requirements in a formal way, which need to be used during the design. In this paper we present an ontology driven tool which helps to automatically derive the conceptual model and logical model for the data warehouse from data source and business requirements. We make use of ontology and its reasoning capabilities at various stages of our tool to facilitate the design task.