Projects per year
Abstract
Objectives
Building upon the Scottish Safe Haven Network’s (SSHN) collaborative experience to develop an exemplar dataset on Scottish national level laboratory tests within the SSHN. To test the feasibility of a federated safe haven network in Scotland for clinical laboratory data using existing federation solutions.
Approach
Considerations were given to the clinical tests that are being commonly used across Scotland. An investigation of laboratory data structure was conducted using SQL with the assistance of White Rabbit which captures the metadata information from each safe haven. Data heterogeneity or commonalities were investigated in detail in R. We examined the inter-relationships among clinical laboratories from different regions of NHS Scotland. A common data structure was proposed to facilitate the sharing of clinical test results. We investigated multiple existing federation solutions to streamline access to data across the SSHN.
Results
A dataset of all laboratory tests for patients registered with the Scottish Health Research Register and Biobank (SHARE) from laboratory data sources within the network (Grampian Data Safe Haven, Health Informatics Center, Glasgow Safe Haven & Lothian/DataLoch Safe Haven) were developed. An open-source toolkit that includes SQL scripts to harmonise laboratory data from multiple safe haven and R scripts to conduct heterogeneity investigation to streamline the sharing and the analysis was created. We have shown a working model for federation within Scotland for the first time with the view to expand into more routine projects. The project has developed a systematic concept mapping of data available across the SSHN to aid cohort discovery.
Conclusions
The exemplar national level laboratory data together with the toolkit will help provide researchers with information such as which data are available to access. It will also support and improve national-level research studies at a faster pace. The work has demonstrated the feasibility of a common process for federated data discovery and sharing across the SSHN.
Building upon the Scottish Safe Haven Network’s (SSHN) collaborative experience to develop an exemplar dataset on Scottish national level laboratory tests within the SSHN. To test the feasibility of a federated safe haven network in Scotland for clinical laboratory data using existing federation solutions.
Approach
Considerations were given to the clinical tests that are being commonly used across Scotland. An investigation of laboratory data structure was conducted using SQL with the assistance of White Rabbit which captures the metadata information from each safe haven. Data heterogeneity or commonalities were investigated in detail in R. We examined the inter-relationships among clinical laboratories from different regions of NHS Scotland. A common data structure was proposed to facilitate the sharing of clinical test results. We investigated multiple existing federation solutions to streamline access to data across the SSHN.
Results
A dataset of all laboratory tests for patients registered with the Scottish Health Research Register and Biobank (SHARE) from laboratory data sources within the network (Grampian Data Safe Haven, Health Informatics Center, Glasgow Safe Haven & Lothian/DataLoch Safe Haven) were developed. An open-source toolkit that includes SQL scripts to harmonise laboratory data from multiple safe haven and R scripts to conduct heterogeneity investigation to streamline the sharing and the analysis was created. We have shown a working model for federation within Scotland for the first time with the view to expand into more routine projects. The project has developed a systematic concept mapping of data available across the SSHN to aid cohort discovery.
Conclusions
The exemplar national level laboratory data together with the toolkit will help provide researchers with information such as which data are available to access. It will also support and improve national-level research studies at a faster pace. The work has demonstrated the feasibility of a common process for federated data discovery and sharing across the SSHN.
| Original language | English |
|---|---|
| Publication status | Published - 7 Sept 2022 |
| Event | International Population Data Linkage Conference 2022 - Edinburgh Duration: 7 Sept 2022 → 9 Sept 2022 Conference number: 2022 https://ipdln.org/2022-conference |
Conference
| Conference | International Population Data Linkage Conference 2022 |
|---|---|
| Abbreviated title | IPDLN |
| City | Edinburgh |
| Period | 7/09/22 → 9/09/22 |
| Internet address |
Fingerprint
Dive into the research topics of 'Towards a Scottish Safe Haven Federation'. Together they form a unique fingerprint.Projects
- 1 Finished
-
Graph-based Data Federation for Healthcare Data Science (Joint with University of Edinburgh, University of Strathclyde, University of Glasgow and University of Aberdeen)
Jefferson, E. (Investigator) & Pearson, E. (Investigator)
1/03/19 → 1/04/20
Project: Research