On-line Analytical Processing (OLAP) Operation for Outpatient Healthcare

  • Talib M. J. Al Taleb College of Information Engineering, Al-Nahrain University, Baghdad, Iraq.
  • Sami Hasan College of Information Engineering, Al-Nahrain University, Baghdad, Iraq.
  • Yaqoob Yousif Mahd College of Information Engineering, Al-Nahrain University, Baghdad, Iraq.
Keywords: Data Cubes, Data warehouse (Star schema), OLAP

Abstract

This paper presents an architecture for the data warehouse of outpatient healthcare (DWOP) as a data repository collects data from two different sources (Databases of outpatient healthcare and Excel files from hospitals) and provides storage, functionality and responsiveness to queries to meet decision makers requirements.
Successfully supporting managerial decision-making is critically dependent upon the availability of integrated, high quality information organized and presented in a timely and easily understood manner. “On-Line Analytical Processing (OLAP) is utilized for decision support to get interesting information†from the data warehouse with a rapid execution time. OLAP is considered one of Business Intelligence tools.

Published
2021-01-14
How to Cite
Talib M. J. Al Taleb, Sami Hasan, & Yaqoob Yousif Mahd. (2021). On-line Analytical Processing (OLAP) Operation for Outpatient Healthcare. Iraqi Journal of Science, 225-231. https://doi.org/10.24996/ijs.2021.SI.1.32