registry event log warehouse: toward designing a care process digital twin

Introduction: many data warehouses (dws) developed for the healthcare field only represent subject-oriented data without addressing the control flow. each process includes many ordered specific activities, which cannot be represented by dws. this limitation, next to the need to find correlations between case and activity attributes in our health data, motivates the extension of a registry event log warehouse (rewh). since the disease registry is saturated with valuable, critical data on human life and supports clinicians and professionals in their decision-making and patient monitoring, the present study aimed to develop a twin digital for trauma care as part of our overall work. because the process warehouse is the first step in designing the trauma warehouse digital twin, the focus is developing a registry process warehouse.methods: the methodology comprises the following steps: 1) data gathering, 2) data preprocessing, 3) data entry to cube, and 4) conducting queries. the primary contribution of this work is to demonstrate how to gather heterogeneous data extracted from different sources into a single process-oriented repository and express online analytical processing (olap) queries through sql to promote data filtering and aggregation.results: a top-bottom dimensional schemas of a process warehouse that support detailed process analysis, with each level represented by a specific granularity level.conclusion: due to its ability to provide data of interest for all components of the digital twins, the dw is one of the primary components of healthcare digital twins. the multilevel analysis presented in this study, utilizing olap tools, can assist easy access to specific information from process warehouse dimensions almost instantly.