Ndyanabo A, Footer K, Ahmed T, Glogowski A, Whalen C, Ssekasanvu J, Ssentongo L, Lutalo T, Nalugoda F, Ha GK, Rosenthal A. Establishing a centralized data mart from the Rakai community cohort study to improve HIV research in Rakai, Uganda. JAMIA Open. 2022 May 18;5(2):ooac032. doi: 10.1093/jamiaopen/ooac032. PMID: 37206994; PMCID: PMC9118983.
Abstract
To improve timely access to quality HIV research data, the Rakai Health Sciences Program (RHSP) Data Mart was developed to store cohort study data from a legacy database platform in a modernized system using standard data management processes. The RHSP Data Mart was developed on a Microsoft SQL Server platform using Microsoft SQL Server Integration Services with custom data mappings and queries. The data mart stores 20+ years of longitudinal HIV research data and includes standard processes for managing data, data dictionary, training materials, and a library of queries to fulfill data requests and load new data from completed survey rounds. The RHSP Data Mart enables efficient querying and analysis of multidimensional research data by simplifying data integration and processing. A sustainable database platform with well-defined data management processes promotes data accessibility and reproducibility, enabling researchers to advance their understanding and management of infectious diseases.