Evidence map›Paper›PMID 39463847›Full record

ArticleFrontiers in big data2024

Integrating longitudinal mental health data into a staging database: harnessing DDI-lifecycle and OMOP vocabularies within the INSPIRE Network Datahub.

Bylhah Mugotitsa, Tathagata Bhattacharjee, Michael Ochola, Dorothy Mailosi, David Amadi, Pauline Andeso, Joseph Kuria, Reinpeter Momanyi, Evans Omondi, Dan Kajungu and 3 more

Abstract read
In one paragraph

Article in Frontiers in big data, 2024. The graph could read no effect estimate from its abstract, so it casts no vote on the map. Cited by 3 papers.

0numbers the graph read from it
0cells of the map it votes in
3citing papers in PubMed
–field-weighted citation impact
1 · What the graph read from it

What it found

Each row is one number read from the abstract, on the scale the paper reported it, with its interval. Left of the dashed line favours the treatment, right favours the comparator. Under each row is the sentence it came from. New to these charts? A ten-minute tutorial.

The abstract states no effect estimate the extractor could read, or names no intervention and outcome on the map, so this paper lights no cell and moves no belief. It is still indexed, cited and linked below.

2 · The registry

The trial behind it

Trials whose registry record cites this paper, or whose number appears in the abstract. A trial that started after this paper was published is citing it as background, not reporting it.

Neither the registry nor the abstract names a trial number. If this is a trial report, that itself is worth knowing.

3 · Its place in the literature

Who cites it

3 citing papers in PubMed.

  1. Article
  2. Article
  3. Article
4 · The record

Corrections and comments

PubMed lists nothing against this paper. Absence here is not a guarantee, only a check that was made.

5 · Who and what money

Authors and funding

13 authors.

Bylhah MugotitsaAfrican Population and Health Research Center (APHRC), Nairobi, Kenya.
Tathagata BhattacharjeeDepartment of Population Health, London School of Hygiene and Tropical Medicine, London, United Kingdom.
Michael OcholaAfrican Population and Health Research Center (APHRC), Nairobi, Kenya.
Dorothy MailosiArtificial Intelligence and Machine Learning (AI and ML), CODATA-Committee on Data of the International Science Council, Paris, France.
David AmadiDepartment of Population Health, London School of Hygiene and Tropical Medicine, London, United Kingdom.
Pauline AndesoAfrican Population and Health Research Center (APHRC), Nairobi, Kenya.
Joseph KuriaAfrican Population and Health Research Center (APHRC), Nairobi, Kenya.
Reinpeter MomanyiAfrican Population and Health Research Center (APHRC), Nairobi, Kenya.
Evans OmondiAfrican Population and Health Research Center (APHRC), Nairobi, Kenya.
Dan KajunguIganga Mayuge Health and Demographic Surveillance Site (IMHDSS), Makerere University Centre for Health and Population Research (MUCHAP), Kampala, Uganda.
Jim ToddDepartment of Population Health, London School of Hygiene and Tropical Medicine, London, United Kingdom.
Agnes KiraggaAfrican Population and Health Research Center (APHRC), Nairobi, Kenya.
Jay GreenfieldArtificial Intelligence and Machine Learning (AI and ML), CODATA-Committee on Data of the International Science Council, Paris, France.

Funding

Wellcome Trust
6 · The paper itself

Abstract

Background: Longitudinal studies are essential for understanding the progression of mental health disorders over time, but combining data collected through different methods to assess conditions like depression, anxiety, and psychosis presents significant challenges. This study presents a mapping technique allowing for the conversion of diverse longitudinal data into a standardized staging database, leveraging the Data Documentation Initiative (DDI) Lifecycle and the Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM) standards to ensure consistency and compatibility across datasets. Methods: The "INSPIRE" project integrates longitudinal data from African studies into a staging database using metadata documentation standards structured with a snowflake schema. This facilitates the development of Extraction, Transformation, and Loading (ETL) scripts for integrating data into OMOP CDM. The staging database schema is designed to capture the dynamic nature of longitudinal studies, including changes in research protocols and the use of different instruments across data collection waves. Results: Utilizing this mapping method, we streamlined the data migration process to the staging database, enabling subsequent integration into the OMOP CDM. Adherence to metadata standards ensures data quality, promotes interoperability, and expands opportunities for data sharing in mental health research. Conclusion: The staging database serves as an innovative tool in managing longitudinal mental health data, going beyond simple data hosting to act as a comprehensive study descriptor. It provides detailed insights into each study stage and establishes a data science foundation for standardizing and integrating the data into OMOP CDM.

Indexed as

DDI-lifecycleextractlongitudinal mental healthOMOP Common Data Modelstaging databasetransform and load

Identifiers

PMID39463847
PMCPMC11502395

What OpenQuestion holds

Textmetadata
LicenceCC BY
Read underepoch 390

Registered trials

None linked

Read under generation 80e0d062 · epoch 390. Bibliography from PubMed, PubMed Central and OpenAlex; grants from NIH RePORTER; trial links from ClinicalTrials.gov; estimates, votes and beliefs from the OpenQuestion graph.