Recommendations for data collection in cohort studies of preterm born individuals - The RECAP Preterm Core Dataset.

BACKGROUND: Preterm birth (before 37 completed weeks of gestation) is associated with an increased risk of adverse health and developmental outcomes relative to birth at term. Existing guidelines for data collection in cohort studies of individuals born preterm are either limited in scope, have not been developed using formal consensus methodology, or did not involve a range of stakeholders in their development. Recommendations meeting these criteria would facilitate data pooling and harmonisation across studies. OBJECTIVES: To develop a Core Dataset for use in longitudinal cohort studies of individuals born preterm. METHODS: This work was carried out as part of the RECAP Preterm project. A systematic review of variables included in existing core outcome sets was combined with a scoping exercise conducted with experts on preterm birth. The results were used to generate a draft core dataset. A modified Delphi process was implemented using two stages with three rounds each. Three stakeholder groups participated: RECAP Preterm project partners; external experts in the field; people with lived experience of preterm birth. The Delphi used a 9-point Likert scale. Higher values indicated greater importance for inclusion. Participants also suggested additional variables they considered important for inclusion which were voted on in later rounds. RESULTS: An initial list of 140 data items was generated. Ninety-six participants across 22 countries participated in the Delphi, of which 29% were individuals with lived experience of preterm birth. Consensus was reached on 160 data items covering Antenatal and Birth Information, Neonatal Care, Mortality, Administrative Information, Organisational Level Information, Socio-economic and Demographic information, Physical Health, Education and Learning, Neurodevelopmental Outcomes, Social, Lifestyle and Leisure, Healthcare Utilisation and Quality of Life. CONCLUSIONS: This core dataset includes 160 data items covering antenatal care through outcomes in adulthood. Its use will guide data collection in new studies and facilitate pooling and harmonisation of existing data internationally.

Using natural language processing to facilitate the harmonisation of mental health questionnaires: a validation study using real-world data.

BACKGROUND: Pooling data from different sources will advance mental health research by providing larger sample sizes and allowing cross-study comparisons; however, the heterogeneity in how variables are measured across studies poses a challenge to this process. METHODS: This study explored the potential of using natural language processing (NLP) to harmonise different mental health questionnaires by matching individual questions based on their semantic content. Using the Sentence-BERT model, we calculated the semantic similarity (cosine index) between 741 pairs of questions from five questionnaires. Drawing on data from a representative UK sample of adults (N = 2,058), we calculated a Spearman rank correlation for each of the same pairs of items, and then estimated the correlation between the cosine values and Spearman coefficients. We also used network analysis to explore the model's ability to uncover structures within the data and metadata. RESULTS: We found a moderate overall correlation (r = .48, p < .001) between the two indices. In a holdout sample, the cosine scores predicted the real-world correlations with a small degree of error (MAE = 0.05, MedAE = 0.04, RMSE = 0.064) suggesting the utility of NLP in identifying similar items for cross-study data pooling. Our NLP model could detect more complex patterns in our data, however it required manual rules to decide which edges to include in the network. CONCLUSIONS: This research shows that it is possible to quantify the semantic similarity between pairs of questionnaire items from their meta-data, and these similarity indices correlate with how participants would answer the same two items. This highlights the potential of NLP to facilitate cross-study data pooling in mental health research. Nevertheless, researchers are cautioned to verify the psychometric equivalence of matched items.

Connecting cohorts of Finnish biobanks creates a research resource for the study of healthy ageing.

AIMS: Connecting cohorts with biobanks is a Finnish biobank collaboration, creating an infrastructure for the study of healthy ageing. We aimed to develop a model for data integration and harmonisation between different biobanks with procedures for joint access. METHODS: The heart of the collaboration is the integrated datasets formed by using data from three biobanks: (a) Arctic Biobank, hosting regional birth cohorts and cohorts of elderly; (b) hospital-affiliated Borealis Biobank of Northern Finland; and (c) THL Biobank, hosting population-based cohorts. The datasets were created by developing a data dictionary, harmonising cohort data and with a joint pseudonymisation process. RESULTS: The connecting cohorts with biobanks resource at its widest consists altogether of almost 1.4 million individuals from collaborating biobanks. Utilising data from 107,000 cohort participants, we created harmonised datasets that contain attributes describing metabolic risk and frailty for studies of healthy ageing. These data can be complemented with medical data available from Biobank Borealis and with samples taken at hospital settings for approximately 38,000 cohort participants. In addition, the harmonised connecting cohorts with biobanks datasets can be expanded with supplementary data and samples from the collaborating biobanks. CONCLUSIONS: The connecting cohorts with biobanks datasets provide a unique resource for research on ageing-related personalised healthcare and for real-world evidence studies. Following the FAIR principles on findability, accessibility, interoperability, and reusability, the reused and harmonised datasets are findable and made accessible for researchers. The same approach can be further utilised to develop additional datasets for other research topics.

