EUVIMEDEUVIMED entdecken
Open Access · CC BY-NC 4.0

Development of a population based patient cancer data warehouse from multiple electronic health record systems

Karla Siegler iD, Jason Smith iD, Emily Walker, Jingyu Bu, Paula Robson, Lorraine Shack

Health Informatics Journal · 2026-04 · 32 (2)

DOI: 10.1177/14604582261440410 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Health Informatics Journal, online erschienen am 08.05.2026. Verfasst von Karla Siegler und 5 weiteren Autor:innen. Beteiligte Einrichtung: Cancer Advanced Analytics, Health Shared Services, Calgary, AB, Canada. Hauptthemen laut MEDLINE: Electronic Health Records, Neoplasms, Data Warehousing. Die Arbeit nennt 21 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY-NC 4.0).

AbstractSchlagwörterBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

Objective

Cancer is a significant cause of death globally. Effective management requires use of real-world data to inform treatment and planning. This demands improvements in data management to support healthcare delivery, research, and patient outcomes. Electronic health records (EHR) offer a potential solution yet integrating and interpreting the data poses challenges. To address this we developed Data Environment for Cancer Inquiries and Decisions or DECIDe. DECIDe is a cancer data warehouse consolidating patient data from multiple systems in use at Alberta Health Services (AHS).

Methods

DECIDe’s development began with stakeholder engagement and requirements gathering followed by design. The warehouse includes landing, staging, analysis, and reporting schemas that facilitate integration and transformation. Primary EHR, cancer registry, and legacy EHR data were extracted, transformed, and loaded into DECIDe.

Results

DECIDe integrated 2,100+ tables into 36 analysis tables with data from 1,055,186 unique patients. Integration exceeded 93% across all data sources demonstrating robust consolidation. DECIDe’s structured format enables efficient storage, retrieval, and analysis, laying the foundation for comprehensive reporting and analytics.

Conclusion

DECIDe addresses challenges in managing healthcare data, supporting analytics into cancer trends and treatment outcomes. Unique to Canadian healthcare DECIDe provides a comprehensive view of cancer care, enhancing decision-making and research opportunities.

Schlagwörter

MeSH-Schlagwörter (MEDLINE)

Electronic Health RecordsNeoplasmsData WarehousingHumansAlbertaRegistries

Stichwörter der Autor:innen

cancer data warehouseclinical data integrationelectronic health record integrationoncology informatics

Autor:innen und Institutionen

  • Cancer Advanced Analytics, Health Shared Services, Calgary, AB, Canada.
  • University of Alberta School of Public Health, Edmonton, AB, Canada.
  • Cancer Research & Business Partnerships, Cancer Care Alberta, Edmonton, AB, Canada.
  • Cumming School of Medicine, University of Calgary Department of Oncology and Community Health Sciences, Calgary, AB, Canada.

ORCID-Profile: Karla Siegler, Jason Smith

Zitieren

APA

Siegler, K., Smith, J., Walker, E., Bu, J., Robson, P., & Shack, L. (2026). Development of a population based patient cancer data warehouse from multiple electronic health record systems. Health Informatics Journal, 32(2). https://doi.org/10.1177/14604582261440410

Vancouver

Siegler K, Smith J, Walker E, Bu J, Robson P, Shack L. Development of a population based patient cancer data warehouse from multiple electronic health record systems. Health Informatics Journal. 2026;32(2). doi:10.1177/14604582261440410

BibTeX
@article{Siegler2026,
  author = {Siegler, Karla and Smith, Jason and Walker, Emily and Bu, Jingyu and Robson, Paula and Shack, Lorraine},
  title = {Development of a population based patient cancer data warehouse from multiple electronic health record systems},
  journal = {Health Informatics Journal},
  year = {2026},
  volume = {32},
  number = {2},
  doi = {10.1177/14604582261440410}
}
Kostenlos starten →