Background: Due to the importance of radiologic examinations, such as X-rays or computed tomography scans, for many clinical diagnoses, the optimal use of the radiology department is 1 of the primary goals of many hospitals.
Objective: This study aims to calculate the key metrics of this use by creating a radiology data warehouse solution, where data from radiology information systems (RISs) can be imported and then queried using a query language as well as a graphical user interface (GUI).
Methods: Using a simple configuration file, the developed system allowed for the processing of radiology data exported from any kind of RIS into a Microsoft Excel, comma-separated value (CSV), or JavaScript Object Notation (JSON) file. These data were then imported into a clinical data warehouse. Additional values based on the radiology data were calculated during this import process by implementing 1 of several provided interfaces. Afterward, the query language and GUI of the data warehouse were used to configure and calculate reports on these data. For the most common types of requested reports, a web interface was created to view their numbers as graphics.
Results: The tool was successfully tested with the data of 4 different German hospitals from 2018 to 2021, with a total of 1,436,111 examinations. The user feedback was good, since all their queries could be answered if the available data were sufficient. The initial processing of the radiology data for using them with the clinical data warehouse took (depending on the amount of data provided by each hospital) between 7 minutes and 1 hour 11 minutes. Calculating 3 reports of different complexities on the data of each hospital was possible in 1-3 seconds for reports with up to 200 individual calculations and in up to 1.5 minutes for reports with up to 8200 individual calculations.
Conclusions: A system was developed with the main advantage of being generic concerning the export of different RISs as well as concerning the configuration of queries for various reports. The queries could be configured easily using the GUI of the data warehouse, and their results could be exported into the standard formats Excel and CSV for further processing.
Download full-text PDF |
Source |
|---|---|
| http://www.ncbi.nlm.nih.gov/pmc/articles/PMC10242501 | PMC |
| http://dx.doi.org/10.2196/41808 | DOI Listing |
Publication Analysis
Top Keywords
Similar Publications
Functional Responses of the Warehouse Pirate Bug (Reuter) (Hemiptera: Anthocoridae) on a Diet of (Pearman) (Psocodea: Liposcelididae).
Insects
January 2025
Department of Statistics, Oklahoma State University, 301 Mathematics, Statistics and Computer Sciences, Stillwater, OK 74078, USA.
Psocids are difficult to manage using grain protectants and phosphine hence research on non-chemical control methods. This study evaluated the effectiveness of (Reuter) (Hemiptera: Anthocoridae) at managing (Pearman) (Psocodea: Liposcelididae). The functional responses of adult♀ and nymphs of on a diet of nymphs, adult♂, and adult♀ of were determined under laboratory conditions at 28 ± 1 °C, 63 ± 5% RH, and a 0:24 (L:D) photoperiod.
View Article and Find Full Text PDFSnowflake Data Warehouse for Large-Scale and Diverse Biological Data Management and Analysis.
Genes (Basel)
December 2024
RIKEN BioResource Research Center, 3-1-1 Koyadai, Tsukuba 305-0074, Japan.
With the increasing speed of genomic, transcriptomic, and metagenomic data generation driven by the advancement and widespread adoption of next-generation sequencing technologies, the management and analysis of large-scale, diverse data in the fields of life science and biotechnology have become critical challenges. In this paper, we thoroughly discuss the use of cloud data warehouses to address these challenges. Specifically, we propose a data management and analysis framework using Snowflake, a SaaS-based data platform.
View Article and Find Full Text PDFComparing Statistical and Machine Learning Methods for Time Series Forecasting in Data-Driven Logistics-A Simulation Study.
Entropy (Basel)
December 2024
Department of Statistics, TU Dortmund University, 44227 Dortmund, Germany.
Many planning and decision activities in logistics and supply chain management are based on forecasts of multiple time dependent factors. Therefore, the quality of planning depends on the quality of the forecasts. We compare different state-of-the-art forecasting methods in terms of forecasting performance.
View Article and Find Full Text PDFReceipt of medications for opioid use disorder among rural and urban veterans health administration patients.
Drug Alcohol Depend Rep
March 2025
Center to Improve Veteran Involvement in Care, VA Portland Health Care System, 3710 SW US Veterans Hospital Rd, Portland, OR 97239, United States.
Aim: We examined differences in medications for opioid use disorder (MOUD) receipt between rural and urban veteran patients following initiatives within the US Department of Veterans Affairs (VA) to expand access to MOUD.
Methods: Data for this retrospective cohort study were obtained from the VA Corporate Data Warehouse, which contains national electronic health record data for all VA patients. The analytic sample included all patients diagnosed with OUD from 10/1/2018-9/30/20.
Combining a Risk Factor Score Designed From Electronic Health Records With a Digital Cytology Image Scoring System to Improve Bladder Cancer Detection: Proof-of-Concept Study.
J Med Internet Res
January 2025
Univ Rennes, CHU Rennes, INSERM, LTSI - UMR 1099, F-35000 Rennes, France.
Background: To reduce the mortality related to bladder cancer, efforts need to be concentrated on early detection of the disease for more effective therapeutic intervention. Strong risk factors (eg, smoking status, age, professional exposure) have been identified, and some diagnostic tools (eg, by way of cystoscopy) have been proposed. However, to date, no fully satisfactory (noninvasive, inexpensive, high-performance) solution for widespread deployment has been proposed.
View Article and Find Full Text PDFWant AI Summaries of new PubMed Abstracts delivered to your In-box?
Enter search terms and have AI summaries delivered each week - change queries or unsubscribe any time!