A multi-modal data harmonisation approach for discovery of COVID-19 drug targets.

Despite the volume of experiments performed and data available, the complex biology of coronavirus SARS-COV-2 is not yet fully understood. Existing molecular profiling studies have focused on analysing functional omics data of a single type, which captures changes in a small subset of the molecular perturbations caused by the virus. As the logical next step, results from multiple such omics analysis may be aggregated to comprehensively interpret the molecular mechanisms of SARS-CoV-2. An alternative approach is to integrate data simultaneously in a parallel fashion to highlight the inter-relationships of disease-driving biomolecules, in contrast to comparing processed information from each omics level separately. We demonstrate that valuable information may be masked by using the former fragmented views in analysis, and biomarkers resulting from such an approach cannot provide a systematic understanding of the disease aetiology. Hence, we present a generic, reproducible and flexible open-access data harmonisation framework that can be scaled out to future multi-omics analysis to study a phenotype in a holistic manner. The pipeline source code, detailed documentation and automated version as a R package are accessible. To demonstrate the effectiveness of our pipeline, we applied it to a drug screening task. We integrated multi-omics data to find the lowest level of statistical associations between data features in two case studies. Strongly correlated features within each of these two datasets were used for drug-target analysis, resulting in a list of 84 drug-target candidates. Further computational docking and toxicity analyses revealed seven high-confidence targets, amsacrine, bosutinib, ceritinib, crizotinib, nintedanib and sunitinib as potential starting points for drug therapy and development.

Evaluating the harmonisation potential of diverse cohort datasets.

Data discovery, the ability to find datasets relevant to an analysis, increases scientific opportunity, improves rigour and accelerates activity. Rapid growth in the depth, breadth, quantity and availability of data provides unprecedented opportunities and challenges for data discovery. A potential tool for increasing the efficiency of data discovery, particularly across multiple datasets is data harmonisation.A set of 124 variables, identified as being of broad interest to neurodegeneration, were harmonised using the C-Surv data model. Harmonisation strategies used were simple calibration, algorithmic transformation and standardisation to the Z-distribution. Widely used data conventions, optimised for inclusiveness rather than aetiological precision, were used as harmonisation rules. The harmonisation scheme was applied to data from four diverse population cohorts.Of the 120 variables that were found in the datasets, correspondence between the harmonised data schema and cohort-specific data models was complete or close for 111 (93%). For the remainder, harmonisation was possible with a marginal a loss of granularity.Although harmonisation is not an exact science, sufficient comparability across datasets was achieved to enable data discovery with relatively little loss of informativeness. This provides a basis for further work extending harmonisation to a larger variable list, applying the harmonisation to further datasets, and incentivising the development of data discovery tools.

Harmonising electronic health records for reproducible research: challenges, solutions and recommendations from a UK-wide COVID-19 research collaboration.

