skip to main content
10.1145/1593105.1593176acmotherconferencesArticle/Chapter ViewAbstractPublication Pagesacm-seConference Proceedingsconference-collections
research-article

An instance-based approach for domain-independent schema matching

Published: 28 March 2008 Publication History

Abstract

The process of schema matching lies at the heart of database applications related to data integration. Many instance-based solutions to the schema matching problem have been proposed. These approaches focus on analyzing the values of attributes especially within the application domain. The approach presented in this paper is a two-step domain-independent schema matching technique. The technique first measures shared information between pair-wise attributes using the concept of mutual information. Next, a graph representation with weighted links is constructed for each input schema. At this stage, schema matching switches to a weighted graph matching problem. At this stage, a graduated assignment algorithm is applied to find the correspondence of vertices between graphs. We perform experiments using two real-world data sets in different application domains to roughly evaluate the performance of this schema matching technique in terms of precision, recall and running time.

References

[1]
S. Gold and A. Rangarajan. 1996. A graduated assignment algorithm for graph matching. IEEE Trans. Pattern Analysis and Machine Intelligence, vol. 18, no. 4, pp. 377--388, Apr. 1996.
[2]
http://www.stat.ucla.edu
[3]
http://lib.stat.cmu.edu/datasets
[4]
Rahm, E. and Bernstein, P. 2001. A survey of approaches to automatic schema matching. The VLDB Journal 10, 4.
[5]
Alexander Bilke and Felix Naumann. 2005. Schema Matching Using Duplicates. 21st International Conference on Data Engineering (ICDE'05) pp. 69--80
[6]
Cecil Chua Eng Huang, Roger H. L. Chiang and Ee-Peng Lim. 2003. Instance-based attribute identification in database integration. VLDB J. 12(3): 228--243 (2003)
[7]
Kang, J. and Naughton, J. 2003. On Schema Matching with Opaque Column Names and Data Values. Proceedings of the 2003 ACM SIGMOD international conference on Management of data, pp. 205--216.
[8]
Doan, A., P. Domingos, and A. Halevy. 2001. Reconciling Schemas of Disparate Data Sources: A Machine-Learning Approach. SIGMOD 2001, 509--520.
[9]
W. Li and C. Clifton. 2000. SEMINT: a tool for identifying attributes correspondences in heterogeneous databases using neural networks. Data & Knowledge Engineering, 33(1), 2000, 49--84.
[10]
Wang, J., Wen, J.-R., Lochovsky, F., and Ma, W. 2004. Instance-based schema matching for web databases by domain-specific query probing. In Proceedings of the VLDB 2004 Conference.
[11]
http://en.wikipedia.org/wiki/Mutual_information
[12]
Jayant Madhavan, Philip A. Bernstein, and Erhard Rahm. 2001. Generic Schema Matching with Cupid. In Proceedings of the 27th VLDB Conference, Roma, Italy, 2001.

Cited By

View all

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Other conferences
ACMSE '08: Proceedings of the 46th annual ACM Southeast Conference
March 2008
548 pages
ISBN:9781605581057
DOI:10.1145/1593105
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 28 March 2008

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. graduated assignment algorithm
  2. instance-based
  3. mutual information
  4. schema matching

Qualifiers

  • Research-article

Conference

ACM SE08
ACM SE08: ACM Southeast Regional Conference
March 28 - 29, 2008
Alabama, Auburn

Acceptance Rates

Overall Acceptance Rate 502 of 1,023 submissions, 49%

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)2
  • Downloads (Last 6 weeks)0
Reflects downloads up to 31 Jan 2025

Other Metrics

Citations

Cited By

View all

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media