Harmonization of the Health and Risk Factor Questionnaire data of the Canadian Partnership for Tomorrow Project: a descriptive analysis

Evaluating the harmonization potential of oral health-related questionnaires in national longitudinal birth and child cohort surveys

BACKGROUND/OBJECTIVES

Effective use of longitudinal study data is challenging because of divergences in the construct definitions and measurement approaches over time, between studies and across disciplines. One approach to overcome these challenges is data harmonization. Data harmonization is a practice used to improve variable comparability and reduce heterogeneity across studies. This study describes the process used to evaluate the harmonization potential of oral health-related variables across each survey wave.

METHODS

National child cohort surveys with similar themes/objectives conducted in the last two decades were selected. The Maelstrom Research Guidelines were followed for harmonization potential evaluation.

RESULTS

Seven nationally representative child cohort surveys were included and questionnaires examined from 50 survey waves. Questionnaires were classified into three domains and fifteen constructs and summarized by age groups. A DataSchema (a list of core variables representing the suitable version of the oral health outcomes and risk factors) was compiled comprising 42 variables. For each study wave, the potential (or not) to generate each DataSchema variable was evaluated. Of the 2100 harmonization status assessments, 543 (26%) were complete. Approximately 50% of the DataSchema variables can be generated across at least four cohort surveys while only 10% (n = 4) variables can be generated across all surveys. For each survey, the DataSchema variables that can be generated ranged between 26% and 76%.

CONCLUSION

Data harmonization can improve the comparability of variables both within and across surveys. For future cohort surveys, the authors advocate more consistency and standardization in survey questionnaires within and between surveys.

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.

Large-Scale Data Harmonization Across Prospective Studies

The Preconception Period Analysis of Risks and Exposures Influencing Health and Development (PrePARED) Consortium creates a novel resource for addressing preconception health by merging data from numerous cohort studies. In this paper, we describe our data harmonization methods and results. Individual-level data from 12 prospective studies were pooled. The crosswalk-cataloging-harmonization procedure was used. The index pregnancy was defined as the first postbaseline pregnancy lasting more than 20 weeks. We assessed heterogeneity across studies by comparing preconception characteristics in different types of studies. The pooled data set included 114,762 women, and 25,531 (22%) reported at least 1 pregnancy of more than 20 weeks' gestation during the study period. Babies from the index pregnancies were delivered between 1976 and 2021 (median, 2008), at a mean maternal age of 29.7 (standard deviation, 4.6) years. Before the index pregnancy, 60% of women were nulligravid, 58% had a college degree or more, and 37% were overweight or obese. Other harmonized variables included race/ethnicity, household income, substance use, chronic conditions, and perinatal outcomes. Participants from pregnancy-planning studies had more education and were healthier. The prevalence of preexisting medical conditions did not vary substantially based on whether studies relied on self-reported data. Use of harmonized data presents opportunities to study uncommon preconception risk factors and pregnancy-related events. This harmonization effort laid the groundwork for future analyses and additional data harmonization.

Life course of retrospective harmonization initiatives: key elements to consider

Optimizing research on the developmental origins of health and disease (DOHaD) involves implementing initiatives maximizing the use of the available cohort study data; achieving sufficient statistical power to support subgroup analysis; and using participant data presenting adequate follow-up and exposure heterogeneity. It also involves being able to undertake comparison, cross-validation, or replication across data sets. To answer these requirements, cohort study data need to be findable, accessible, interoperable, and reusable (FAIR), and more particularly, it often needs to be harmonized. Harmonization is required to achieve or improve comparability of the putatively equivalent measures collected by different studies on different individuals. Although the characteristics of the research initiatives generating and using harmonized data vary extensively, all are confronted by similar issues. Having to collate, understand, process, host, and co-analyze data from individual cohort studies is particularly challenging. The scientific success and timely management of projects can be facilitated by an ensemble of factors. The current document provides an overview of the 'life course' of research projects requiring harmonization of existing data and highlights key elements to be considered from the inception to the end of the project.

