PMID- 37206994
OWN - NLM
STAT- PubMed-not-MEDLINE
LR  - 20230920
IS  - 2574-2531 (Electronic)
IS  - 2574-2531 (Linking)
VI  - 5
IP  - 2
DP  - 2022 Jul
TI  - Establishing a centralized data mart from the Rakai community cohort study to 
      improve HIV research in Rakai, Uganda.
PG  - ooac032
LID - 10.1093/jamiaopen/ooac032 [doi]
LID - ooac032
AB  - 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.
CI  - Published by Oxford University Press on behalf of the American Medical 
      Informatics Association 2022.
FAU - Ndyanabo, Anthony
AU  - Ndyanabo A
AD  - Rakai Health Sciences Program, Kalisizo, Uganda.
FAU - Footer, Kevin
AU  - Footer K
AD  - Office of Cyber Infrastructure & Computational Biology, National Institute of 
      Allergy and Infectious Diseases, National Institutes of Health, Bethesda, 
      Maryland, USA.
FAU - Ahmed, Tanvir
AU  - Ahmed T
AD  - Office of Cyber Infrastructure & Computational Biology, National Institute of 
      Allergy and Infectious Diseases, National Institutes of Health, Bethesda, 
      Maryland, USA.
FAU - Glogowski, Alex
AU  - Glogowski A
AD  - Office of Cyber Infrastructure & Computational Biology, National Institute of 
      Allergy and Infectious Diseases, National Institutes of Health, Bethesda, 
      Maryland, USA.
FAU - Whalen, Christopher
AU  - Whalen C
AD  - Office of Cyber Infrastructure & Computational Biology, National Institute of 
      Allergy and Infectious Diseases, National Institutes of Health, Bethesda, 
      Maryland, USA.
FAU - Ssekasanvu, Joseph
AU  - Ssekasanvu J
AD  - Johns Hopkins School of Public Health, Johns Hopkins University, Baltimore, 
      Maryland, USA.
FAU - Ssentongo, Lloyd
AU  - Ssentongo L
AD  - Office of Cyber Infrastructure & Computational Biology, National Institute of 
      Allergy and Infectious Diseases, National Institutes of Health, Bethesda, 
      Maryland, USA.
FAU - Lutalo, Tom
AU  - Lutalo T
AD  - Rakai Health Sciences Program, Kalisizo, Uganda.
FAU - Nalugoda, Fred
AU  - Nalugoda F
AD  - Rakai Health Sciences Program, Kalisizo, Uganda.
FAU - Ha, Grace K
AU  - Ha GK
AD  - Office of Cyber Infrastructure & Computational Biology, National Institute of 
      Allergy and Infectious Diseases, National Institutes of Health, Bethesda, 
      Maryland, USA.
FAU - Rosenthal, Alex
AU  - Rosenthal A
AD  - Office of Cyber Infrastructure & Computational Biology, National Institute of 
      Allergy and Infectious Diseases, National Institutes of Health, Bethesda, 
      Maryland, USA.
LA  - eng
PT  - Case Reports
DEP - 20220518
PL  - United States
TA  - JAMIA Open
JT  - JAMIA open
JID - 101730643
PMC - PMC9118983
OTO - NOTNLM
OT  - data management
OT  - data mart
OT  - data reproducibility
OT  - infectious diseases
EDAT- 2023/05/19 19:14
MHDA- 2023/05/19 19:15
PMCR- 2023/05/18
CRDT- 2023/05/19 15:49
PHST- 2021/03/31 00:00 [received]
PHST- 2022/02/08 00:00 [revised]
PHST- 2022/05/07 00:00 [accepted]
PHST- 2023/05/19 19:14 [pubmed]
PHST- 2023/05/19 19:15 [medline]
PHST- 2023/05/19 15:49 [entrez]
PHST- 2023/05/18 00:00 [pmc-release]
AID - ooac032 [pii]
AID - 10.1093/jamiaopen/ooac032 [doi]
PST - epublish
SO  - JAMIA Open. 2022 May 18;5(2):ooac032. doi: 10.1093/jamiaopen/ooac032. eCollection 
      2022 Jul.