Abstract
Record Linkage (RL) aims at identifying pairs of records coming from different sources and representing the same real-world entity. Probabilistic RL methods assume that the pairwise distances computed in the record-comparison process obey a well defined statistical model, and exploit the statistical inference machinery to draw conclusions on the unknown Match/Unmatch status of each pair. Once model parameters have been estimated, classical Decision Theory results (e.g. the MAP rule) can generally be used to obtain a probabilistic clustering of the pairs into Matches and Unmatches. Constrained RL tasks (arising whenever one knows in advance that either or both the data sets to be linked do not contain duplicates) represent a relevant exception. In this paper we propose an Evolutionary Algorithm to find optimal decision rules according to arbitrary objectives (e.g. Maximum complete-Likelihood) while fulfilling 1:1, 1:N and N:1 matching constraints. We also present some experiments on real-world constrained RL instances, showing the accuracy and efficiency of our approach.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsNotes
- 1.
The expression “N:M” means that each record of either data set can in principle match many records of the other, and viceversa.
- 2.
For duplicates we mean records that (i) correspond to the same real-world entity and(ii) belong to the same data set.
- 3.
We performed 10 runs of our Evolutionary Algorithm on each instance, owing to its stochastic nature. Anyway, we found a negligible variability in the results.
- 4.
The Precision, Recall and F-measure increase (when present) turned out to be of 0.1% at most.
References
Christen, P., & Goiser, K. (2007). Quality and complexity measures for data linkage and deduplication. Quality Measures in Data Mining, Springer Studies in Computational Intelligence, 2007, 43.
Dempster, A., Laird, N., & Rubin, D. (1977). Maximum-likelihood from incomplete data via the EM algorithm. JRSS, Series B, 39, 1.
Duda, R., Hart, P., & Stork D. (2000). Pattern classification. New York: Wiley.
Jaro, M. (1989). Advances in record-linkage methodology as applied to matching the 1985 census of tampa, Florida. JASA, 84, 406, 1989.
Kopcke, H., Thor, A., & Rahm, E. (2010). Evaluation of entity resolution approaches on real-world match problems. PVLDB, 3, 1, 2010.
McLachlan, G., & Peel, D. (2000). Finite mixture models. New York: Wiley.
Michalewicz, Z. (1996). Genetic algorithms + data structures = evolution programs. Berlin: Springer.
Winkler, W. (1994). Advanced methods for record linkage. In Proc. of Survey Research Methods, ASA, 1994.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer International Publishing Switzerland
About this paper
Cite this paper
Zardetto, D., Scannapieco, M. (2013). Optimal Decision Rules for Constrained Record Linkage: An Evolutionary Approach. In: Giudici, P., Ingrassia, S., Vichi, M. (eds) Statistical Models for Data Analysis. Studies in Classification, Data Analysis, and Knowledge Organization. Springer, Heidelberg. https://doi.org/10.1007/978-3-319-00032-9_44
Download citation
DOI: https://doi.org/10.1007/978-3-319-00032-9_44
Published:
Publisher Name: Springer, Heidelberg
Print ISBN: 978-3-319-00031-2
Online ISBN: 978-3-319-00032-9
eBook Packages: Mathematics and StatisticsMathematics and Statistics (R0)