The technology of using a data warehouse to support decision-making in health care

TL;DR

This paper discusses how healthcare data warehouses, combined with OLAP tools, enhance decision-making for cancer care by providing faster, multi-perspective data analysis without disrupting daily operations.

Contribution

It introduces a healthcare data warehouse framework with OLAP capabilities tailored for cancer decision support, demonstrating improved data analysis efficiency.

Findings

Faster decision-making with reduced query times.

Multi-dimensional data analysis enhances insight.

Application example shows practical utility.

Abstract

This paper describes the technology of data warehouse in healthcare decision-making and tools for support of these technologies, which is used to cancer diseases. The healthcare executive managers and doctors needs information about and insight into the existing health data, so as to make decision more efficiently without interrupting the daily work of an On-Line Transaction Processing (OLTP) system. This is a complex problem during the healthcare decision-making process. To solve this problem, the building a healthcare data warehouse seems to be efficient. First in this paper we explain the concepts of the data warehouse, On-Line Analysis Processing (OLAP). Changing the data in the data warehouse into a multidimensional data cube is then shown. Finally, an application example is given to illustrate the use of the healthcare data warehouse specific to cancer diseases developed in this study. The executive managers and doctors can view data from more than one perspective with reduced query time, thus making decisions faster and more comprehensive.