An atomic approach to the design and implementation of a research data warehouse.

Objective: As a long-standing Clinical and Translational Science Awards (CTSA) Program hub, the University of Pittsburgh and the University of Pittsburgh Medical Center (UPMC) developed and implemented a modern research data warehouse (RDW) to efficiently provision electronic patient data for clinic...

Descripción completa

Detalles Bibliográficos
Publicado en:Journal of the American Medical Informatics Association Vol. 29; no. 4; pp. 601 - 609
Autores principales: Visweswaran, Shyam, McLay, Brian, Cappella, Nickie, Morris, Michele, Milnes, John T, Reis, Steven E, Silverstein, Jonathan C, Becich, Michael J
Formato: research Journal Article
Publicado: Oxford University Press / USA Apr2022
Acceso en línea:Ver este registro en EBSCOhost
fields @attributes:
  recordID: 1
pdfLink:
plink: https://search.ebscohost.com/login.aspx?direct=true&db=ccm&AN=155812588&site=ehost-live
header:
  @attributes:
    shortDbName: ccm
    uiTerm: 155812588
    longDbName: CINAHL Complete
    uiTag: AN
  controlInfo:
    bkinfo:
    dissinfo:
    jinfo:
      jid:
        10675027
        FZ9
      jtl: Journal of the American Medical Informatics Association
      issn: 10675027
      maglogo: N
    pubinfo:
      dt: Apr2022
      vid: 29
      iid: 4
      pid: 622
      pub: Oxford University Press / USA
    artinfo:
      ui:
        155812588
        155812588
        NLM34613409
        155812588
        10.1093/jamia/ocab204
        NLM34613409
        155812588
      ppf: 601
      ppct: 8
      formats:
      tig:
        atl: An atomic approach to the design and implementation of a research data warehouse.
      aug:
        au:
          Visweswaran, Shyam
          McLay, Brian
          Cappella, Nickie
          Morris, Michele
          Milnes, John T
          Reis, Steven E
          Silverstein, Jonathan C
          Becich, Michael J
        affil: Department of Biomedical Informatics, University of Pittsburgh , Pittsburgh, Pennsylvania, USA
      sug:
        subj:
          Health Insurance Portability and Accountability Act
          United States
          Institutional Review
          Information Retrieval
          Human
          Comparative Studies
          Multicenter Studies
          Evaluation Research
          Validation Studies
          Scales
      ab: Objective: As a long-standing Clinical and Translational Science Awards (CTSA) Program hub, the University of Pittsburgh and the University of Pittsburgh Medical Center (UPMC) developed and implemented a modern research data warehouse (RDW) to efficiently provision electronic patient data for clinical and translational research.Materials and Methods: We designed and implemented an RDW named Neptune to serve the specific needs of our CTSA. Neptune uses an atomic design where data are stored at a high level of granularity as represented in source systems. Neptune contains robust patient identity management tailored for research; integrates patient data from multiple sources, including electronic health records (EHRs), health plans, and research studies; and includes knowledge for mapping to standard terminologies.Results: Neptune contains data for more than 5 million patients longitudinally organized as Health Insurance Portability and Accountability Act (HIPAA) Limited Data with dates and includes structured EHR data, clinical documents, health insurance claims, and research data. Neptune is used as a source for patient data for hundreds of institutional review board-approved research projects by local investigators and for national projects.Discussion: The design of Neptune was heavily influenced by the large size of UPMC, the varied data sources, and the rich partnership between the University and the healthcare system. It includes several unique aspects, including the physical warehouse straddling the University and UPMC networks and management under an HIPAA Business Associates Agreement.Conclusion: We describe the design and implementation of an RDW at a large academic healthcare system that uses a distinctive atomic design where data are stored at a high level of granularity.
      pubtype: Academic Journal
      doctype:
        research
        Journal Article
      ougenre: Article
    language: English
    refInfo:
    holdings:
      @attributes:
        islocal: N