Linkage of multiple electronic health record datasets using a 'spine linkage' approach compared with all 'pairwise linkages'.
Linkage of multiple electronic health record datasets using a 'spine linkage' approach compared with all 'pairwise linkages'.
复制标题
DOI：
10.1093/ije/dyac130
复制
发表时间：
2023-02-08
影响因子：
7.7
通讯作者：
中科院分区：
文献类型：
--
作者：
在两个数据集之间链接记录的方法已经很好地建立。然而，需要为链接两个以上的数据集提供指导。使用所有“成对链接”-将每个数据集链接到每个其他数据集-是最具包容性但资源密集型的方法。“脊柱”方法将每个数据集链接到指定的“脊柱数据集”，减少了链接的数量，但可能会降低链接质量。我们使用2013年10月31日至2018年4月30日期间接受急诊肠癌手术的患者的真实数据比较了成对和脊柱连接方法。我们链接了一个行政医院数据集（医院事件统计; HES），捕获在英格兰医院住院的患者，以及两个临床数据集，包括诊断为肠癌的患者和接受紧急肠道手术的患者。以HES作为脊柱数据集的脊柱连接方法创建了一个包含15826例患者的分析队列，相当于使用成对连接方法识别的16100例患者中的98.3%。 这些分析队列之间的患者特征无系统性差异。患者和肿瘤特征与死亡率、并发症和住院时间的相关性对联系方法不敏感。当在连锁之前应用资格标准时，脊柱连锁包括14509例患者（与成对连锁相比为90.0%）。 如果脊柱数据集的病例确定性和连锁变量的数据质量较高，则脊柱连锁可以用作成对连锁的有效替代方案。在使用脊柱连接创建分析队列之前，应在指定的脊柱数据集中系统评价这些方面。
Methods for linking records between two datasets are well established. However, guidance is needed for linking more than two datasets. Using all ‘pairwise linkages’—linking each dataset to every other dataset—is the most inclusive, but resource-intensive, approach. The ‘spine’ approach links each dataset to a designated ‘spine dataset’, reducing the number of linkages, but potentially reducing linkage quality. We compared the pairwise and spine linkage approaches using real-world data on patients undergoing emergency bowel cancer surgery between 31 October 2013 and 30 April 2018. We linked an administrative hospital dataset (Hospital Episode Statistics; HES) capturing patients admitted to hospitals in England, and two clinical datasets comprising patients diagnosed with bowel cancer and patients undergoing emergency bowel surgery. The spine linkage approach, with HES as the spine dataset, created an analysis cohort of 15 826 patients, equating to 98.3% of the 16 100 patients identified using the pairwise linkage approach. There were no systematic differences in patient characteristics between these analysis cohorts. Associations of patient and tumour characteristics with mortality, complications and length of stay were not sensitive to the linkage approach. When eligibility criteria were applied before linkage, spine linkage included 14 509 patients (90.0% compared with pairwise linkage). Spine linkage can be used as an efficient alternative to pairwise linkage if case ascertainment in the spine dataset and data quality of linkage variables are high. These aspects should be systematically evaluated in the nominated spine dataset before spine linkage is used to create the analysis cohort.
登录
查看更多内容
影响因子：
2.9
作者：
Hagger-Johnson, Gareth;Harron, Katie;Parslow, Roger C.
通讯作者：
Parslow, Roger C.
影响因子：
7.2
作者：
Lee KJ;Tilling KM;Cornish RP;Little RJA;Bell ML;Goetghebeur E;Hogan JW;Carpenter JR;STRATOS initiative
通讯作者：
STRATOS initiative
影响因子：
7.2
作者：
Blake, Helen A.;Sharples, Linda D.;Walker, Kate
通讯作者：
Walker, Kate
影响因子：
3.5
作者：
Chiu, Maria;Lebenbaum, Michael;Guttmann, Astrid
通讯作者：
Guttmann, Astrid
影响因子：
4.5
作者：
John, Ann;McGregor, Joanna;Lloyd, Keith
通讯作者：
Lloyd, Keith