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

Verifying Weak Probabilistic Noninterference

Weak probabilistic noninterference is a security property for enforcing confidentiality in multi-threaded programs. It aims to guarantee secure flow of information in the program and ensure that sensitive information doe...

Automatic Cyberbullying Detection in Spanish-language Social Networks using Sentiment Analysis Techniques

Cyberbullying is a growing problem in our society that can bring fatal consequences and can be presented in digital text for example at online social networks. Nowadays there is a wide variety of works focused on the det...

Developing Communication Strategy for Multi-Agent Systems with Incremental Fuzzy Model

Communication can guarantee the coordinated behavior in the multi-agent systems. However, in many real-world problems, communication may not be available at every time because of limited bandwidth, noisy environment or c...

Key Schedule Algorithm using 3-Dimensional Hybrid Cubes for Block Cipher

A key scheduling algorithm is the mechanism that generates and schedules all session-keys for the encryption and decryption process. The key space of conventional key schedule algorithm using the 2D hybrid cubes is not e...

A Survey of Big Data Analytics in Healthcare

Debate on big data analytics has earned a remarkable interest in industry as well as academia due to knowledge, information and wisdom extraction from big data. Big data and cloud computing are two most important trends...

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