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

IF 1.6 Q3 HEALTH CARE SCIENCES & SERVICES
International Journal of Population Data Science Pub Date : 2023-04-03 eCollection Date: 2023-01-01 DOI:10.23889/ijpds.v8i1.2122
Rainer Schnell, Severin Weiand
{"title":"Microsimulation of an educational attainment register to predict future record linkage quality.","authors":"Rainer Schnell,&nbsp;Severin Weiand","doi":"10.23889/ijpds.v8i1.2122","DOIUrl":null,"url":null,"abstract":"<p><strong>Introduction: </strong>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.</p><p><strong>Objectives: </strong>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.</p><p><strong>Methods: </strong>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.</p><p><strong>Results: </strong>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.</p><p><strong>Conclusions: </strong>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.</p>","PeriodicalId":36483,"journal":{"name":"International Journal of Population Data Science","volume":"8 1","pages":"2122"},"PeriodicalIF":1.6000,"publicationDate":"2023-04-03","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"https://ftp.ncbi.nlm.nih.gov/pub/pmc/oa_pdf/26/51/ijpds-08-2122.PMC10463005.pdf","citationCount":"1","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"International Journal of Population Data Science","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.23889/ijpds.v8i1.2122","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"2023/1/1 0:00:00","PubModel":"eCollection","JCR":"Q3","JCRName":"HEALTH CARE SCIENCES & SERVICES","Score":null,"Total":0}
引用次数: 1

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.

Abstract Image

Abstract Image

Abstract Image

一个教育程度登记册的微观模拟,以预测未来的记录联动质量。
引言:全民教育程度登记对于教育规划和研究是必要的。建立和更新这样一个登记册需要定期链接数据库。如果没有唯一的国家身份号码,记录联系必须基于姓名、出生日期和性别等准标识符。然而,数据最小化的数据保护原则旨在最小化数据库中的标识符集。目标:因此,德国联邦研究和教育部委托进行了一项研究,为国家教育登记所需的最低标识符集的立法提供信息。方法:为了从经验上证明我们的建议,我们对大约2000万人进行了微观模拟。模拟登记册积累了移民、地区流动、婚姻、学校职业和死亡率导致的标识符变化和错误,从而可以研究纵向数据集上的错误。更新后的记录每年使用几种链接方法与模拟登记册进行链接。比较了明文方法和隐私保护(PPRL)方法。结果:如果寄存器中只有主要标识符可用,则结果表明存在链接偏差。需要更详细的标识符,包括出生地,以最大限度地减少联系偏差。与所应用的记录链接方法相比,可用于识别要匹配的人的信息量对链接质量更为关键。最佳程序(概率链接和多个匹配键)之间的链接质量差异很小。结论:微模拟是设计记录连接程序的一种有价值的工具。通过对导致准标识符变化或错误的过程进行建模,预测寄存器实施后的预期数据质量似乎是可能的。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
求助全文
约1分钟内获得全文 求助全文
来源期刊
CiteScore
2.50
自引率
0.00%
发文量
386
审稿时长
20 weeks
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
确定
请完成安全验证×
copy
已复制链接
快去分享给好友吧!
我知道了
右上角分享
点击右上角分享
0
联系我们:info@booksci.cn Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。 Copyright © 2023 布克学术 All rights reserved.
京ICP备2023020795号-1
ghs 京公网安备 11010802042870号
Book学术文献互助
Book学术文献互助群
群 号:481959085
Book学术官方微信