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

Evaluation of Regressive Analysis Based Sea Surface Temperature Estimation Accuracy with NCEP/GDAS Data

In order to evaluate the skin surface temperature (SSST) estimation accuracy with MODIS data, 84 of MODIS scenes together with the match-up data of NCEP/GDAS are used. Through regressive analysis, it is found that 0.305...

Modeling of High Speed Free Space Optics System to Maintain Signal Integrity in Different Weather Conditions; System Level

Free space optical (FSO) also known as free space photonics (FSS) is a technology widely deployed in Local Area Network (LAN), Metro Area Network (MAN), and in Inter & Intra chip communications. However satellite to sate...

SEUs Mitigation on Program Counter of the LEON3 Soft Processor

Analyzing and evaluating the sensitivity of embedded systems to soft-errors have always been a challenge for aerospace or safety equipment designer. Different automated fault-injection methods have been developed for eva...

An Algorithm for Summarization of Paragraph Up to One Third with the Help of Cue Words Comparison

In the fast growing information era utility of technology are more precise than completing the assignment manually. The digital information technology creates a knowledge-based society with high-tech global economy which...

Fuzzy Logic Driven Expert System for the Assessment of Software Projects Risk

This paper presents an expert risk evaluation system developed and based on up-to-date empirical study that uses a real data from huge number of software projects to identify the most factors that affect the project succ...

Download PDF file
  • EP ID EP106526
  • DOI 10.14569/IJACSA.2015.061005
  • Views 79
  • 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