Automatic direct and indirect schema mapping: experiences and lessons learned

  • Authors:
  • David W. Embley;Li Xu;Yihong Ding

  • Affiliations:
  • Brigham Young University;University of Arizona South;Brigham Young University

  • Venue:
  • ACM SIGMOD Record
  • Year:
  • 2004

Quantified Score

Hi-index 0.00

Visualization

Abstract

Schema mapping produces a semantic correspondence between two schemas. Automating schema mapping is challenging. The existence of 1:n (or n:1) and n:m mapping cardinalities makes the problem even harder. Recently, we have studied automated schema mapping techniques (using data frames and domain ontology snippets) that not only address the traditional 1:1 mapping problem, but also the harder 1:n and n:m mapping problems. Experimental results show that the approach can achieve excellent precision and recall. In this paper, we share our experiences and lessons we have learned during our schema mapping studies.