International Journal of Engineering and Emerging Technology
Vol 2 No 1 (2017): January - June

Designing Data Warehouse at the Impatient and Outpatient (Case Study: Sanglah Hospital)

Putu Veda Andreyana (Department of Electrical and Computer Engineering, Post Graduate Program, Udayana University)
Putu Angelina Widya (Department of Electrical and Computer Engineering, Post Graduate Program, Udayana University)
Made Suartika (Department of Electrical and Computer Engineering, Udayana University)



Article Info

Publish Date
23 Sep 2017

Abstract

The growth of patient data increasing the hospital resulted in even harder to compile data and analyze the data manually, so it takes a data warehouse that can perform this task automatically. The design of the data warehouse Sanglah hospital aims to build a data warehouse that can store data in structured and easier to analyze the data to make a decision. Design methods Fact Constellation Schema and method used is a Nine-step methodology consisting of nine stages, namely the Electoral Process, Selection of Grain, identification and adjustment of the dimensions, the Electoral Facts, Storage pre-calculation in the fact table, Ensuring the dimension tables, the Electoral duration database, Track changes of dimensions is slowly, prioritization and query model. Designing Data Warehouse Sanglah Hospital helpful enough for data processing in large enough quantities, so expect the needs and information about the patient can be met. Data warehouse Sanglah Hospital can be used to analyze patient data in order to get information on the number of patients of various dimensions

Copyrights © 2017






Journal Info

Abbrev

ijeet

Publisher

Subject

Civil Engineering, Building, Construction & Architecture Computer Science & IT Electrical & Electronics Engineering Mechanical Engineering

Description

International Journal of Engineering and Emerging Technology is the biannual official publication of the Doctorate Program of Engineering Science, Faculty of Engineering, Udayana University. The journal is open to submission from scholars and experts in the wide areas of engineering, such as civil ...