Comprehensive Centralized-Data Warehouse for Managing Malaria Cases
Journal Title: International Journal of Advanced Computer Science & Applications - Year 2015, Vol 6, Issue 10
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
- EP ID EP106526
- DOI 10.14569/IJACSA.2015.061005
- Views 81
- Downloads 0
Rapid Control Prototyping and PIL Co-Simulation of a Quadrotor UAV Based on NI myRIO-1900 Board
In this paper, a new Computer Aided Design (CAD) methodology for the Processor-In-the-Loop (PIL) co-simulation and Rapid Control Prototyping (RCP) of a Quadrotor Vertical Take-Off and Landing (VTOL) type of Unmanned Aria...
The Criteria for Software Quality in Information System: Rasch Analysis
Most of the organization uses information system to manage the information and provide better decision making in order to deliver high quality services. Due to that the information system must be reliable and fulfill the...
Learner Cognitive Behavior and Influencing Factors in Web-based Learning Environment
In educational institutions, to improve student learning outcome and performance, the information and communication technology has enabled us to embark web-based learning approaches. The traditional web-based learning en...
A Compound Generic Quantitative Framework for Measuring Digital Divide
The term digital divide had been used in the literature to conceptualize the gap in using and utilizing information and communication technologies. Digital divide can be identified on different levels such as individuals...
A Review and Proof of Concept for Phishing Scam Detection and Response using Apoptosis
Phishing scam is a well-known fraudulent activity in which victims are tricked to reveal their confidential information especially those related to financial information. There are various phishing schemes such as decept...