Academic Journal

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

Λεπτομέρειες βιβλιογραφικής εγγραφής
Τίτλος: Development of a population based patient cancer data warehouse from multiple electronic health record systems.
Συγγραφείς: Siegler, Karla, Smith, Jason, Walker, Emily, Bu, Jingyu, Robson, Paula, Shack, Lorraine
Πηγή: Health Informatics Journal; Apr-Jun2026, Vol. 32 Issue 2, p1-10, 10p
Θεματικοί όροι: Databases, Medical information storage & retrieval systems, Medical informatics, Data management, Privacy, Information storage & retrieval systems, Reporting of diseases, Cancer patients, Electronic data interchange, Electronic health records, Information retrieval, Tumors, Data warehousing, Medical ethics
Γεωγραφικοί όροι: Alberta
Περίληψη: 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. [ABSTRACT FROM AUTHOR]
Copyright of Health Informatics Journal is the property of Sage Publications Inc. and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.)
Βάση Δεδομένων: Complementary Index
FullText Links:
  – Type: other
Text:
  Availability: 0
Header DbId: edb
DbLabel: Complementary Index
An: 194971578
RelevancyScore: 1061
AccessLevel: 6
PubType: Academic Journal
PubTypeId: academicJournal
PreciseRelevancyScore: 1060.75964355469
IllustrationInfo
Items – Name: Title
  Label: Title
  Group: Ti
  Data: Development of a population based patient cancer data warehouse from multiple electronic health record systems.
– Name: Author
  Label: Authors
  Group: Au
  Data: <searchLink fieldCode="AR" term="%22Siegler%2C+Karla%22">Siegler, Karla</searchLink><br /><searchLink fieldCode="AR" term="%22Smith%2C+Jason%22">Smith, Jason</searchLink><br /><searchLink fieldCode="AR" term="%22Walker%2C+Emily%22">Walker, Emily</searchLink><br /><searchLink fieldCode="AR" term="%22Bu%2C+Jingyu%22">Bu, Jingyu</searchLink><br /><searchLink fieldCode="AR" term="%22Robson%2C+Paula%22">Robson, Paula</searchLink><br /><searchLink fieldCode="AR" term="%22Shack%2C+Lorraine%22">Shack, Lorraine</searchLink>
– Name: TitleSource
  Label: Source
  Group: Src
  Data: Health Informatics Journal; Apr-Jun2026, Vol. 32 Issue 2, p1-10, 10p
– Name: Subject
  Label: Subject Terms
  Group: Su
  Data: <searchLink fieldCode="DE" term="%22Databases%22">Databases</searchLink><br /><searchLink fieldCode="DE" term="%22Medical+information+storage+%26+retrieval+systems%22">Medical information storage & retrieval systems</searchLink><br /><searchLink fieldCode="DE" term="%22Medical+informatics%22">Medical informatics</searchLink><br /><searchLink fieldCode="DE" term="%22Data+management%22">Data management</searchLink><br /><searchLink fieldCode="DE" term="%22Privacy%22">Privacy</searchLink><br /><searchLink fieldCode="DE" term="%22Information+storage+%26+retrieval+systems%22">Information storage & retrieval systems</searchLink><br /><searchLink fieldCode="DE" term="%22Reporting+of+diseases%22">Reporting of diseases</searchLink><br /><searchLink fieldCode="DE" term="%22Cancer+patients%22">Cancer patients</searchLink><br /><searchLink fieldCode="DE" term="%22Electronic+data+interchange%22">Electronic data interchange</searchLink><br /><searchLink fieldCode="DE" term="%22Electronic+health+records%22">Electronic health records</searchLink><br /><searchLink fieldCode="DE" term="%22Information+retrieval%22">Information retrieval</searchLink><br /><searchLink fieldCode="DE" term="%22Tumors%22">Tumors</searchLink><br /><searchLink fieldCode="DE" term="%22Data+warehousing%22">Data warehousing</searchLink><br /><searchLink fieldCode="DE" term="%22Medical+ethics%22">Medical ethics</searchLink>
– Name: SubjectGeographic
  Label: Geographic Terms
  Group: Su
  Data: <searchLink fieldCode="DE" term="%22Alberta%22">Alberta</searchLink>
– Name: Abstract
  Label: Abstract
  Group: Ab
  Data: 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. [ABSTRACT FROM AUTHOR]
– Name: Abstract
  Label:
  Group: Ab
  Data: <i>Copyright of Health Informatics Journal is the property of Sage Publications Inc. and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract.</i> (Copyright applies to all Abstracts.)
PLink https://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edb&AN=194971578
RecordInfo BibRecord:
  BibEntity:
    Identifiers:
      – Type: doi
        Value: 10.1177/14604582261440410
    Languages:
      – Code: eng
        Text: English
    PhysicalDescription:
      Pagination:
        PageCount: 10
        StartPage: 1
    Subjects:
      – SubjectFull: Alberta
        Type: general
      – SubjectFull: Databases
        Type: general
      – SubjectFull: Medical information storage & retrieval systems
        Type: general
      – SubjectFull: Medical informatics
        Type: general
      – SubjectFull: Data management
        Type: general
      – SubjectFull: Privacy
        Type: general
      – SubjectFull: Information storage & retrieval systems
        Type: general
      – SubjectFull: Reporting of diseases
        Type: general
      – SubjectFull: Cancer patients
        Type: general
      – SubjectFull: Electronic data interchange
        Type: general
      – SubjectFull: Electronic health records
        Type: general
      – SubjectFull: Information retrieval
        Type: general
      – SubjectFull: Tumors
        Type: general
      – SubjectFull: Data warehousing
        Type: general
      – SubjectFull: Medical ethics
        Type: general
    Titles:
      – TitleFull: Development of a population based patient cancer data warehouse from multiple electronic health record systems.
        Type: main
  BibRelationships:
    HasContributorRelationships:
      – PersonEntity:
          Name:
            NameFull: Siegler, Karla
      – PersonEntity:
          Name:
            NameFull: Smith, Jason
      – PersonEntity:
          Name:
            NameFull: Walker, Emily
      – PersonEntity:
          Name:
            NameFull: Bu, Jingyu
      – PersonEntity:
          Name:
            NameFull: Robson, Paula
      – PersonEntity:
          Name:
            NameFull: Shack, Lorraine
    IsPartOfRelationships:
      – BibEntity:
          Dates:
            – D: 01
              M: 04
              Text: Apr-Jun2026
              Type: published
              Y: 2026
          Identifiers:
            – Type: issn-print
              Value: 14604582
          Numbering:
            – Type: volume
              Value: 32
            – Type: issue
              Value: 2
          Titles:
            – TitleFull: Health Informatics Journal
              Type: main
ResultId 1