BACKGROUND: The CVD-COVID-UK consortium was formed to understand the relationship between COVID-19 and cardiovascular diseases through analyses of harmonised electronic health records (EHRs) across the four UK nations. Beyond COVID-19, data harmonisation and common approaches enable analysis within and across independent Trusted Research Environments. Here we describe the reproducible harmonisation method developed using large-scale EHRs in Wales to accommodate the fast and efficient implementation of cross-nation analysis in England and Wales as part of the CVD-COVID-UK programme. We characterise current challenges and share lessons learnt. METHODS: Serving the scope and scalability of multiple study protocols, we used linked, anonymised individual-level EHR, demographic and administrative data held within the SAIL Databank for the population of Wales. The harmonisation method was implemented as a four-layer reproducible process, starting from raw data in the first layer. Then each of the layers two to four is framed by, but not limited to, the characterised challenges and lessons learnt. We achieved curated data as part of our second layer, followed by extracting phenotyped data in the third layer. We captured any project-specific requirements in the fourth layer. RESULTS: Using the implemented four-layer harmonisation method, we retrieved approximately 100 health-related variables for the 3.2 million individuals in Wales, which are harmonised with corresponding variables for > 56 million individuals in England. We processed 13 data sources into the first layer of our harmonisation method: five of these are updated daily or weekly, and the rest at various frequencies providing sufficient data flow updates for frequent capturing of up-to-date demographic, administrative and clinical information. CONCLUSIONS: We implemented an efficient, transparent, scalable, and reproducible harmonisation method that enables multi-nation collaborative research. With a current focus on COVID-19 and its relationship with cardiovascular outcomes, the harmonised data has supported a wide range of research activities across the UK.

Development of a data classification system for preterm birth cohort studies: the RECAP Preterm project.

BACKGROUND: The small sample sizes available within many very preterm (VPT) longitudinal birth cohort studies mean that it is often necessary to combine and harmonise data from individual studies to increase statistical power, especially for studying rare outcomes. Curating and mapping data is a vital first step in the process of data harmonisation. To facilitate data mapping and harmonisation across VPT birth cohort studies, we developed a custom classification system as part of the Research on European Children and Adults born Preterm (RECAP Preterm) project in order to increase the scope and generalisability of research and the evaluation of outcomes across the lifespan for individuals born VPT. METHODS: The multidisciplinary consortium of expert clinicians and researchers who made up the RECAP Preterm project participated in a four-phase consultation process via email questionnaire to develop a topic-specific classification system. Descriptive analyses were calculated after each questionnaire round to provide pre- and post- ratings to assess levels of agreement with the classification system as it developed. Amendments and refinements were made to the classification system after each round. RESULTS: Expert input from 23 clinicians and researchers from the RECAP Preterm project aided development of the classification system's topic content, refining it from 10 modules, 48 themes and 197 domains to 14 modules, 93 themes and 345 domains. Supplementary classifications for target, source, mode and instrument were also developed to capture additional variable-level information. Over 22,000 individual data variables relating to VPT birth outcomes have been mapped to the classification system to date to facilitate data harmonisation. This will continue to increase as retrospective data items are mapped and harmonised variables are created. CONCLUSIONS: This bespoke preterm birth classification system is a fundamental component of the RECAP Preterm project's web-based interactive platform. It is freely available for use worldwide by those interested in research into the long term impact of VPT birth. It can also be used to inform the development of future cohort studies.

Harmonisation of large-scale, heterogeneous individual participant adverse event data from randomised trials of statin therapy.

BACKGROUND: Meta-analyses of individual-level data from randomised trials are often required to detect clinically worthwhile effects. The Cholesterol Treatment Trialists' Collaboration, which includes data from numerous large long-term statin trials, is conducting a review of the effects of statin therapy on all adverse events collected in those trials. This article describes the approaches used and challenges faced to systematically capture and categorise the data. METHODS: Protocols, statistical analysis plans, case report forms, clinical study reports and datasets were obtained, reviewed and checked. Relevant baseline and follow-up data from each trial was then reorganised into standardised formats based upon the Clinical Data Interchange Standards Consortium Study Data Tabulation Model. Adverse event data were organised and coded (automatically or, where necessary, manually) according to a common medical dictionary based upon the Medical Dictionary for Regulatory Activities. RESULTS: Data from 23 double-blind statin trials and 5 open-label statin trials were provided, either through direct data transfer or through online access platforms. Together, these trials provided 845 datasets containing over 38 million records relating to 30,495 study variables and 181,973 randomised participants. Of the 46 Clinical Data Interchange Standards Consortium Study Data Tabulation Model domains that could potentially have been used to organise the data, the 13 most relevant to the project were identified and utilised, including 6 domains related to post-randomisation adverse events. Nearly 1.2 million adverse events were extracted and mapped to over 45,000 unique adverse event terms. Of these adverse events, 99% were coded to a Medical Dictionary for Regulatory Activities 'lower level term', with the remainder coded to a 'higher level term' or, very rarely, only a 'higher level group term'. CONCLUSION: In this meta-analysis of adverse event data from the large randomised trials of statins, approaches based on common standards for data organisation and classification have provided a resource capable of allowing reliable and rapid evaluation of any previously unknown benefits or hazards of statin therapy.

