Department of Health Services Research, Carl Von Ossietzky University of Oldenburg, Campus Haarentor, V4/1/129, Ammerländer Heerstraße 140, 26129, Oldenburg, Germany.
Comprehensive Heart Failure Center and Department of Internal Medicine I, University and University Hospital Würzburg, Würzburg, Germany.
J Digit Imaging. 2023 Apr;36(2):715-724. doi: 10.1007/s10278-022-00727-3. Epub 2022 Nov 23.
This study aims to show the feasibility and benefit of single queries in a research data warehouse combining data from a hospital's clinical and imaging systems. We used a comprehensive integration of a production picture archiving and communication system (PACS) with a clinical data warehouse (CDW) for research to create a system that allows data from both domains to be queried jointly with a single query. To achieve this, we mapped the DICOM information model to the extended entity-attribute-value (EAV) data model of a CDW, which allows data linkage and query constraints on multiple levels: the patient, the encounter, a document, and a group level. Accordingly, we have integrated DICOM metadata directly into CDW and linked it to existing clinical data. We included data collected in 2016 and 2017 from the Department of Internal Medicine in this analysis for two query inquiries from researchers targeting research about a disease and in radiology. We obtained quantitative information about the current availability of combinations of clinical and imaging data using a single multilevel query compiled for each query inquiry. We compared these multilevel query results to results that linked data at a single level, resulting in a quantitative representation of results that was up to 112% and 573% higher. An EAV data model can be extended to store data from clinical systems and PACS on multiple levels to enable combined querying with a single query to quickly display actual frequency data.
本研究旨在展示在结合医院临床和影像系统数据的研究数据仓库中使用单一查询的可行性和益处。我们使用全面整合的生产影像归档和通信系统 (PACS) 与临床数据仓库 (CDW) 进行研究，创建了一个允许联合使用单一查询查询两个领域数据的系统。为此，我们将 DICOM 信息模型映射到 CDW 的扩展实体-属性-值 (EAV) 数据模型，该模型允许在多个级别上进行数据链接和查询约束：患者、就诊、文档和组级别。相应地，我们将 DICOM 元数据直接集成到 CDW 中，并将其链接到现有的临床数据。我们将 2016 年和 2017 年内科收集的数据纳入本分析中，供两名研究人员针对疾病和放射学研究进行两次查询查询。我们使用为每个查询查询编译的单个多级查询获取关于当前临床和影像数据组合可用性的定量信息。我们将这些多级查询结果与仅在单个级别链接数据的结果进行比较，从而以高达 112%和 573%的定量表示结果。EAV 数据模型可以扩展到多个级别存储来自临床系统和 PACS 的数据，以实现使用单一查询进行联合查询，从而快速显示实际频率数据。
