Ontology-based integration for relational databases

In this paper, we show that representation and reasoning techniques used in traditional knowledge engineering and the emerging Semantic Web can play an important role for heterogeneous database integration. Our OntoGrate architecture combines ontology-based schema representation, first order logic inference, and some SQL wrappers to integrate two sample relational databases. We define inferential data integration as the theoretical framework for our approach. The performance evaluation for query answering shows that OntoGrate reformulates conjunctive queries and retrieves over 100,000 answers from a target database in under 30 seconds. In addition to query answering, the system translates 40,000 database facts from source to target in under 30 seconds. Categories and Subject Descriptors H.2.5 [Database Management]: Heterogeneous Databases; H.3.5 [Information Storage and Retrieval]: Online Information Services—data sharing; I.2.3 [Artificial Intelligence]: Deduction and Theorem Pr...

• Type: Conference
• Year: 2006
• Where: SAC
• Authors: Dejing Dou, Paea LePendu
• Keywords: Applied Computing, Heterogeneous Database Integration, Heterogeneous Databases, Query Answering, SAC 2006