- Technical advance
- Open Access
A practical approach for incorporating dependence among fields in probabilistic record linkage
BMC Medical Informatics and Decision Making volume 13, Article number: 97 (2013)
Methods for linking real-world healthcare data often use a latent class model, where the latent, or unknown, class is the true match status of candidate record-pairs. This commonly used model assumes that agreement patterns among multiple fields within a latent class are independent. When this assumption is violated, various approaches, including the most commonly proposed loglinear models, have been suggested to account for conditional dependence.
We present a step-by-step guide to identify important dependencies between fields through a correlation residual plot and demonstrate how they can be incorporated into loglinear models for record linkage. This method is applied to healthcare data from the patient registry for a large county health department.
Our method could be readily implemented using standard software (with code supplied) to produce an overall better model fit as measured by BIC and deviance. Finding the most parsimonious model is known to reduce bias in parameter estimates.
This novel approach identifies and accommodates conditional dependence in the context of record linkage. The conditional dependence model is recommended for routine use due to its flexibility for incorporating conditional dependence and easy implementation using existing software.
Health information exchanges (HIE’s), with highly heterogeneous data, are becoming increasingly important sources of integrated clinical data supporting many healthcare tasks and health-related research. HIE data are captured from different independent databases with different patient identifiers, and best practices for implementing and operating HIE’s are needed. Specifically with respect to data integration and patient matching, in its formal recommendations to the Director of the Office of the National Coordinator for Health Information Technology (HIT) in 2011, the HIT Policy Committee recognized the need to develop and disseminate best practices for patient matching  because best practices for matching data in HIE’s are lacking.
Many methodologies have been proposed to identify records in two or more databases that are related to the same entity. Deterministic approaches are based on ad-hoc rules, which classify a pair of records as matches if the two records satisfy certain conditions. Although straightforward to implement, deterministic approaches are often too conservative with unacceptably high false negative (missed-match) rates, especially when data are noisy . This may lead to suboptimal care since physicians lack the information necessary to make informed medical decisions.
Distance-based methods that can handle numerical or categorical fields, as described in , are another method to link records. These methods have been shown to perform similarly to probabilistic methods for both numeric  and categorical data  but require one to establish appropriate distance measures for each variable under consideration. They are not investigated further here as they are not commonly used in practice and have not yet been investigated thoroughly in the HIE setting although they may be of interest in future work .
Another alternative to deterministic linkage methods are probabilistic methods. A common probabilistic record linkage method was proposed by Fellegi and Sunter in 1969 . This model is a latent class model, where the latent, or unknown, class represents the true match status of the record pair. For this model, each field contained in both data sources is compared as a record pair and a binary variable is created which is a 1 if the two fields agree and 0 otherwise; thus a binary vector is created for each record pair. The Fellegi-Sunter (F-S) model assumes that the agreement patterns of the fields are independent conditional on the true match status.
This conditional independence assumption is often violated in real-world record linkage scenarios . When conditional independence does not hold, estimates of model parameters can be substantially biased . This bias can lead to inaccurate record linkage outcomes as described previously [2, 8]. Therefore, finding the most parsimonious model that accounts for the conditional dependence will provide the most accurate classification of record pairs.
Various methods have been proposed to address the lack of conditional independence in latent class models for record linkage. For example, Tromp et al. incorporated conditional dependence between two fields by combining them into one field with four nominal levels of agreement . This strategy can be cumbersome if conditional dependence exists between more than two fields since the number of nominal categories increases when combining agreement patterns for multiple fields. Schürle proposed an alternate approach to incorporating conditional dependence in the traditional F-S model framework by working directly with the joint distribution of the observed agreement pattern given the true match status. However, this model involves heavy parameterization that leads to significant overfitting of the model . For example, when seven fields are used for record matching, this model involves 255 parameters, while the data could estimate at most 127 parameters. Due to the extreme complexity of the model, the proper choice of starting values is critical for parameter estimation. This greatly limits the usefulness of the approach due to the computational effort required to examine multiple starting values.
Latent class models with conditional independence can be equivalently formulated using a loglinear framework [11, 12]. Using this formulation, the conditional independence assumption can be readily relaxed to account for conditional dependence among fields by including interactions among fields within the match class or the nonmatch class or both . Such loglinear approaches incorporating interactions within latent classes have been used in many applications, notably in diagnostic testing [14, 15].
Similarly, loglinear models have been applied to record linkage applications. Using survey data whose record pairs had known match status, Thibaudeau identified fields with conditional dependence using a loglinear model with selected interactions . Winkler estimated a loglinear model using three-way interactions, acknowledging that identifying the correct set of interactions is difficult when a large number of fields are involved . Loglinear models with certain interaction terms have also been applied in record linkage by Larsen and his colleagues [17, 18]. There has been no research on effectively identifying appropriate interactions in record linkage until the stepwise model building strategy for identifying interactions recently proposed by Zhu et al. . However, this approach can only identify models with all interactions of the same order.
Many previous record linkage studies focused largely on maximum likelihood (ML) estimation, where the parameter estimates of the loglinear model were obtained using an Expectation-Maximization (EM) algorithm. For situations such as the latent class model where incomplete data (unobserved classes) are involved, the EM algorithm is a powerful tool to estimate model parameters . However, as noted by Winkler (1995), the EM algorithm takes substantially longer to reach convergence when conditional dependence is incorporated in the loglinear model because the M-step does not have a closed-form solution . Alternatively, estimating the loglinear latent class model can be conveniently implemented using routines in existing software, such as SAS® PROC NLMIXED (Cary, NC), thus providing a pragmatic approach to incorporating conditional dependence more efficiently.
Even though loglinear models have been proposed by multiple authors for handling conditional dependence in HIE, implementation of such models requires customized programs and the process for choosing pairwise interactions in these models has not been specified. We therefore describe and evaluate a method for identifying conditional dependence among fields, which are subsequently incorporated as interactions in a loglinear model fitted using standard software. To illustrate the methodology, we use an application linking a client list of a county health department to itself for de-duplication. The step-by-step method described is supplemented by sample code which can be readily modified for linking any two data sets using standard statistical software.
We first describe a loglinear formulation of the extended F-S model with conditional dependence. Let M be the true match status of a pair of records (M = 1 for true match and M = 0 for true non-match). For each record pair with K fields, an agreement vector is observed
where yi = 1 if the i th field agrees and 0 otherwise. The match prevalence is defined as the proportion of vector patterns belonging to the true match record class and is π = P(M = 1). The parameters of the classical F-S model include
where the m-probabilities are the probability of field agreement given the record pair is a true match, and the u-probabilities are the probabilities of field agreement given the record is a true non-match.
To more effectively accommodate conditional independence, the traditional F-S model can be reparameterized using a loglinear formulation, where the mean number of record pairs with agreement pattern Y and match status M is given as follows:
With K fields, there are D = 2K possible different agreement patterns. Let f d represent the frequency count for the agreement pattern Y d (d = 1,2,…,D). Then the log-likelihood is given by
where the marginal probability of observing the agreement pattern Y d is
The match score for a specific agreement pattern Y d is defined as
The loglinear formulation has been shown to be equivalent to the F-S classical probabilistic formulation of the conditional independence latent class model  through the following relationships:
To incorporate conditional dependence in the loglinear model setting, we add the appropriate interaction terms to the model. For example, if there is dependence between fields j and l within each latent class, the model then includes two additional terms:
The above loglinear model with interaction terms is easy to fit in standard statistical software such as SAS (example code is provided in Additional file 1). The goodness of fit of a model is measured by both the deviance G2 and the Bayesian Information Criterion (BIC). We use deviance to compare nested models. A model with lower deviance provides a better fit to the data and hence will be preferred. For models that are not nested within each other, BIC is the most commonly used criterion for latent class modeling as it takes into account the sample size . The model with a lower BIC is preferred.
In what follows, we describe a series of steps to fit a loglinear model with appropriate interactions. Specifically, we follow a six-step procedure by identifying the pairwise dependencies between fields using the correlation residual plot proposed by Qu, Tan, and Kutner . We then incorporate the correlations into the model and re-examine the fit of the new model. We iterate between these steps as follows:
Fit a loglinear model with no interactions using the observed agreement vectors. This is simply the F-S model formulated as a loglinear model, which provides initial parameter estimates for the next model. Obtain deviance and BIC of this conditional independence model. See Additional files 1, 2 and 3 for SAS code with example.
Compute the observed pairwise correlation between fields j and l. The correlation between y j and y l is
where p j = P(y j = 1) , p l = P(y l = 1), and p jl = P(y j = 1,y l = 1). Using the observed data, the estimates for p j , p l , and p jl are given by:
Substitute the parameter estimates of λ’s from the fitted model in Step 1 into Equation (1) to obtain the expected number of record pairs m(Y d ,M d ) for each vector pattern Y d and match status M d. Calculate the expected marginal probability P(Y d ) using Equation (2) and the expected cell count for each vector pattern, where is the total number of record pairs. Expected pairwise correlations are then estimated using (4) (same formulas in Step 2) based on the expected counts rather than the observed counts .
Compute the correlation residual, which is equal to the difference between the observed correlation and the expected correlation for each pair of fields. Plot the residuals across the different pairs of fields. A correlation residual which is much different from zero would imply dependence for the corresponding pair of fields.
Incorporate the conditional dependence between the pair of fields identified in Step 4 as the interaction term in the loglinear model. Specifically, fit the following four models: interaction in the match class only, interaction in the nonmatch class only, interaction in both classes with different coefficients, and interaction in both classes with the same coefficients. Since the four models are not all nested, BIC is used to compare them and the model with the lowest BIC is chosen. Repeat Steps 3 through 5 to obtain the expected number of record pairs m(Y d ,M d ) by substituting the parameter estimates of λ’s of the chosen model into Equation (3) with appropriate interactions instead of Equation (1) until no large correlation residuals are apparent.
To classify individual pairs as match, non-match or uncertain matches, we use the final model parameter estimates to calculate the match score for each agreement pattern. Record pairs are then declared as matches or non-matches based on these match scores.
Approval to perform this study was obtained from the Indiana University Institutional Review Board: approval number 1010002784 (0909–68). De-identified data for the HIE example described in the next section is provided as Additional file 3.
Description of the HIE dataset
We applied the above steps to de-duplicate the client registry for the Marion County Health Department (MCHD). De-duplication is a class of record linkage where a data set is linked to itself to identify potential duplicate records. MCHD is a member of the Indiana Network for Patient Care, the nation’s largest and longest tenured HIE .
The MCHD client registry contains 779,466 patient records gathered from multiple public health service areas. Therefore this data is highly heterogeneous and the method of input may be any combination of standardized electronic entry, paper entry, or manual entry for a given field. Since the total number of all potential record pairs is extremely large (3 × 1011 potential pairs), the data were first blocked to minimize the search space for potential matches. The MCHD client registry was blocked on last name and first name, thus only record pairs agreeing on these two fields are contained in the analysis. This reduced the number of potential record pairs to 618,213. The remaining fields in this dataset include day, month, and year of birth, social security number, telephone number, zip code, and gender. Level of missing across the different fields varies from as low as 0% for day, month, and year of birth to as high as 95% for specific identifiers such as SSN. Missing values were coded as disagreements. We then applied the six-step process described above to all pairs from this block.
Application to HIE dataset
As described in the previous section, we first fit the conditional independence model (Step 1). With 7 fields, this model contains 15 parameters (Model 0). Parameter estimates are provided in Table 1. The overall match prevalence was estimated to be 3.7% under this model. The m-probabilities ranged from a low of .025 (SSN) to a high of 0.716 (month of birth), indicating that only 2.5% of the matched record pairs agreed on SSN while 71.6% agreed on month of birth. The estimated u-probabilities were small as expected, except for sex, which was estimated to be 0.661, indicating that 66.1% of non-matching record pairs agreed on sex. Also, the u-probability for SSN was nearly zero, indicating that very few non-matching record pairs agree on SSN. The deviance of this model was G2 = 8852.9. Assuming independence, the observed and expected pairwise correlations were calculated (Steps 2, 3) and the differences were displayed in the correlation residual plot (Step 4), as shown in Figure 1 (Panel A).
The seven fields in this particular dataset yield 21 pairwise correlations. The difference between the 21 observed and expected pairwise correlations from this model ranged from −0.027 to 0.155. The majority of the correlation residuals from the conditional independence model fluctuate between −0.03 and 0.05. However, the correlation residual between the fields telephone number and zip code is much larger than the others (almost 5-fold difference), indicating a violation of the conditional independence assumption for this pair of variables.
To accommodate the conditional dependence between telephone number and zip code, we followed Step 5 and compared the fit of four models, specifically, models with interaction in the match class only, interaction in the non-match class only, interaction in both classes with different coefficients, and interaction in both classes with equal coefficients. The model with interactions between telephone number and zip code in both classes with different coefficients yielded the lowest BIC and hence was selected (Model I).
The parameter estimates of the match prevalence and m- and u-probabilities for Model I are also shown in Table 1. Model I provided a better fit to the data compared to the conditional independence model, which is indicated by its much lower deviance = 2974.3. The estimated match prevalence was 3.5%, slightly lower than the estimate under the conditional independence model. The estimated u-probabilities were quite similar under both models. The difference was seen in the estimated m-probabilities, with an increase in the estimates corresponding to year, month, day of birth and SSN and a decrease in estimates corresponding to telephone, zip code and sex compared to the conditional independence model.
After calculating the expected correlations under Model I (repeat Step 3), Figure 1 (Panel B) shows the correlation residuals for pairs of fields (repeat Step 4). The correlation residual for telephone number and zip code is no longer present since this pairwise dependence has been accounted for by the model. The magnitude of all correlation residuals were under 0.05. Our experience suggests that an absolute value greater than 0.05 for the correlation residual is a reasonable approximate guideline for identifying conditional pairwise field dependence.
Although the correlation residual plot did not reveal substantial deviation of the conditional dependence between other pairs of fields, the correlation residual between SSN and telephone number (0.047) was more than twice of the magnitude of the remaining residuals. To examine whether it is appropriate to consider conditional dependence between this pair of fields, we repeated the Step 5 and compared the fit of four additional models. These four models again include models with interaction between SSN and telephone number in the match class only, interaction in the non-match class only, interaction in both classes with different coefficients, and interaction in both classes with equal coefficients. Based on the BIC, the model with interactions in both classes with different coefficients was selected (Model II).
Model II provided a better fit to the data compared to Model I with a smaller deviance and BIC, as well as smaller correlation residuals (Figure 1 Panel C). However, the improvement of the model fit was marginal. This is indicated by its deviance G2 = 2881.45, which was only slightly less than the deviance of Model I. As a result, parameter estimates under Model II did not differ much from the less complex Model I. As this is consistent with our general guideline regarding correlations above .05, we chose Model I as our final model.
Patient records were then classified as match or non-match based on the estimated match prevalence from these three models. The conditional independence model classified 1,152 record pairs as matches. Model I classified 1,082 matches and Model II results were almost identical to Model I with 1,081 matches. Thus not accounting for the conditional dependence yielded the largest number of declared duplicates; likely producing falsely-merged records resulting in lost patient records. Since it was not the purpose of our study to assess the accuracy of the different models, we did not manually ascertain the true match status of the records. We refer the readers to the literature [2, 7] for examples where accounting for the conditional dependence may improve the performance of the matching algorithm.
For many record linkage applications, the assumption of conditional independence for field agreement is often violated and ignoring the conditional dependence may lead to a suboptimal record matching accuracy. To optimize matching accuracy, it is important to examine whether conditional dependence exists and to incorporate such dependence in the model in a proper way.
In this paper, we presented a step-by-step procedure to identify and incorporate conditional dependence among fields using a loglinear latent class model. This stepwise method can be implemented using standard statistical software. In contrast to previous studies where loglinear latent class models were estimated using the iterative EM algorithm, we proposed estimating parameters using the readily available SAS procedure NLMIXED. Our step-by-step process was applied to the de-duplication of the MCHD client registry. The results indicated that conditional dependence can be readily identified using a graphical approach and the model with appropriate conditional dependence provided a much better model fit than the conditional independence model.
Although a stepwise variable-selection strategy was previously proposed by Zhu et al.  that accounted for the conditional dependence using interaction terms in loglinear models, the model building process proposed in this paper is different in several important ways. First, the quasi-Newton approach implemented in SAS NLMIXED procedure used in this paper is more efficient than the EM algorithm. Second, the final model obtained by the Zhu et al. approach must include all interactions of the same order, while our approach can identify specific two-way interactions. When a large number of fields are involved in record linkage, examining all interactions of the same order will introduce a large number of additional parameters. Model estimation can become quite complex with many local maxima. In addition, important conditional dependencies may not be detected using Zhu et al.’s approach when only a few interaction effects exist.
In addition to loglinear models, latent class models with conditional dependence have been extensively studied and widely used in other domains. For example, in diagnostic testing, latent class models with random effects [23, 25], probit latent class models , and finite mixture models  have all been used to evaluate the accuracy of diagnostic tests when no gold standard is available to evaluate the true disease status. Further investigation is needed to examine how the other conditional dependence models compare to loglinear models and to determine the impact of incorporating conditional dependence in record linkage.
A potential limitation of our approach is that it is more labor intensive because it requires understanding how to fit loglinear models. Additionally, the loglinear model framework requires parameterization that is not as readily understood by practitioners. The approach is iterative thus is also more computationally intensive. However, these challenges are mitigated by providing example code as additional files.
We have proposed a novel and practical approach to identify and incorporate conditional dependence in record linkage. Compared to the commonly used F-S model, the conditional dependence model provides substantially better fit to the data when conditional dependence exists. Given that some fields commonly used for linking health records often have correlated agreement patterns, we recommend the routine use of our proposed methods to avoid model misfit. Our approach can be easily followed using the step-by-step instructions and the sample code provided.
Health IT Policy Committee Transmittal Letter. Office of the National Coordinator for Health Information Technology.http://www.healthit.gov/facas/sites/faca/files/hitpc-transmittal-letter-priv-sectigerteam-020211.pdf,
Tromp M, Meray N, Ravelli AC, Reitsma JB, Bonsel GJ: Ignoring dependency between linking variables and its impact on the outcome of probabilistic record linkage studies. J Am Med Inform Assoc. 2008, 15 (5): 654-660. 10.1197/jamia.M2265.
Torra V, Domingo-Ferrer J: Record linkage methods for multidatabase data mining. Information fusion in data mining. Edited by: Torra V. 2003, Heidelberg: Springer, 101-132.
Domingo-Ferrer J, Torra V: A quantitative comparison of disclosure control methods for microdata. Confidentiality, Disclosure,and Data Access: Theory and Practical Applications for Statistical Agencies. Edited by: Doyle P, Lane JI, Theeuwes JM, Zayatz LM. 2001, New York: Elsevier, 111-133.
Domingo-Ferrer J, Torra V: Distance-based and probabilistic record linkage for re-identification of records with categorical variables. Butlletí de l´ACIA, Associació Catalana d´Intelligència Artificial. 2002, 243-250.
Torra V, Abowd J, Domingo-Ferrer J: Using Mahalanobis distance-based record linkage for disclosure risk assessment. Privacy in Statistical Databases vol. 4302. Edited by: Domingo-Ferrer J, Franconi L. 2006, Berlin Heidelberg: Springer, 233-242.
Fellegi IP, Sunter AB: A Theory for record linkage. J Am Stat Assoc. 1969, 64: 1183-1210. 10.1080/01621459.1969.10501049.
Thibaudeau Y: The discrimination power of dependency structures in record linkage. Surv Methodol. 1993, 19: 31-38.
Vacek PM: The effect of conditional dependence on the evaluation of diagnostic tests. Biometrics. 1985, 41 (4): 959-968. 10.2307/2530967.
Schürle J: A method for consideration of conditional dependencies in the Fellegi and Sunter model of record linkage. Stat Pap. 2005, 46 (3): 433-449. 10.1007/BF02762843.
Haberman SJ: Analysis of qualitative data: Vol. II. New developments. 1979, New York: Academic Press
Clogg CC: Handbook of statistical modeling for the social and behavioral sciences. Edited by: Arminger G, Clogg CC, Sobel ME. 1995, New York: Plenum, 311-359.
Becker MP, Yang I: Latent class marginal models for cross-classification of counts. Sociol Methodol. 1998, 28: 293-325. 10.1111/0081-1750.00050.
Espeland MA, Handelman SL: Using latent class models to characterize and assess relative error in discrete measurements. Biometrics. 1989, 45: 587-599. 10.2307/2531499.
Yang I, Becker MP: Latent variable modeling of diagnsotic accuracy. Biometrics. 1997, 53: 948-958. 10.2307/2533555.
Winkler WE: Improved decision rules in the Fellegi-Sunter model of record linkage. Proceedings of the Section on Survey Research Methods, American Statistical Association: 1993. 1993, 274-279.
Larsen MD: Modeling issues and the use of experience in record linkage. Record Linkage Techniques-1997: Proceedings of an International Workshop and Exposition. 1997, Washington, DC: National Academy Press, 95-105.
Larsen MD, Rubin DB: Iterative automated record linkage using mixture models. J Am Stat Assoc. 2001, 96 (453): 32-41. 10.1198/016214501750332956.
Zhu R, Zhang J, Zhang D, Yan G: Stepwise variable selection in loglinear mixtures in record linkage. Eur J Pure Appl Math. 2010, 3 (2): 141-162.
Dempster AP, Laird NM, Rubin DB: Maximum likelihood from incomplete data via the EM algorithm. J R Stat Soc, Series B. 1977, 39 (1): 1-38.
Winkler WE: Matching and record linkage. Business Survey Methods. 1995, New York: J. Wiley, 355-384.
Raftery A: Choosing models for cross-classification. Am Sociol Rev. 1986, 51: 145-146. 10.2307/2095483.
Qu Y, Tan M, Kutner MH: Random effects models in latent class analysis for evaluating accuracy of diagnostic tests. Biometrics. 1996, 52 (3): 797-810. 10.2307/2533043.
Biondich PG, Grannis SJ: The Indiana network for patient care: an integrated clinical information system informed by over thirty years of experience. J Public Health Manag Pract. 2004, (Supp): S81-86.
Hadgu A, Qu Y: A biomedical application of latent class models with random effects. J R Stat Soc, Series C (Applied Statistics). 1998, 47 (4): 603-616.
Xu H, Craig BA: A probit latent class model with general correlation structures for evaluating accuracy of diagnostic tests. Biometrics. 2009, 65: 1145-1155. 10.1111/j.1541-0420.2008.01194.x.
Albert PS, Dodd LE: A cautionary note on the robustness of latent class models for estimating diagnostic error without a gold standard. Biometrics. 2004, 60 (2): 427-435. 10.1111/j.0006-341X.2004.00187.x.
The pre-publication history for this paper can be accessed here:http://www.biomedcentral.com/1472-6947/13/97/prepub
The authors declare that they have no competing interests.
JKD drafted the manuscript, prepared tables and figures as well as supplemental material. HX performed analysis, was involved in drafting manuscript and created SAS macro. SLH reformatted and also wrote portions of the manuscript. REG provided knowledge on record linkage. This work was supported by SJG’s grant and SJG provided additional knowledge on record linkage as well as provided the data. All authors read and approved the final manuscript.
Electronic supplementary material
Additional file 1:MCHD Loglinear Models.sas. SAS program that uses the loglinear approach described in this paper to fit the MCHD dataset. Requires SAS® software available from SAS Institute Inc., Cary, NC, USA. (SAS 17 KB)
Additional file 2:corr macro.sas. SAS macro to compute the correlation residual. Requires SAS® software available from SAS Institute Inc., Cary, NC, USA. (SAS 2 KB)
Authors’ original submitted files for images
Below are the links to the authors’ original submitted files for images.
Rights and permissions
This article is published under license to BioMed Central Ltd. This is an Open Access article distributed under the terms of the Creative Commons Attribution License (http://creativecommons.org/licenses/by/2.0), which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
About this article
Cite this article
Daggy, J.K., Xu, H., Hui, S.L. et al. A practical approach for incorporating dependence among fields in probabilistic record linkage. BMC Med Inform Decis Mak 13, 97 (2013). https://doi.org/10.1186/1472-6947-13-97
- Bayesian Information Criterion
- Conditional Independence
- Record Linkage
- Latent Class Model
- Health Information Exchange