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

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

Downloads

Download data is not yet available.
How to Cite
ANDREYANA, Putu Veda; WIDYA, Putu Angelina; SUARTIKA, Made. Designing Data Warehouse at the Impatient and Outpatient (Case Study: Sanglah Hospital). International Journal of Engineering and Emerging Technology, [S.l.], v. 2, n. 1, p. 40-45, sep. 2017. ISSN 2579-5988. Available at: <https://ojs.unud.ac.id/index.php/ijeet/article/view/34448>. Date accessed: 28 mar. 2024.