A Model and Implementation of Academic Data Integration in Near-Real Time Using Message-Oriented Middleware to Support Analysis of Student Performance in Information Technology Department of Politeknik Caltex Riau

A Model and Implementation of Academic Data Integration in Near-Real Time Using Message-Oriented Middleware to Support Analysis of Student Performance in Information Technology Department of Politeknik Caltex Riau Yuni Primary Author 1557301103 Additional Author mixed material bibliography Pekanbaru Pustaka Politeknik Caltex Riau 2019 en English xiii, 83 hlm.; 21 cm Data utilization has effectively contributed for institutions growth by providing insights for managerial purposes. In Information Technology (IT) Department of Politeknik Caltex Riau, there’s a business intelligence system developed to each head of study programs in IT Department with sufficient knowledge. Unfortunately, information systems were built separately, and the BI system hasn’t considered with data integration. To solve this problem, this research proposes 2 different academic near-real time data integration model and benchmarkes the implementation to obtain best data integration model. This research uses WSO2 ESB as the MOM tools in ServiceOriented Architecture that use NuSOAP library for generating web service WSDL and uses Enterprise Application Integration approach. The testing is conducted based on ISO 9126 aspects: functionality, efficiency, and reliability. Based on the testing results, both integration models meet the functionality aspect by having functionality score equal to 1. For reliability aspect, the integration models meet the requirement by scored 0. For the efficiency aspect, the 2nd pattern yielded faster response time than 1st pattern (10 out of 11 test cases). It can be concluded that both integration models fulfill the functionality and reliability aspects, but the 2nd pattern is more efficient because of the distinction of message channel and store for each dimension and fact table. Keywords: Data Integration, Near-Real Time ETL, Message-Oriented Middleware, Service-Oriented Architecture PA Sistem Informasi PA SI Politeknik Caltex Riau Politeknik Caltex Riau PA SI PA1557301103 Perpustakaan PCR (R) Poster - A Model and Implementation of Academic Data Integration in Near-Real Time Using Message-Oriented Middleware to Support Analysis of Student Performance in Information Technology Department of Politeknik Caltex Riau Video - A Model and Implementation of Academic Data Integration in Near-Real Time Using Message-Oriented Middleware to Support Analysis of Student Performance in Information Technology Department of Politeknik Caltex Riau 11029 2019-08-30 00:00:00 2019-11-20 10:57:50 machine generated