{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,9]],"date-time":"2026-03-09T18:31:35Z","timestamp":1773081095946,"version":"3.50.1"},"reference-count":32,"publisher":"Frontiers Media SA","license":[{"start":{"date-parts":[[2024,10,11]],"date-time":"2024-10-11T00:00:00Z","timestamp":1728604800000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"funder":[{"DOI":"10.13039\/100010269","name":"Wellcome Trust","doi-asserted-by":"publisher","id":[{"id":"10.13039\/100010269","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":["frontiersin.org"],"crossmark-restriction":true},"short-container-title":["Front. Big Data"],"abstract":"<jats:sec><jats:title>Background<\/jats:title><jats:p>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.<\/jats:p><\/jats:sec><jats:sec><jats:title>Methods<\/jats:title><jats:p>The \u201cINSPIRE\u201d 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.<\/jats:p><\/jats:sec><jats:sec><jats:title>Results<\/jats:title><jats:p>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.<\/jats:p><\/jats:sec><jats:sec><jats:title>Conclusion<\/jats:title><jats:p>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.<\/jats:p><\/jats:sec>","DOI":"10.3389\/fdata.2024.1435510","type":"journal-article","created":{"date-parts":[[2024,10,11]],"date-time":"2024-10-11T04:42:23Z","timestamp":1728621743000},"update-policy":"https:\/\/doi.org\/10.3389\/crossmark-policy","source":"Crossref","is-referenced-by-count":3,"title":["Integrating longitudinal mental health data into a staging database: harnessing DDI-lifecycle and OMOP vocabularies within the INSPIRE Network Datahub"],"prefix":"10.3389","volume":"7","author":[{"given":"Bylhah","family":"Mugotitsa","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Tathagata","family":"Bhattacharjee","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Michael","family":"Ochola","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Dorothy","family":"Mailosi","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"David","family":"Amadi","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Pauline","family":"Andeso","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Joseph","family":"Kuria","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Reinpeter","family":"Momanyi","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Evans","family":"Omondi","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Dan","family":"Kajungu","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jim","family":"Todd","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Agnes","family":"Kiragga","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jay","family":"Greenfield","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"1965","published-online":{"date-parts":[[2024,10,11]]},"reference":[{"key":"B1","doi-asserted-by":"publisher","first-page":"1958","DOI":"10.1177\/00207640231182358","article-title":"Global, regional, and national burden and quality of care index (QCI) of bipolar disorder: a systematic analysis of the Global Burden of Disease Study 1990 to 2019","volume":"69","author":"Aghababaie-Babaki","year":"2023","journal-title":"Int. J. Soc. Psychiatry"},{"key":"B2","doi-asserted-by":"publisher","first-page":"11834","DOI":"10.3390\/ijms231911834","article-title":"OMOP CDM can facilitate data-driven studies for cancer prediction: a systematic review","volume":"23","author":"Ahmadi","year":"2022","journal-title":"Int. J. Mol. Sci"},{"key":"B3","author":"Benzler","year":"1998","journal-title":"A Data Model for Demographic Surveillance Systems"},{"key":"B4","doi-asserted-by":"publisher","first-page":"1329630","DOI":"10.3389\/fdgth.2024.1329630","article-title":"INSPIRE datahub: a pan-African integrated suite of services for harmonising longitudinal population health data using OHDSI tools","volume":"6","author":"Bhattacharjee","year":"2024","journal-title":"Frontiers in Digital Health"},{"key":"B5","unstructured":""},{"key":"B6","unstructured":""},{"key":"B7","unstructured":""},{"key":"B8","unstructured":""},{"key":"B9","doi-asserted-by":"publisher","first-page":"3534","DOI":"10.3390\/ijerph19063534","article-title":"Exposome and social vulnerability: an overview of the literature review","volume":"19","author":"Deguen","year":"2022","journal-title":"Int. J. Environ. Res. Public. Health"},{"key":"B10","article-title":"The IeDEA data exchange standard: a common data model for global HIV cohort collaboration","author":"Duda","year":"2020","journal-title":"MedRxiv [Preprint]"},{"key":"B11","doi-asserted-by":"publisher","first-page":"296","DOI":"10.3109\/09540261.2015.1014314","article-title":"Current practices for measuring mental health outcomes in the USA: international overview of routine outcome measures in mental health","volume":"27","author":"Essock","year":"2015","journal-title":"Int. Rev. Psychiatry"},{"key":"B12","author":"Greenfield","year":"2013","journal-title":"The Paradata Information Model"},{"key":"B13","author":"Healthcare","year":"2017","journal-title":"Informatics for Integrating Biology and the Bedside"},{"key":"B14","unstructured":""},{"key":"B15","unstructured":""},{"key":"B16","doi-asserted-by":"publisher","first-page":"1082","DOI":"10.1093\/ije\/dyaa064","article-title":"Cohort profile: the Iganga-Mayuge Health and Demographic Surveillance Site, Uganda (IMHDSS, Uganda)","volume":"49","author":"Kajungu","year":"2020","journal-title":"Int. J. Epidemiol"},{"key":"B17","doi-asserted-by":"publisher","first-page":"593","DOI":"10.1001\/archpsyc.62.6.593","article-title":"Lifetime prevalence and age-of-onset distributions of DSM-IV disorders in the National Comorbidity Survey Replication","volume":"62","author":"Kessler","year":"2005","journal-title":"Archiv. Gen. Psychiatry"},{"key":"B18","author":"Kimball","year":"1996","journal-title":"The Data Warehouse Toolkit: Practical Techniques For Building Dimensional Data Warehouses-Bom"},{"key":"B19","doi-asserted-by":"publisher","first-page":"1116682","DOI":"10.3389\/fpubh.2023.1116682","article-title":"Enabling data sharing and utilization for African population health data using OHDSI tools with an OMOP-common data model","volume":"11","author":"Kiwuwa-Muyingo","year":"2023","journal-title":"Front. Public Health"},{"key":"B20","doi-asserted-by":"publisher","first-page":"225","DOI":"10.1016\/S0306-4379(02)00021-2","article-title":"Why is the snowflake schema a good data warehouse design?","volume":"28","author":"Levene","year":"2003","journal-title":"Inf. Syst"},{"key":"B21","unstructured":"MoetiM.\n          World Mental Health Day 20222022"},{"key":"B22","doi-asserted-by":"publisher","first-page":"2019","DOI":"10.1038\/s41591-022-01990-1","article-title":"The global burden of disease study at 30 years","volume":"28","author":"Murray","year":"2022","journal-title":"Nat. Med"},{"key":"B23","doi-asserted-by":"publisher","first-page":"104421","DOI":"10.1016\/j.amsu.2022.104421","article-title":"Accessing Mental Health Services in Africa: current state, efforts, challenges and recommendation","volume":"81","author":"Nicholas","year":"2022","journal-title":"Ann. Med. Surg"},{"key":"B24","unstructured":""},{"key":"B25","unstructured":""},{"key":"B26","unstructured":""},{"key":"B27","doi-asserted-by":"publisher","first-page":"fcac109","DOI":"10.1093\/braincomms\/fcac109","article-title":"Structural progression of Alzheimer's disease over decades: the MRI staging scheme","volume":"4","author":"Planche","year":"2022","journal-title":"Brain Commun"},{"key":"B28","doi-asserted-by":"publisher","first-page":"osad004","DOI":"10.1093\/exposome\/osad004","article-title":"The ethical aspects of exposome research: a systematic review","volume":"3","author":"Safarlou","year":"2023","journal-title":"Exposome"},{"key":"B29","unstructured":""},{"key":"B30","doi-asserted-by":"publisher","first-page":"107","DOI":"10.2218\/ijdc.v3i1.45","article-title":"Data documentation initiative: toward a standard for the social sciences","volume":"3","author":"Vardigan","year":"2008","journal-title":"Int. J. Digit. Curat"},{"key":"B31","doi-asserted-by":"publisher","first-page":"553","DOI":"10.1093\/jamia\/ocu023","article-title":"Feasibility and utility of applications of the common data model to multiple, disparate observational health databases","volume":"22","author":"Voss","year":"2015","journal-title":"J. Am. Med. Inform. Assoc"},{"key":"B32","unstructured":""}],"container-title":["Frontiers in Big Data"],"original-title":[],"link":[{"URL":"https:\/\/www.frontiersin.org\/articles\/10.3389\/fdata.2024.1435510\/full","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,10,11]],"date-time":"2024-10-11T04:42:32Z","timestamp":1728621752000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.frontiersin.org\/articles\/10.3389\/fdata.2024.1435510\/full"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024,10,11]]},"references-count":32,"alternative-id":["10.3389\/fdata.2024.1435510"],"URL":"https:\/\/doi.org\/10.3389\/fdata.2024.1435510","relation":{},"ISSN":["2624-909X"],"issn-type":[{"value":"2624-909X","type":"electronic"}],"subject":[],"published":{"date-parts":[[2024,10,11]]},"article-number":"1435510"}}