Experiences from the harmonization of Finnish national population-based health survey data

Aims: There are several advantages to pooling survey data from individual studies over time or across different countries. Our aim is to share our experiences on harmonizing data from 13 Finnish health examination surveys covering the years 1972–2017 and to describe the challenges related to harmonizing different variable types using two questionnaire variables – blood pressure measurement and total cholesterol assessment – as examples. Methods: Data from Finnish national population-based health surveys were harmonized as part of the research project ‘Projections of the Burden of Disease and Disability in Finland – Health Policy Prospects’, including variables from questionnaires, objective health measurements and results from the laboratory analysis of biological samples. The process presented in the Maelstrom Research guidelines for data harmonization was followed with minor adjustments. Results: The harmonization of data from objective measurements and biomarkers was reasonably straightforward, but questionnaire items proved more challenging. Some questions and response options had changed during the covered time period. This concerned, for example, questionnaire items on the availability and use of medication and diet. Conclusions: The long time period – 45 years – made harmonization more complicated. The survey questions or response options had changed for some topics due to changes in society. However, common core variables for topics that were especially relevant for the project, such as lifestyle factors and certain diseases or conditions, could be harmonized with sufficient comparability. For future surveys, the use of standardized survey methods and the proper documentation of data collection are recommended to facilitate harmonization.

Long-term exposure to air pollution and mortality in a prospective cohort: The Ontario Health Study

BACKGROUND

Air pollution has been associated with increased mortality. However, updated evidence from cohort studies with detailed information on various risk factors is needed, especially in regions with low air pollution levels. We investigated the associations between long-term exposure to air pollution and mortality in a prospective cohort.

METHODS

We studied 88,615 participants aged ≥30 years from an ongoing cohort study in Ontario, Canada from 2009 to 2017. Exposure to ambient fine particulate matter (PM_2.5) and nitrogen dioxide (NO₂) was estimated at participants' residence. Cox proportional hazard models were used to investigate the associations between air pollution and non-accidental, cardiovascular, and respiratory mortality, adjusted for a wide array of individual-level and contextual covariates. Potential effect modification by socio-demographic and behavioral factors was also examined in exploratory stratified analyses.

RESULTS

The fully adjusted hazard ratios (HRs) per 1 µg/m³ increment in PM_2.5 were 1.037 [95% confidence interval (CI): 1.018, 1.057]¸ 1.083 (95% CI: 1.040, 1.128) and 1.109 (95% CI: 1.035, 1.187) for non-accidental, cardiovascular, and respiratory mortality, respectively. Positive associations were also found for NO₂; the corresponding HRs per 1 ppb increment were 1.027 (95% CI: 1.021, 1.034), 1.032 (95% CI: 1.019, 1.046) and 1.044 (95% CI: 1.020, 1.068). We found suggestive evidence of stronger associations in physically active participants, smokers, and those with lower household income.

CONCLUSIONS

Long-term exposure to PM_2.5 and NO₂ was associated with increased risks for non-accidental, cardiovascular, and respiratory mortality, suggesting potential benefits of further improvement in air quality even in low-exposure environments.

Personalized Risk Assessment for Prevention and Early Detection of Breast Cancer: Integration and Implementation (PERSPECTIVE I&I)

Early detection of breast cancer through screening reduces breast cancer mortality. The benefits of screening must also be considered within the context of potential harms (e.g., false positives, overdiagnosis). Furthermore, while breast cancer risk is highly variable within the population, most screening programs use age to determine eligibility. A risk-based approach is expected to improve the benefit-harm ratio of breast cancer screening programs. The PERSPECTIVE I&I (Personalized Risk Assessment for Prevention and Early Detection of Breast Cancer: Integration and Implementation) project seeks to improve personalized risk assessment to allow for a cost-effective, population-based approach to risk-based screening and determine best practices for implementation in Canada. This commentary describes the four inter-related activities that comprise the PERSPECTIVE I&I project. 1: Identification and validation of novel moderate to high-risk susceptibility genes. 2: Improvement, validation, and adaptation of a risk prediction web-tool for the Canadian context. 3: Development and piloting of a socio-ethical framework to support implementation of risk-based breast cancer screening. 4: Economic analysis to optimize the implementation of risk-based screening. Risk-based screening and prevention is expected to benefit all women, empowering them to work with their healthcare provider to make informed decisions about screening and prevention.

