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.
Highlights
Malaria is one of infectious disease spread by a mosquito of the genus Anopheles
Two ETL packages were created for populating data into StageDataMalaria and StageInfoWilayah from spreadsheet data sources
A comprehensive data warehouse is proposed for managing and extracting the salient information about Malaria cases in Tanah Bumbu. This malaria data warehouse is centralized architecture of galaxy or constellation scheme that consists of 3 fact tables and 13 dimension tables
Summary
Malaria is one of infectious disease spread by a mosquito of the genus Anopheles. This animal carries out a plasmodium parasite and spread it into human blood circulation through a bite. The number of malaria incidences in Indonesia has decreased by 2.9% in 2007 to 1.9% in 2013. Contrary to these conditions, the number of cases in West Papua has increased quite sharply in 2013. This area is located in the east part of Indonesia with the most prevalence number above the average [2]. Lack of centralized malaria data all over Indonesia could be the reason as well
Sign-in/Register to view highlights & summary Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callMore From: International Journal of Advanced Computer Science and Applications
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
