Comprehensive Centralized-Data Warehouse for Managing Malaria Cases

Abstract

Tanah Bumbu is one of the most endemic areas in Indonesia for patients diagnosed with malaria diseases. Currently, available malaria case data were stored in disparate sources. Hence, it is difficult for the public health department to quickly and easily gather the useful information for determining strategic actions in tackling these cases. The purpose of this research is to build a data warehouse that integrates all malaria cases from disparate sources. This malaria data warehouse is a centralized architecture of galaxy or constellation scheme that consists of three fact tables and 13 dimension tables. SQL Server Integration Services (SSIS) is utilized to build ETL packages that load data from various sources to stages, dimensions, and fact tables in malaria data warehouse. Finally, a timely report can be generated by extracting the salient information located in malaria data warehouse.

Authors and Affiliations

Nova Diana, Aan Kardiana

Keywords

Related Articles

A Sales Forecasting Model in Automotive Industry using Adaptive Neuro-Fuzzy Inference System(Anfis) and Genetic Algorithm(GA)

Nowadays, Sales Forecasting is vital for any business in competitive atmosphere. For an accurate forecasting, correct variables should be considered. In this paper, we address these problems and a technique is proposed w...

A Method for Designing Domain-Specific Document Retrieval Systems using Semantic Indexing

Using domain knowledge and semantics to con-duct e‡ective document retrieval has attracted great attention from researchers in many di‡erent communities. Ultilizing that approach, we presents the method for designing dom...

PEDAGOGY: INSTRUCTIVISM TO SOCIO-CONSTRUCTIVISM THROUGH VIRTUAL REALITY

Learning theories evolved with time, beginning with instructivism, constructivism, to social constructivism. These theories no doubt were applied in education and they had their effects on learners. Technology advanced,...

Performances Analysis of a SCADA Architecture for Industrial Processes

SCADA (Supervisory Control And Data Acquisition) systems are used to monitor and control various industrial processes, and have been continuously developed in order to incorporate the new technologies from software devel...

Environments and System Types of Virtual Reality Technology in STEM: a Survey

Virtual Reality (VR) technology has been used widely today in Science, Technology, Engineering and Mathematics (STEM) fields. The VR is emerging computer interface distinguished by high degrees of immersion, trustworthy,...

Download PDF file
  • EP ID EP106526
  • DOI 10.14569/IJACSA.2015.061005
  • Views 60
  • Downloads 0

How To Cite

Nova Diana, Aan Kardiana (2015). Comprehensive Centralized-Data Warehouse for Managing Malaria Cases. International Journal of Advanced Computer Science & Applications, 6(10), 40-46. https://europub.co.uk/articles/-A-106526