Microsimulation of an educational attainment register to predict future record linkage quality

Int J Popul Data Sci. 2023 Apr 3;8(1):2122. doi: 10.23889/ijpds.v8i1.2122. eCollection 2023.

Abstract

Introduction: Population wide educational attainment registers are necessary for educational planning and research. Regular linking of databases is needed to build and update such a register. Without availability of unique national identification numbers, record linkage must be based on quasi-identifiers such as name, date of birth and sex. However, the data protection principle of data minimization aims to minimize the set of identifiers in databases.

Objectives: Therefore, the German Federal Ministry of Research and Education commissioned a study to inform legislation on the minimum set of identifiers required for a national educational register.

Methods: To justify our recommendations empirically, we implemented a microsimulation of about 20 million people. The simulated register accumulates changes and errors in identifiers due to migration, regional mobility, marriage, school career and mortality, thereby allowing the study of errors on longitudinal datasets. Updated records were linked yearly to the simulated register using several linkage methods. Clear-text methods as well as privacy-preserving (PPRL) methods were compared.

Results: The results indicate linkage bias if only the primary identifiers are available in the register. More detailed identifiers, including place of birth, are required to minimize linkage bias. The amount of information available to identify a person for matching is more critical for linkage quality than the record linkage method applied. Differences in linkage quality between the best procedures (probabilistic linkage and multiple matchkeys) are minor.

Conclusions: Microsimulation is a valuable tool for designing record linkage procedures. By modelling the processes resulting in changes or errors in quasi-identifiers, predicting data quality to be expected after the implementation of a register seems possible.

Keywords: errors; identifiers; longitudinal studies; record linkage; register; simulation.

Publication types

  • Research Support, Non-U.S. Gov't

MeSH terms

  • Academic Success*
  • Data Accuracy
  • Databases, Factual
  • Educational Status
  • Humans
  • Schools

Grants and funding

The study was commissioned to the first author by the German Federal Ministry of Education and Research. The funding body had no role in the design of the study, simulation, analysis or interpretation, nor in writing the manuscript.