Schema matching using interattribute dependencies

Jaewoo Kang, Jeffrey F. Naughton

Research output: Contribution to journalArticle

20 Citations (Scopus)

Abstract

Schema matching is one of the key challenges in information integration. It is a labor-intensive and time-consuming process. To alleviate the problem, many automated solutions have been proposed. Most of the existing solutions mainly rely upon textual similarity of the data to be matched. However, there exist instances of the schema-matching problem for which they do not even apply. Such problem instances typically arise when the column names in the schémas and the data in the columns are opaque or very difficult to interpret. In our previous work, we proposed a two-step technique to address this problem. In the first step, we measure the dependencies between attributes within tables using an information-theoretic measure and construct a dependency graph for each table capturing the dependencies among attributes. In the second step, we find matching node pairs across the dependency graphs by running a graph-matching algorithm. In our previous work, we experimentally validated the accuracy of the approach. One remaining challenge is the computational complexity of the graph-matching problem in the second step. The problem instance we are facing is the weighted graph-matching problem to which no efficient solution has yet been found. In this paper, we extend the previous work by improving the second phase of the algorithm incorporating efficient approximation algorithms into the framework.

Original languageEnglish
Article number4527243
Pages (from-to)1393-1407
Number of pages15
JournalIEEE Transactions on Knowledge and Data Engineering
Volume20
Issue number10
DOIs
Publication statusPublished - 2008 Oct 1

Keywords

  • Attribute dependency
  • Graph matching
  • Schema matching

ASJC Scopus subject areas

  • Information Systems
  • Computer Science Applications
  • Computational Theory and Mathematics

Fingerprint Dive into the research topics of 'Schema matching using interattribute dependencies'. Together they form a unique fingerprint.

  • Cite this