A Prospective Analysis of Plasma Phospholipid Fatty Acids and Breast Cancer Risk in 2 Provinces in Canada

BACKGROUND

Studies suggest that fatty acid status influences breast cancer etiology, yet the roles of individual fatty acids in breast cancer risk are unclear, specifically when central adiposity and menopausal status are considered.

OBJECTIVES

This study examined the associations of fatty acid status with breast cancer risk including location, menopausal status, and waist-to-hip ratio as key variables.

METHODS

Prediagnostic plasma phospholipid fatty acids were measured in women with breast cancer (n = 393) and age-matched controls (n = 786) from a nested case-control prospective study within Alberta's Tomorrow Project (ATP) and British Columbia Generations Project (BCGP) cohorts. Binary logistic regression models were used to evaluate associations of fatty acids and breast cancer risk with subgroup analysis for menopausal status and waist-to-hip ratio.

RESULTS

Women from BCGP had a higher n-3 (ɷ-3) fatty acid status compared with the ATP (6.4% ± 0.08% vs. 5.3% ± 0.06%; P < 0.001), so subsequent analysis was blocked by cohort. Overall, fatty acids had inconsistent associations with risk. In the ATP among premenopausal women, total long-chain n-3 fatty acids (ORQ4vsQ1 = 1.78; 95% CI: 0.58, 5.43; P-trend = 0.007, P-interaction = 0.07) were positively associated with breast cancer risk, whereas in BCGP, DHA (ORQ4vsQ1 = 0.66; 95% CI: 0.28, 1.53; P-trend = 0.03, P-interaction = 0.05) and total long-chain n-3 fatty acids (ORQ4vsQ1 = 0.66; 95% CI: 0.28, 1.54; P-trend = 0.03) were associated with decreased cancer risk when the waist-to-hip ratio was <0.85.

CONCLUSIONS

Our findings suggest that regional variations in fatty acid status influence breast cancer risk, resulting in positive associations of total long-chain n-3 fatty acids in premenopausal ATP women and negative associations of these fatty acids in BCGP women with a waist-to-hip ratio below guidelines. This study highlights the complexity and difficulty in using fatty acid status to predict breast cancer risk in diverse populations without the consideration of other risk factors.

Data harmonization for collaborative research among MS registries: A case study in employment

OBJECTIVE

To assess the feasibility of collaboration and retrospective data harmonization among three multiple sclerosis (MS) registries by investigating employment status.

METHODS

We used the Maelstrom guidelines to facilitate retrospective harmonization of data from three MS registries, including the NARCOMS (North American Research Committee on MS) Registry, German MS Register (GMSR), and United Kingdom MS (UK-MS) Register. A protocol was developed based on the guidelines, and summary-level data were used to combine results. Employment status and a limited set of factors associated with employment (age, sex, education, and disability level) were harmonized. A meta-analytic approach was used to pool estimates using a weighted average of logistic regression estimates and their variances in a random effects model.

RESULTS

Employment status, age, sex, education, and disability were mapped. The overall employment rate was 57% (11,143 employed out of 19,562 persons with MS) with the GMSR having the highest proportion of participants employed (66.2%), followed by the UK-MS (55.2%) and NARCOMS (43.0%) registries. As disability level increased, the odds of not being employed increased.

CONCLUSION

Harmonization across registries was feasible. The Maelstrom guidelines provide a valuable roadmap for conducting high-quality harmonization projects. The pooling of data sources has the potential to be an important mechanism for conducting research in MS.