Data harmonisation for information fusion in digital healthcare: A state-of-the-art systematic review, meta-analysis and future research directions.

Removing the bias and variance of multicentre data has always been a challenge in large scale digital healthcare studies, which requires the ability to integrate clinical features extracted from data acquired by different scanners and protocols to improve stability and robustness. Previous studies have described various computational approaches to fuse single modality multicentre datasets. However, these surveys rarely focused on evaluation metrics and lacked a checklist for computational data harmonisation studies. In this systematic review, we summarise the computational data harmonisation approaches for multi-modality data in the digital healthcare field, including harmonisation strategies and evaluation metrics based on different theories. In addition, a comprehensive checklist that summarises common practices for data harmonisation studies is proposed to guide researchers to report their research findings more effectively. Last but not least, flowcharts presenting possible ways for methodology and metric selection are proposed and the limitations of different methods have been surveyed for future research.

The EU Child Cohort Network's core data: establishing a set of findable, accessible, interoperable and re-usable (FAIR) variables.

The Horizon2020 LifeCycle Project is a cross-cohort collaboration which brings together data from multiple birth cohorts from across Europe and Australia to facilitate studies on the influence of early-life exposures on later health outcomes. A major product of this collaboration has been the establishment of a FAIR (findable, accessible, interoperable and reusable) data resource known as the EU Child Cohort Network. Here we focus on the EU Child Cohort Network's core variables. These are a set of basic variables, derivable by the majority of participating cohorts and frequently used as covariates or exposures in lifecourse research. First, we describe the process by which the list of core variables was established. Second, we explain the protocol according to which these variables were harmonised in order to make them interoperable. Third, we describe the catalogue developed to ensure that the network's data are findable and reusable. Finally, we describe the core data, including the proportion of variables harmonised by each cohort and the number of children for whom harmonised core data are available. EU Child Cohort Network data will be analysed using a federated analysis platform, removing the need to physically transfer data and thus making the data more accessible to researchers. The network will add value to participating cohorts by increasing statistical power and exposure heterogeneity, as well as facilitating cross-cohort comparisons, cross-validation and replication. Our aim is to motivate other cohorts to join the network and encourage the use of the EU Child Cohort Network by the wider research community.

The impact of physical activity on healthy ageing trajectories: evidence from eight cohort studies.

BACKGROUND: Research has suggested the positive impact of physical activity on health and wellbeing in older age, yet few studies have investigated the associations between physical activity and heterogeneous trajectories of healthy ageing. We aimed to identify how physical activity can influence healthy ageing trajectories using a harmonised dataset of eight ageing cohorts across the world. METHODS: Based on a harmonised dataset of eight ageing cohorts in Australia, USA, Mexico, Japan, South Korea, and Europe, comprising 130,521 older adults (Mage = 62.81, SDage = 10.06) followed-up up to 10 years (Mfollow-up = 5.47, SDfollow-up = 3.22), we employed growth mixture modelling to identify latent classes of people with different trajectories of healthy ageing scores, which incorporated 41 items of health and functioning. Multinomial logistic regression modelling was used to investigate the associations between physical activity and different types of trajectories adjusting for sociodemographic characteristics and other lifestyle behaviours. RESULTS: Three latent classes of healthy ageing trajectories were identified: two with stable trajectories with high (71.4%) or low (25.2%) starting points and one with a high starting point but a fast decline over time (3.4%). Engagement in any level of physical activity was associated with decreased odds of being in the low stable (OR: 0.18; 95% CI: 0.17, 0.19) and fast decline trajectories groups (OR: 0.44; 95% CI: 0.39, 0.50) compared to the high stable trajectory group. These results were replicated with alternative physical activity operationalisations, as well as in sensitivity analyses using reduced samples. CONCLUSIONS: Our findings suggest a positive impact of physical activity on healthy ageing, attenuating declines in health and functioning. Physical activity promotion should be a key focus of healthy ageing policies to prevent disability and fast deterioration in health.

