Decision Support System for Department of Health by using Data Warehouse & OLAP Techniques

Abstract

Since the introduction of computer system, decision support has evolved greatly. Originally computer systems produced paper reports. The emerging technologies of data warehousing and OLAP have changed the way that organization utilize their data. Data Warehousing and OLAP have created a new framework for organizing corporate data, delivering it to business end users, and providing algorithm for more powerful data analysis. The system is analyzed morbidity data to load into a data warehouse. The data are transformed into a data cube in dimension of Time, Disease, Location and Patient. Then, the required data are analyzed by multidimensional OLAP model to provide necessary analysis result to the decision maker.