Intelligent data integration from heterogeneous relational databases containing incomplete and uncertain information

Article type: Research Article

Authors: Aggoune, Aicha

Affiliations: Department of Computer Science, LabSTIC Laboratory, University of 8th May 1945, Guelma, Algeria | E-mail: aggoune.aicha@univ-guelma.dz

Correspondence: [*] Corresponding author: Department of Computer Science, LabSTIC Laboratory, University of 8th May 1945, Guelma, Algeria. %****␣ida-26-ida205535_temp.tex␣Line␣50␣**** E-mail: aggoune.aicha@univ-guelma.dz.

Abstract: The integration of incomplete and uncertain information has emerged as a crucial issue in many application domains, including data warehousing, data mining, data analysis, and artificial intelligence. This paper proposes a novel approach of mediation-based integration for integrating these types of information from heterogeneous relational databases. We present in detail the different processes in the layered architecture of the proposed flexible mediator system. The integration process of our mediator is based on the use of fuzzy logic and semantic similarity measures for more effective integration of incomplete and uncertain information. We also define fuzzy views over the mediator’s global fuzzy schema to express incomplete and uncertain databases and specify the mappings between this global schema and these sources. Moreover, our approach provides intelligent data integration, enabling efficient generation of cooperative answers from similar ones, retrieved by queried flexible wrappers. These answers contain information that is more detailed and complete than the information contained in the initial answers. A thorough experiment verifies our approach improves the performance of data integration under various configurations.

Keywords: Cooperative answers, intelligent data integration, mediator system, incomplete and uncertain information, fuzzy logic

DOI: 10.3233/IDA-205535

Journal: Intelligent Data Analysis, vol. 26, no. 1, pp. 75-99, 2022