ArticleJournal of the American Medical Informatics Association : JAMIA2022
An atomic approach to the design and implementation of a research data warehouse.
Article in Journal of the American Medical Informatics Association : JAMIA, 2022. The graph could read no effect estimate from its abstract, so it casts no vote on the map. Cited by 26 papers.
What it found
Each row is one number read from the abstract, on the scale the paper reported it, with its interval. Left of the dashed line favours the treatment, right favours the comparator. Under each row is the sentence it came from. New to these charts? A ten-minute tutorial.
The abstract states no effect estimate the extractor could read, or names no intervention and outcome on the map, so this paper lights no cell and moves no belief. It is still indexed, cited and linked below.
The trial behind it
Trials whose registry record cites this paper, or whose number appears in the abstract. A trial that started after this paper was published is citing it as background, not reporting it.
Neither the registry nor the abstract names a trial number. If this is a trial report, that itself is worth knowing.
Who cites it
26 citing papers in PubMed.
- Development and validation of natural language processing pipelines to extract injury and surgery-related data elements from ACL reconstruction operative reports.BMC musculoskeletal disorders · 2026Article
- Predicting risk of unplanned subsequent knee surgery following ACL reconstruction.BMC musculoskeletal disorders · 2026Article
- Maternal Respiratory Syncytial Virus Prefusion F Vaccination and Acute Respiratory Illness in Infants.JAMA network open · 2026Article
- Insights from deep learning models on new-onset anxiety in patients following bariatric metabolic surgery.Journal of affective disorders reports · 2026Article
- Physician Referral Patterns to Physical Therapists for Managing Knee Osteoarthritis: A Retrospective Analysis of Electronic Health Records From an Integrated Health System.Arthritis care & research · 2026Article
- An evaluation of a Bayesian method to track outbreaks of known and novel influenza-like illnesses.Scientific reports · 2026Article
- Predicting Alzheimer's Disease Diagnosis, a Decade or more Years before Onset using the Electronic Health Record and Random Forest Machine Learning Models.medRxiv : the preprint server for health sciences · 2025Article
- Lessons Learned From Building a Data Platform for Longitudinal, Analytical Use Cases and Scaling to 77 German Hospitals: Implementation Report.JMIR medical informatics · 2025Article
- Identifying Transportation Needs in Ophthalmology Clinic Notes Using Natural Language Processing: Retrospective, Cross-Sectional Study.JMIR medical informatics · 2025Article
- Seeing the unseen: uncovering health-related social needs through universal screening at an academic ophthalmology practice.Eye (London, England) · 2025Article
- Incidence of Potentially Inappropriate Prescribing: Longitudinal Investigation of Outpatient EHR Prescriptions.Journal of the American Geriatrics Society · 2025Article
- Review of open-source software for developing heterogeneous data management systems for bioinformatics applications.Bioinformatics advances · 2025Review
- Building a healthcare data warehouse: considerations, opportunities, and challenges.Frontiers in digital health · 2025Review
- Breast Cancer Screening Interval: Effect on Rate of Late-Stage Disease at Diagnosis and Overall Survival.Journal of clinical oncology : official journal of the American Society of Clinical Oncology · 2024Article
- Pediatric Hepatitis C Screening by Maternal Hepatitis C Infection Status During Pregnancy.Journal of the Pediatric Infectious Diseases Society · 2024Article
- Understanding enterprise data warehouses to support clinical and translational research: impact, sustainability, demand management, and accessibility.Journal of the American Medical Informatics Association : JAMIA · 2024Article
- Online Transfer Learning for RSV Case Detection.Proceedings. IEEE International Conference on Healthcare Informatics · 2024Article
- Ambient Ultrafine Particulate Matter and Clinical Outcomes in Fibrotic Interstitial Lung Disease.American journal of respiratory and critical care medicine · 2024Article
- Organizational Breast Cancer Data Mart: A Solution for Assessing Outcomes of Imaging and Treatment.JCO clinical cancer informatics · 2024Article
- ReDWINE: A clinical datamart with text analytical capabilities to facilitate rehabilitation research.International journal of medical informatics · 2023Article
Corrections and comments
PubMed lists nothing against this paper. Absence here is not a guarantee, only a check that was made.
Authors and funding
8 authors.
Funding
Abstract
objectiveAs 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
methodsWe 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.
resultsNeptune 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.
conclusionWe 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.
Indexed as
Identifiers
What OpenQuestion holds
Registered trials
Read under generation 80e0d062 · epoch 390. Bibliography from PubMed, PubMed Central and OpenAlex; grants from NIH RePORTER; trial links from ClinicalTrials.gov; estimates, votes and beliefs from the OpenQuestion graph.