Schema matching using interattribute dependencies

Jaewoo Kang, Jeffrey F. Naughton

    Research output: Contribution to journalArticlepeer-review

    24 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

    Bibliographical note

    Funding Information:
    Correspondence should be addressed to Jaewoo Kang. The authors would like to thank Jin-Yi Cai for helpful discussion. This paper is a substantially extended version of the authors’ previous conference paper in [36]. This research was supported by US National Science Foundation Grants CSA-9623632, ITR 0086002, and in part by Korea University Grant, Microsoft Research Internet Services Grant, and the Second Brain Korea 21 Project Grant.

    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