ETL-based framework for organizing data on maternal and child mortality and related indicators
Date of Publication
2016
Document Type
Master's Thesis
Degree Name
Master of Science in Information Technology
Subject Categories
Computer Sciences
College
College of Computer Studies
Department/Unit
Information Technology
Thesis Adviser
Estefanie D. Ulit
Defense Panel Chair
Marivic S. Tangkeko
Defense Panel Member
Estefanie D. Ulit
Abstract/Summary
This thesis created a framework on how data can be organized using concepts on extraction, transformation and loading of information products into a knowledge-based repository. Research shows that reducing maternal and child morality, one of the UN's millennium development goals (MDGs), is a continuing problem in the Philippines partly due to incoherence of data used by decision makers on maternal health and child care (MHCC) programs. The framework seeks to address the problem by adopting ICT to organize the data as knowledge resource for MHCC. In creating the framework, process models were used to analyze sample datasets from the DOH, USAID, Philippine Statistics Office and reports from WHO, UNICEF, UNFPA, and the World Bank. Based on the analysis, the framework which contains three phases was implemented with ICT following technology review on Talend Open Studio for data integration, Qlik View and QGIS for visualization, and Drupal for content management. To validate the framework, a prototype was presented to key informants on MHCC and to ICT experts to gather feedback wherein critical success factors were identified such as collecting data with low dissaggregation, new indicators for MHCC, streamlined business intelligence with comprehensive GPS data, and strategic presentation of information products through cross tabulation. Validation results show that data organization techniques can be improved with knowledge-based system interoperable with those of the DOH such as monitoring & evaluation and referral system. Furthermore, the framework and results of the study form a blueprint on ICT adoption and formulation of policy for developing knowledge-based systems for monitoring the upcoming sustainable development goals (SDGs) for the next fifteen years.
Abstract Format
html
Language
English
Format
Electronic
Accession Number
CDTG006415
Shelf Location
Archives, The Learning Commons, 12F Henry Sy Sr. Hall
Physical Description
xi, 182 leaves, illustrations (some color), 30 cm. ; 1 computer optical disc ; 4 3/4 in.
Keywords
Expert systems (Computer science); Quantitative research; Maternal and infant welfare; Maternal health services; Child health services
Recommended Citation
Gomez, E. B. (2016). ETL-based framework for organizing data on maternal and child mortality and related indicators. Retrieved from https://animorepository.dlsu.edu.ph/etd_masteral/5136