The challenges in data integration - heterogeneity and complexity in clinical trials and patient registries of Systemic Lupus Erythematosus.

BACKGROUND: Individual clinical trials and cohort studies are a useful source of data, often under-utilised once a study has ended. Pooling data from multiple sources could increase sample sizes and allow for further investigation of treatment effects; even if the original trial did not meet its primary goals. Through the MASTERPLANS (MAximizing Sle ThERapeutic PotentiaL by Application of Novel and Stratified approaches) national consortium, focused on Systemic Lupus Erythematosus (SLE), we have gained valuable real-world experiences in aligning, harmonising and combining data from multiple studies and trials, specifically where standards for data capture, representation and documentation, were not used or were unavailable. This was not without challenges arising both from the inherent complexity of the disease and from differences in the way data were captured and represented across different studies. MAIN BODY: Data were, unavoidably, aligned by hand, matching up equivalent or similar patient variables across the different studies. Heterogeneity-related issues were tackled and data were cleaned, organised and combined, resulting in a single large dataset ready for analysis. Overcoming these hurdles, often seen in large-scale data harmonization and integration endeavours of legacy datasets, was made possible within a realistic timescale and limited resource by focusing on specific research questions driven by the aims of MASTERPLANS. Here we describe our experiences tackling the complexities in the integration of large, diverse datasets, and the lessons learned. CONCLUSIONS: Harmonising data across studies can be complex, and time and resource consuming. The work carried out here highlights the importance of using standards for data capture, recording, and representation, to facilitate both the integration of large datasets and comparison between studies. Where standards are not implemented at the source harmonisation is still possible by taking a flexible approach, with systematic preparation, and a focus on specific research questions.

Definitions, components and processes of data harmonisation in healthcare: a scoping review.

BACKGROUND: Data harmonisation (DH) has emerged amongst health managers, information technology specialists and researchers as an important intervention for routine health information systems (RHISs). It is important to understand what DH is, how it is defined and conceptualised, and how it can lead to better health management decision-making. This scoping review identifies a range of definitions for DH, its characteristics (in terms of key components and processes), and common explanations of the relationship between DH and health management decision-making. METHODS: This scoping review identified relevant studies from 2000 onwards (date filter), written in English and published in PubMed, Web of Science and CINAHL. Two reviewers independently screened records for potential inclusion for the abstract and full-text screening stages. One reviewer did the data extraction, analysis and synthesis, with built-in reliability checks from the rest of the team. We developed a narrative synthesis of definitions and explanations of the relationship between DH and health management decision-making. RESULTS: We sampled 61 of 181 included to synthesis definitions and concepts of DH in detail. We identified six common terms for data harmonisation: record linkage, data linkage, data warehousing, data sharing, data interoperability and health information exchange. We also identified nine key components of data harmonisation: DH involves (a) a process of multiple steps; (b) integrating, harmonising and bringing together different databases (c) two or more databases; (d) electronic data; (e) pooling data using unique patient identifiers; and (f) different types of data; (g) data found within and across different departments and institutions at facility, district, regional and national levels; (h) different types of technical activities; (i) has a specific scope. The relationship between DH and health management decision-making is not well-described in the literature. Several studies mentioned health providers' concerns about data completeness, data quality, terminology and coding of data elements as barriers to data utilisation for clinical decision-making. CONCLUSION: To our knowledge, this scoping review was the first to synthesise definitions and concepts of DH and address the causal relationship between DH and health management decision-making. Future research is required to assess the effectiveness of data harmonisation on health management decision-making.

Pressure injury data in Australian acute care settings: A comparison of three data sets.

Hospital-acquired pressure injuries (HAPIs) represent a serious clinical and economic problem. The cost of treating HAPIs in Australian public hospitals was recently reported at AUS$983 million per annum. There are three main sources of data for documenting pressure injury (PI) occurrence in Australian hospitals: incident reporting, medical record coded data, and real-time surveys of pressure injury. PI data reported at hospital level and to external agencies using these three different sources are variable. This reporting issue leads to inaccurate data interpretation and hinders improvement in accuracy of PI identification and PI prevention. This study involved a comparison of the three different data sources in selected Australian hospitals, to improve the accuracy and comparability of data. Findings from this study provide benchmark areas for improvement in PI documenting and reporting. Better understanding the agreement between the three data sets could lead to a more efficient and effective sharing of data sources.

