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

TokenVote: Secured Electronic Voting System in the Cloud

With the spread of democracy around the world, voting is considered a way to collectively make decisions. Recently, many government offices and private organizations use voting to make decisions when the opinions of mult...

A Robust Audio Watermarking Technique Operates in MDCT Domain based on Perceptual Measures

the review presents a digital audio watermarking technique operating in the frequency domain with two variants. This technique uses the Modified Discrete Cosine Transform (MDCT) to move to the frequency domain. To ensure...

A Novel Scheme for Address Assignment in Wireless Sensor Networks

Assigning network addresses to nodes in a wireless sensor network is a crucial task that has implications for the functionality, scalability, and performance of the network. Since sensor nodes generally have scarce resou...

The Apsidal Precession for Low Earth Sun Synchronized Orbits

By nodal regression and apsidal precession, the Earth flattering at satellite low Earth orbits (LEO) is manifested. Nodal regression refers to the shift of the orbit’s line of nodes over time as Earth revolves around the...

Applying Floyd’s Inductive Assertions Method for Verification of Generalized Net Models Without Temporal Components

Generalized Nets are extensions of Petri Nets. They are a suitable tool for describing real sequential and parallel processes in different areas. The implementation of correct Generalized Nets models is a task of great i...

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