Data Warehousing Disease Track Record Historical RSU Dr. Soetomo for Supporting Decision Making

A database for transaction recording system is usually designed and optimized to increase the recording and verification transactions processing, it calls OLTP. RSU Dr. Soetomo only has an OLTP for recording disease track records. This database is difficult to be analyzed and take long processing time because it designs and optimizes for recording facts detail about treatment, such as patient, disease, doctor and others data. Therefore a Star Scheme is designed in our research to support the analyzing disease track record easier and faster. As a result, decisions making for preventive and curative the disease can be done faster. In addition, we develop a prototype for transforming the origin database into Star Scheme and we develop OLAP prototype system. Base on the OLAP prototype evaluations, we conclude that the Star Scheme has well designed. The OLAP database is ready to use for further research.