Transforming a Large-Scale Prostate Cancer Outcomes Dataset to the OMOP Common Data Model-Experiences from a Scientific Data Holder's Perspective.

To enhance international and joint research collaborations in prostate cancer research, data from different sources should use a common data model (CDM) that enables researchers to share their analysis scripts and merge results. The OMOP CDM maintained by OHDSI is such a data model developed for a federated data analysis with partners from different institutions that want to jointly investigate research questions using clinical care data. The German Cancer Society as the scientific lead of the Prostate Cancer Outcomes (PCO) study gathers data from prostate cancer care including routine oncological care data and survey data (incl. patient-reported outcomes) and uses a common data specification (called OncoBox Research Prostate) for this purpose. To further enhance research collaborations outside the PCO study, the purpose of this article is to describe the process of transferring the PCO study data to the internationally well-established OMOP CDM. This process was carried out together with an IT company that specialised in supporting research institutions to transfer their data to OMOP CDM. Of n = 49,692 prostate cancer cases with 318 data fields each, n = 392 had to be excluded during the OMOPing process, and n = 247 of the data fields could be mapped to OMOP CDM. The resulting PostgreSQL database with OMOPed PCO study data is now ready to use within larger research collaborations such as the EU-funded EHDEN and OPTIMA consortium.

Physical Activity Participation Decreases the Risk of Depression in Older Adults: The ATHLOS Population-Based Cohort Study.

BACKGROUND: To which extent physical activity is associated with depression independent of older adults' physical and cognitive functioning is largely unknown. This cohort study using harmonised data by the EU Ageing Trajectories of Health: Longitudinal Opportunities and Synergies consortium, including over 20 countries, to evaluate the longitudinal association of physical activity (light-to-moderate or vigorous intensity) with depression in older adults (aged ≥ 50 years). RESULTS: We evaluated 56,818 participants (light-to-moderate models; 52.7% females, age 50-102 years) and 62,656 participants (vigorous models; 52.7% females, age 50-105 years). Compared to never, light-to-moderate or vigorous physical activity was associated with a lower incidence rate ratio (IRR) of depression (light-to-moderate model: once/week: 0.632, 95% CI 0.602-0.663; twice or more/week: 0.488, 95% CI 0.468-0.510; vigorous model: once/week: 0.652, 95% CI 0.623-0.683; twice or more/week: 0.591, 95% CI 0.566-0.616). Physical activity remained associated with depression after adjustment for the healthy ageing scale, which is a scale that incorporated 41 items of physical and cognitive functioning (light-to-moderate model: once/week: 0.787, 95% CI 0.752-0.824; twice or more/week: 0.711, 95% CI 0.682-0.742; vigorous model: once/week: 0.828, 95% CI 0.792-0.866; twice or more/week: 0.820, 95% CI 0.786-0.856). CONCLUSIONS: Physical activity, of any intensity and weekly frequency, was a strong protective factor against depression, independent of physical and mental functioning. Health policies could stimulate the incorporation of lower physical activity intensity to protect against depression, which might be more feasible at the population level.

Essential data variables for a minimum dataset for head and neck cancer trials and clinical research: HNCIG consensus recommendations and database.

The Head and Neck Cancer International Group (HNCIG) has undertaken an international modified Delphi process to reach consensus on the essential data variables to be included in a minimum database for HNC research. Endorsed by 19 research organisations representing 34 countries, these recommendations provide the framework to facilitate and harmonise data collection and sharing for HNC research. These variables have also been incorporated into a ready to use downloadable HNCIG minimum database, available from the HNCIG website.

INSPIRE datahub: a pan-African integrated suite of services for harmonising longitudinal population health data using OHDSI tools.

