Semantic integration of heterogeneous classical data sources in ontological data warehouse
Oussama El Hajjamy, Larbi Alaoui, Mohamed Bahaj · 2018
The development of semantic web technologies and the expansion of the amount of data managed within companies databases lead to an enormous quantity of heterogeneous, distributed and autonomous data sources. However, this growth of information will give rise to real obstacles if we cannot maintain the pace with these changes and meet the needs of users. To succeed, it is necessary to find a solution for integrating data from traditional information systems into richer systems. In this perspective, Ontologies are a key component in solving the problem of semantic heterogeneity, thus enabling semantic interoperability between different web applications and services. In this paper, we provide and develop a semi-automatic approach for designing an ontological data warehouse from various sources. Our approach is to convert the different classical data sources (UML, XML, RDB) to local ontologies (OWL2), then merge these ontologies into a global ontological model based on syntactic, structural and semantic similarity measurement techniques to identify similar concepts and avoid their redundancy in the merge result. Our study is proven by a developed prototype that demonstrates the efficiency and power of our strategy and validates the theoretical concept.