Open AccessImplementing an ETL-driven Data Integration Framework for State Universities and Colleges
Author(s) -
Lorna T. Soriano,
Josephine S. Dela Cruz
Publication year - 2020
Publication title -
iop conference series. materials science and engineering
Language(s) - English
Resource type - Journals
eISSN - 1757-899X
pISSN - 1757-8981
DOI - 10.1088/1757-899x/803/1/012041
Subject(s) - process (computing) , computer science , data integration , data warehouse , state (computer science) , usability , transactional leadership , order (exchange) , process management , system integration , data science , engineering management , database , software engineering , knowledge management , engineering , business , political science , operating system , public relations , finance , algorithm
State Universities and Colleges collect enormous volumes of data scattered across multiple disparate transactional systems. Integration of these data is therefore vital in order to eliminate problems in consolidating and interpreting such data. This paper aimed to develop and implement a data integration framework that employs an ETL-driven data warehousing technique for State Universities and Colleges (SUCs). Moreover, the framework was implemented and tested using heterogeneous data of the Bicol State College of Applied Sciences and Technology (BISCAST), one of the state colleges in Region 5, Philippines. Consequently, the integration framework has been found to be effective in streamlining the process of consolidating and interpreting SUC’s data thus enabling the organization to produce reliable reports and eventually can cope with submission deadlines. A reporting tool was also developed for end-users to generate and view the outcome of the integration process. Furthermore, the level of the system’s usability was determined. Based on the result, it is effective in accomplishing specific tasks, highly efficient and commendable to adopt.