An atomic approach to the design and implementation of a research data warehouse.
J Am Med Inform Assoc
; 29(4): 601-608, 2022 03 15.
Article
em En
| MEDLINE
| ID: mdl-34613409
ABSTRACT
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 ANDMETHODS:
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.Palavras-chave
Texto completo:
1
Coleções:
01-internacional
Base de dados:
MEDLINE
Contexto em Saúde:
1_ASSA2030
Problema de saúde:
1_geracao_evidencia_conhecimento
/
1_sistemas_informacao_saude
Assunto principal:
Health Insurance Portability and Accountability Act
/
Data Warehousing
Tipo de estudo:
Qualitative_research
Limite:
Humans
País/Região como assunto:
America do norte
Idioma:
En
Revista:
J Am Med Inform Assoc
Assunto da revista:
INFORMATICA MEDICA
Ano de publicação:
2022
Tipo de documento:
Article
País de afiliação:
Estados Unidos