The Interaction Between Schema Matching and Record Matching in Data Integration

Binbin Gu, Zhixu Li, Xiangliang Zhang, An Liu, Guanfeng Liu, Kai Zheng, Lei Zhao, Xiaofang Zhou

Research output: Contribution to journalArticlepeer-review

21 Scopus citations


Schema Matching (SM) and Record Matching (RM) are two necessary steps in integrating multiple relational tables of different schemas, where SM unifies the schemas and RM detects records referring to the same real-world entity. The two processes have been thoroughly studied separately, but few attention has been paid to the interaction of SM and RM. In this work, we find that, even alternating them in a simple manner, SM and RM can benefit from each other to reach a better integration performance (i.e., in terms of precision and recall). Therefore, combining SM and RM is a promising solution for improving data integration. To this end, we define novel matching rules for SM and RM, respectively, that is, every SM decision is made based on intermediate RM results, and vice versa, such that SM and RM can be performed alternately. The quality of integration is guaranteed by a Matching Likelihood Estimation model and the control of semantic drift, which prevent the effect of mismatch magnification. To reduce the computational cost, we design an index structure based on q-grams and a greedy search algorithm that can reduce around 90 percent overhead of the interaction. Extensive experiments on three data collections show that the combination and interaction between SM and RM significantly outperforms previous works that conduct SM and RM separately.
Original languageEnglish (US)
Pages (from-to)186-199
Number of pages14
JournalIEEE Transactions on Knowledge and Data Engineering
Issue number1
StatePublished - Sep 20 2016

Bibliographical note

KAUST Repository Item: Exported on 2020-10-01
Acknowledgements: This research is partially supported by the Natural Science Foundation of China (Grant Nos. 61303019, 61402313, 61402312, 61472263, 61572336, 61572335, 61532018, 61502324), the King Abdullah University of Science and Technology, the Australian Research Council (Grants No. DP120102829), the Natural Science Foundation of Jiangsu (Grant No. BK20151223), the Postdoctoral scientific research funding of Jiangsu Province (No. 1501090B), and the National Postdoc- toral Funding (Nos. 2015M581859, 2016T90493).


Dive into the research topics of 'The Interaction Between Schema Matching and Record Matching in Data Integration'. Together they form a unique fingerprint.

Cite this