An ETL-Driven Approach Data Integration for State Universities and Colleges

Lorna T. Soriano and Dr. Josephine S. Dela Cruz

State Universities and Colleges (SUCs) are often data-driven wherein their decision-making is based on available and sound data. They are tasked to prepare and submit accomplishment and performance reports based on the agreed targets and indicators, which are dynamic in nature, set by the different government line agencies. Since these reports involve voluminous data coming from diverse sources, different databases and files, the SUCs encounter problems in accessing, consolidating, and accurately interpreting such data. This further result to difficulty in generating reliable reports, delays in complying with government submission, and wastage on resources. This paper aims to develop a framework for integrating data from different sources in State Universities and Colleges (SUCs). The proposed framework utilized warehousing technique due to the current status of institution's data management wherein delivery units require specific customary portion of the available data, efficient query processing but not demanding for data update, and access to independent copies of data for modification or summary purposes. Moreover, ETL approach was employed since it provides a systematic procedure for accessing and manipulating source data into the target database. The proposed framework was verified through simulation using data sources in the Bicol State College of Applied Sciences and Technology, one of the SUCs in Region V, Philippines. The result reveals that ETL-driven approach is effective in integrating data from heterogeneous and disjoined sources of SUCs thus facilitating the generation of reliable reports and on-time submission of reportorial requirements.

Volume 12 | 01-Special Issue

Pages: 234-242

DOI: 10.5373/JARDCS/V12SP1/20201068