SNIP: An Adaptation of Sorted Neighborhood Methods for Deduplicating Pedigree Data

Pedigree data contain family history information that is used to analyze hereditary diseases. These clinical data sets may contain duplicate records due to the same family visiting a clinic multiple times or a clinician entering multiple versions of the family for testing purposes. Inferences drawn from the data or using them for training or validation without removing the duplicates could lead to invalid conclusions, and hence identifying the duplicates is essential. Since family structures can be complex, existing deduplication algorithms cannot be applied directly. We first motivate the importance of deduplication by examining the impact of pedigree duplicates on the training and validation of a familial risk prediction model. We then introduce an unsupervised algorithm, which we call SNIP (Sorted NeIghborhood for Pedigrees), that builds on the sorted neighborhood method to efficiently find and classify pairwise comparisons by leveraging the inherent hierarchical nature of the pedigrees. We conduct a simulation study to assess the performance of the algorithm and find parameter configurations where the algorithm is able to accurately detect the duplicates. We then apply the method to data from the Risk Service, which includes over 300,000 pedigrees at high risk of hereditary cancers, and uncover large clusters of potential duplicate families. After removing 104,520 pedigrees (33% of original data), the resulting Risk Service dataset can now be used for future analysis, training, and validation. The algorithm is available as an R package snipR available at https://github.com/bayesmendel/snipR.

[1]  Felix Naumann,et al.  Adaptive Windows for Duplicate Detection , 2012, 2012 IEEE 28th International Conference on Data Engineering.

[2]  Wolfgang Nejdl,et al.  Meta-Blocking: Taking Entity Resolutionto the Next Level , 2014, IEEE Transactions on Knowledge and Data Engineering.

[3]  D. Rubin,et al.  A method for calibrating false-match rates in record linkage , 1995 .

[4]  Marcel Ramos,et al.  The Doppelgänger Effect: Hidden Duplicates in Databases of Transcriptome Profiles. , 2016, Journal of the National Cancer Institute.

[5]  Pável Calado,et al.  An Overview of XML Duplicate Detection Algorithms , 2010, Soft Computing in XML Data Management.

[6]  Gábor Csárdi,et al.  The igraph software package for complex network research , 2006 .

[7]  Giovanni Parmigiani,et al.  Providing access to risk prediction tools via the HL7 XML-formatted risk web service , 2013, Breast Cancer Research and Treatment.

[8]  J. Blangero,et al.  Collection of Pedigree Data for Genetic Analysis in Isolate Populations , 2006, Human biology.

[9]  C. Lee Giles,et al.  Adaptive sorted neighborhood methods for efficient record linkage , 2007, JCDL '07.

[10]  Raymond J. Mooney,et al.  Adaptive Blocking: Learning to Scale Up Record Linkage , 2006, Sixth International Conference on Data Mining (ICDM'06).

[11]  Ahmed K. Elmagarmid,et al.  Duplicate Record Detection: A Survey , 2007, IEEE Transactions on Knowledge and Data Engineering.

[12]  S. Kumaresan,et al.  A survey on duplicate record detection in real world data , 2016, 2016 3rd International Conference on Advanced Computing and Communication Systems (ICACCS).

[13]  Salvatore J. Stolfo,et al.  The merge/purge problem for large databases , 1995, SIGMOD '95.

[14]  Christopher D. Manning,et al.  Introduction to Information Retrieval , 2010, J. Assoc. Inf. Sci. Technol..

[15]  Erhard Rahm,et al.  Frameworks for entity matching: A comparison , 2010, Data Knowl. Eng..

[16]  Stephen W Duffy,et al.  A breast cancer prediction model incorporating familial and personal risk factors , 2004, Hereditary Cancer in Clinical Practice.

[17]  Andreas Thor,et al.  Multi-pass sorted neighborhood blocking with MapReduce , 2012, Computer Science - Research and Development.

[18]  Christophe Giraud-Carrier,et al.  Using Structured Neural Networks for Record Linkage , 2006 .

[19]  Karl W Broman,et al.  BayesMendel: an R Environment for Mendelian Risk Prediction , 2004, Statistical applications in genetics and molecular biology.

[20]  C. Lee Giles,et al.  Efficient Name Disambiguation for Large-Scale Databases , 2006, PKDD.

[21]  MAL 4 : 6-Using Data Mining for Record Linkage , 2005 .

[22]  M. Gail,et al.  Colorectal cancer risk prediction tool for white men and women without known susceptibility. , 2009, Journal of clinical oncology : official journal of the American Society of Clinical Oncology.

[23]  N. Obuchowski,et al.  Assessing the Performance of Prediction Models: A Framework for Traditional and Novel Measures , 2010, Epidemiology.

[24]  D. Rubin,et al.  Iterative Automated Record Linkage Using Mixture Models , 2001 .

[25]  Hector Garcia-Molina,et al.  Evaluating entity resolution results , 2010, Proc. VLDB Endow..

[26]  Christophe G. Giraud-Carrier,et al.  Metric-Based Data Mining Model for Genealogical Record Linkage , 2007, 2007 IEEE International Conference on Information Reuse and Integration.