ETL-based framework for organizing data on maternal and child mortality and related indicators

Date of Publication


Document Type

Master's Thesis

Degree Name

Master of Science in Information Technology

Subject Categories

Computer Sciences


College of Computer Studies


Information Technology

Thesis Adviser

Estefanie D. Ulit

Defense Panel Chair

Marivic S. Tangkeko

Defense Panel Member

Estefanie D. Ulit


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






Accession Number


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.


Expert systems (Computer science); Quantitative research; Maternal and infant welfare; Maternal health services; Child health services

This document is currently not available here.