Data Warehouse Information Management System Rsu Dr. Soetomo For Supporting Decision Making

Dr. Soetomo General Hospital (RSU Dr. Soetomo) in Surabaya has computerized their administration system base on the Indonesian Health Department standard. It calls Sistem Informasi Rumah Sakit (SIRS) and it only generates structured information. So far, SIRS can not generate unstructured information for supporting decisions making.
Due to the problem, this research focuses on develop Data Warehouse and Online Analytical Process (OLAP) Tools for supporting decision making about inpatient, payment, and surgery. The Application includes a transformation process from SIRS database into OLAP Warehouse database, and processing OLAP Warehouse database into multidimensional pivot table, and generating graphics. The application was developed using Oracle 9i as the database and Net Beans 5.5 as programming language.