Abstract
An important task in database integration is to resolve data conflicts, on both schema-level and semantic-level. Especially difficult the latter is. Some existing ontology-based approaches have been criticized for their lack of domain generality and semantic richness. With the aim to overcome these limitations, this paper introduces a systematic approach for detecting and resolving various semantic conflicts in heterogeneous databases, which includes two important parts: a semantic conflict representation model based on our classification framework of semantic conflicts, and a methodology for detecting and resolving semantic conflicts based on this model. The system has been developed, experimental evaluations on which indicate that this approach can resolve much of the semantic conflicts effectively, and keep independent of domains and integration patterns.
Similar content being viewed by others
References
Kashyap V, Sheth A P. Semantic and schematic similarities between database objects: A context-based approach. The VLDB Journal, 1996, 5(4): 276–304.
Alon Y Halevy, Naveen Ashishy, Dina Bittonz. Enterprise information integration: Successes, challenges and controversies. In Proc. SIGMOD, 2005, pp. 778–787.
Gruber T. A translation approach to portable ontology specifications. Knowledge Acquisition, 1993, 5: 199–220.
Michael Uschold, Michael Gruninger. Ontologies and semantics for seamless connectivity. SIGMOD Record, 2004, 33(4): 58–64.
Dave Beckett, Brain Mcbride. RDF/XML syntax specification (revised). http://www.w3.org/TR/rdf-syntax-gra-mmar/, 2004.
Michael K Smith, Chris Welty, Deborah L McGuinness. OWL web ontology language guide. http://www. w3.org/TR/owl-guide/, 2004.
The Gene Ontology. http://www.geneontology.org/, 2005.
Unified Medical Language System. http://www.nlm.nih.gov/research/umls/, 2006.
Fowler J, Nodine M, Perry B, Bargmeyer B. Agent-based semantic interoperability in infosleuth. SIGMOD Record, 1999, 28(1): 60–67.
Mena E, Illarramendi A, Kashyap V, Sheth A P. OBSERVER: An approach for query processing in global information systems based on interoperability across pre-existing ontologies. Distributed and Parallel Databases, 2000, 8(2): 223–271.
Sudha Ram, Jinsoo Park. Semantic conflict resolution ontology (SCROL): An ontology for detecting and resolving data and schema level semantic conflicts. IEEE Trans. Knowledge and Data Engineering, 2004, 16(2): 189–202.
Conflict Resolution Environment for Autonomous Mediation. http://info-sharing.com/index.html.
Ramon Lawrence. Automatic conflict resolution to integrate relational schema [Dissertation]. Univ. Manitoba, 2001.
Cheng Hian Goh. Representing and reasoning about semantic conflicts in heterogeneous information systems [Dissertation]. Massachusetts Institute of Technology, 1997.
Won Kim, Jungyun Seo, *UniSQL, Inc. Classifying schematic and data heterogeneity in multidatabase systems. IEEE Computer, 1991, 24(12): 12–18.
Sheth A P, Kashyap V. So far (schematically), yet so near(semantically). In Proc. the IFIP WG2.6 Database Semantics Conference on Interoperable Database Systems, Victoria, Australia, Nov. 16–20, 1992, pp. 283–312.
Tim Berners-Lee. Relational databases and the semantic web (in design issues). http://www.w3.org/DesignIssues/RDB-RDF.html.
Wiederhold. Mediators in the architecture of future information systems. IEEE Computers, 1992, 25(3): 38–49.
Protege ontology editor and knowledge acquisition system. http://protege.stanford.edu.
Author information
Authors and Affiliations
Corresponding author
Additional information
This work is supported by the National natural Science Foundation of China under Grant No. 60573126, the National High-Tech Research and Development 863 Program of China under Grant No. 2004AA112010, the National Grand Fundamental Research 973 Program of China under Grant No. 2002CB312005.
Electronic supplementary material
Rights and permissions
About this article
Cite this article
Liu, Q., Huang, T., Liu, SH. et al. An Ontology-Based Approach for Semantic Conflict Resolution in Database Integration. J Comput Sci Technol 22, 218–227 (2007). https://doi.org/10.1007/s11390-007-9028-4
Received:
Revised:
Published:
Issue Date:
DOI: https://doi.org/10.1007/s11390-007-9028-4