Case study

Architecture and Implementation of a Clinical Research Data Warehouse for Prostate Cancer

Authors: {'first_name': 'Martin G.', 'last_name': 'Seneviratne'},{'first_name': 'Tina', 'last_name': 'Seto'},{'first_name': 'Douglas W.', 'last_name': 'Blayney'},{'first_name': 'James D.', 'last_name': 'Brooks'},{'first_name': 'Tina', 'last_name': 'Hernandez-Boussard'}


Background: Electronic health record (EHR) based research in oncology can be limited by missing data and a lack of structured data elements. Clinical research data warehouses for specific cancer types can enable the creation of more robust research cohorts.

Methods: We linked data from the Stanford University EHR with the Stanford Cancer Institute Research Database (SCIRDB) and the California Cancer Registry (CCR) to create a research data warehouse for prostate cancer. The database was supplemented with information from clinical trials, natural language processing of clinical notes and surveys on patient-reported outcomes.

Results: 11,898 unique prostate cancer patients were identified in the Stanford EHR, of which 3,936 were matched to the Stanford cancer registry and 6153 in the CCR. 7158 patients with EHR data and at least one of SCIRDB and CCR data were initially included in the warehouse.

Conclusions: A disease-specific clinical research data warehouse combining multiple data sources can facilitate secondary data use and enhance observational research in oncology.


Keywords: Electronic Health RecordsQuality ImprovementData Collection 

Galley file missing.

Please contact support [at]