Universidade de Brasília, Núcleo de Medicina Tropical, Brasília, DF, Brasil.
Universidade de São Paulo, Faculdade de Saúde Pública, São Paulo, SP, Brasil.
Epidemiol Serv Saude. 2022 Oct 10;31(3):e20211272. doi: 10.1590/S2237-96222022000300004. eCollection 2022.
To present a standardized methodology for linking different public health databases.
This was a methodological review article specifically describing data processing procedures for deterministic linkage between structured databases. It instructs on how to: treat data, select linkage keys, and link databases using two databases simulated in R software.
The commands used for the deterministic linkage of the inner_join type were presented. The linkage process resulted in a database with 40,108 pairs using only the "Name" key. Adding the second key, "Name of mother", the resulted dropped to 112 pairs. By adding the third key, "Date of birth", only two pairs were identified.
Database linkage and its analysis are valid and valuable tools for health services in supporting health surveillance actions.
介绍一种标准化的方法，用于连接不同的公共卫生数据库。
这是一篇方法学综述文章，专门描述了结构化数据库之间确定性链接的数据处理程序。它指导如何：处理数据、选择链接键，并使用 R 软件模拟的两个数据库进行数据库链接。
展示了用于内连接类型的确定性链接的命令。使用仅“名称”键，链接过程生成了一个包含 40108 对的数据库。添加第二个键“母亲的姓名”后，结果减少到 112 对。通过添加第三个键“出生日期”，仅识别出两对。
数据库链接及其分析是卫生服务部门支持卫生监测行动的有效和有价值的工具。