Introduction: Population health data integration remains a critical challenge in low- and middle-income countries (LMIC), hindering the generation of actionable insights to inform policy and decision-making. This paper proposes a pan-African, Findable, Accessible, Interoperable, and Reusable (FAIR) research architecture and infrastructure named the INSPIRE datahub. This cloud-based Platform-as-a-Service (PaaS) and on-premises setup aims to enhance the discovery, integration, and analysis of clinical, population-based surveys, and other health data sources. Methods: The INSPIRE datahub, part of the Implementation Network for Sharing Population Information from Research Entities (INSPIRE), employs the Observational Health Data Sciences and Informatics (OHDSI) open-source stack of tools and the Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM) to harmonise data from African longitudinal population studies. Operating on Microsoft Azure and Amazon Web Services cloud platforms, and on on-premises servers, the architecture offers adaptability and scalability for other cloud providers and technology infrastructure. The OHDSI-based tools enable a comprehensive suite of services for data pipeline development, profiling, mapping, extraction, transformation, loading, documentation, anonymization, and analysis. Results: The INSPIRE datahub's "On-ramp" services facilitate the integration of data and metadata from diverse sources into the OMOP CDM. The datahub supports the implementation of OMOP CDM across data producers, harmonizing source data semantically with standard vocabularies and structurally conforming to OMOP table structures. Leveraging OHDSI tools, the datahub performs quality assessment and analysis of the transformed data. It ensures FAIR data by establishing metadata flows, capturing provenance throughout the ETL processes, and providing accessible metadata for potential users. The ETL provenance is documented in a machine- and human-readable Implementation Guide (IG), enhancing transparency and usability. Conclusion: The pan-African INSPIRE datahub presents a scalable and systematic solution for integrating health data in LMICs. By adhering to FAIR principles and leveraging established standards like OMOP CDM, this architecture addresses the current gap in generating evidence to support policy and decision-making for improving the well-being of LMIC populations. The federated research network provisions allow data producers to maintain control over their data, fostering collaboration while respecting data privacy and security concerns. A use-case demonstrated the pipeline using OHDSI and other open-source tools.

The successes and challenges of harmonising juvenile idiopathic arthritis (JIA) datasets to create a large-scale JIA data resource.

BACKGROUND: CLUSTER is a UK consortium focussed on precision medicine research in JIA/JIA-Uveitis. As part of this programme, a large-scale JIA data resource was created by harmonizing and pooling existing real-world studies. Here we present challenges and progress towards creation of this unique large JIA dataset. METHODS: Four real-world studies contributed data; two clinical datasets of JIA patients starting first-line methotrexate (MTX) or tumour necrosis factor inhibitors (TNFi) were created. Variables were selected based on a previously developed core dataset, and encrypted NHS numbers were used to identify children contributing similar data across multiple studies. RESULTS: Of 7013 records (from 5435 individuals), 2882 (1304 individuals) represented the same child across studies. The final datasets contain 2899 (MTX) and 2401 (TNFi) unique patients; 1018 are in both datasets. Missingness ranged from 10 to 60% and was not improved through harmonisation. CONCLUSIONS: Combining data across studies has achieved dataset sizes rarely seen in JIA, invaluable to progressing research. Losing variable specificity and missingness, and their impact on future analyses requires further consideration.

The DACRIN data project: A process for harmonising data collection for clinical research in alcohol and other drugs services in New South Wales.

INTRODUCTION: Standardised data collection processes allow for harmonisation and comparison of data across different studies and services. This project aimed to develop a 'core dataset' to serve as the default collection when designing future studies and evaluations, building upon data routinely collected in clinical alcohol and other drugs (AOD) settings in NSW, Australia. METHODS: A working group was established, comprising clinicians, researchers, data managers and consumers from public sector and non-government organisation AOD services in the NSW Drug and Alcohol Clinical Research and Improvement Network. A series of Delphi meetings occurred to reach consensus on the data items to be included in the core dataset for three domains: demographics, treatment activity and substance use variables. RESULTS: There were 20-40 attendees at each meeting. An initial consensus criterion of having received >70% of the vote was established. Given the difficulty in reaching consensus for most items, subsequently, this was changed to eliminate items that received <5 votes, after which the item receiving the most votes would be selected. DISCUSSIONS AND CONCLUSIONS: This important process received considerable interest and buy-in across the NSW AOD sector. Ample opportunity for discussion and voting was provided for the three domains of interest, allowing participants to contribute their expertise and experience to inform decisions. As such, we believe the core dataset includes the best options currently available to collect data for these domains in the NSW AOD context, and potentially more broadly. This foundational study may inform other attempts to harmonise data across AOD services.