Skip to main content
Top
Published in: BMC Medical Research Methodology 1/2024

Open Access 01-12-2024 | Research

Novel linkage approach to join community-acquired and national data

Authors: Claire Tochel, Emma Pead, Alice McTrusty, Fiona Buckmaster, Tom MacGillivray, Andrew J. Tatham, Niall C. Strang, Baljean Dhillon, Miguel O. Bernabeu

Published in: BMC Medical Research Methodology | Issue 1/2024

Login to get access

Abstract

Background

Community optometrists in Scotland have performed regular free-at-point-of-care eye examinations for all, for over 15 years. Eye examinations include retinal imaging but image storage is fragmented and they are not used for research. The Scottish Collaborative Optometry-Ophthalmology Network e-research project aimed to collect these images and create a repository linked to routinely collected healthcare data, supporting the development of pre-symptomatic diagnostic tools.

Methods

As the image record was usually separate from the patient record and contained minimal patient information, we developed an efficient matching algorithm using a combination of deterministic and probabilistic steps which minimised the risk of false positives, to facilitate national health record linkage. We visited two practices and assessed the data contained in their image device and Practice Management Systems. Practice activities were explored to understand the context of data collection processes. Iteratively, we tested a series of matching rules which captured a high proportion of true positive records compared to manual matches. The approach was validated by testing manual matching against automated steps in three further practices.

Results

A sequence of deterministic rules successfully matched 95% of records in the three test practices compared to manual matching. Adding two probabilistic rules to the algorithm successfully matched 99% of records.

Conclusions

The potential value of community-acquired retinal images can be harnessed only if they are linked to centrally-held healthcare care data. Despite the lack of interoperability between systems within optometry practices and inconsistent use of unique identifiers, data linkage is possible using robust, almost entirely automated processes.
Literature
5.
go back to reference Harron K. In: Mackay E, Elliot M, editors. Introduction to data linkage. Administrative Data Research Network; 2016. Harron K. In: Mackay E, Elliot M, editors. Introduction to data linkage. Administrative Data Research Network; 2016.
7.
go back to reference Kendrick S, editor. The Development of Record Linkage in Scotland: The Responsive Application of Probability Matching. Record Linkage Techniques; 1997 04/12; Arlington, VA: Federal Committee on Statistical Methodology. Kendrick S, editor. The Development of Record Linkage in Scotland: The Responsive Application of Probability Matching. Record Linkage Techniques; 1997 04/12; Arlington, VA: Federal Committee on Statistical Methodology.
8.
18.
go back to reference Doney ASF, Bonney W, Jefferson E, Walesby KE, Bittern R, Trucco E, Connelly P, McCrimmon RJ, Palmer CNA. Investigating the relationship between type 2 diabetes and dementia using. Diabetes Care 2019 42(10): 1973–80 https://doi.org/10.2337/dc19-0380. Doney ASF, Bonney W, Jefferson E, Walesby KE, Bittern R, Trucco E, Connelly P, McCrimmon RJ, Palmer CNA. Investigating the relationship between type 2 diabetes and dementia using. Diabetes Care 2019 42(10): 1973–80 https://​doi.​org/​10.​2337/​dc19-0380.
24.
go back to reference Nind T, Sutherland J, McAllister G, Hardy D, Hume A, MacLeod R, Caldwell J, Krueger S, Tramma L, Teviotdale R, Abdelatif M, Gillen K, Ward J, Scobbie D, Baillie I, Brooks A, Prodan B, Kerr W, Sloan-Murphy D, Herrera JFR, McManus D, Morris C, Sinclair C, Baxter R, Parsons M, Morris A, Jefferson E. l. An extensible big data software architecture managing a research resource of real-world clinical radiology data linked to other health data from the whole Scottish population. Gigascience 2020 9(10) https://doi.org/10.1093/gigascience/giaa095. Nind T, Sutherland J, McAllister G, Hardy D, Hume A, MacLeod R, Caldwell J, Krueger S, Tramma L, Teviotdale R, Abdelatif M, Gillen K, Ward J, Scobbie D, Baillie I, Brooks A, Prodan B, Kerr W, Sloan-Murphy D, Herrera JFR, McManus D, Morris C, Sinclair C, Baxter R, Parsons M, Morris A, Jefferson E. l. An extensible big data software architecture managing a research resource of real-world clinical radiology data linked to other health data from the whole Scottish population. Gigascience 2020 9(10) https://​doi.​org/​10.​1093/​gigascience/​giaa095.
Metadata
Title
Novel linkage approach to join community-acquired and national data
Authors
Claire Tochel
Emma Pead
Alice McTrusty
Fiona Buckmaster
Tom MacGillivray
Andrew J. Tatham
Niall C. Strang
Baljean Dhillon
Miguel O. Bernabeu
Publication date
01-12-2024
Publisher
BioMed Central
Published in
BMC Medical Research Methodology / Issue 1/2024
Electronic ISSN: 1471-2288
DOI
https://doi.org/10.1186/s12874-024-02143-3

Other articles of this Issue 1/2024

BMC Medical Research Methodology 1/2024 Go to the issue