A MODEL AND IMPLEMENTATION OF ACADEMIC DATA INTEGRATION IN NEAR-REAL TIME USING MESSAGE-ORIENTED MIDDLEWARE TO SUPPORT ANALYSIS OF STUDENT PERFORMANCE IN THE INFORMATION TECHNOLOGY DEPARTMENT OF POLITEKNIK CALTEX RIAU

Yuni Tjung, Ardianto Wibowo, Muhammad Arif Fadhly Ridha

Abstract


Data utilization has effectively contributed for institutions growth by providing insights for managerial purposes. In Information Technology (IT) Department of Politeknik Caltex Riau, information systems were built separately, makes it hard for the head of study program to analyze academic performance. For analytical purposes, there’s a business intelligence developed to equip each head of study programs in IT Department with knowledge about their department. Unfortunately, the business intelligence hasn’t considered with data integration. To solve this problem, this research proposes 2 different academic near-real time data integration model that are documented using Enterprise Integration Pattern and benchmarkes the implementation to obtain best data integration model. The models use Message-Oriented Middleware, a technology that enables asynchronous communication between diverse applications. This research uses WSO2 ESB as the MOM tools in Service-Oriented Architecture (SOA) that use NuSOAP library for helping generating web service WSDL and will use Enterprise Application Integration approach. The testing is conducted based on ISO 9126 aspects: functionality, efficiency, and reliability. Based on the testing results, it can be concluded that both integration models fulfill the functionality and reliability aspects, but the 2nd pattern is more efficient because it distincts message channel and store for each dimension and fact table.

Full Text:

PDF

References


A. P. Sani, “Pengembangan Sistem Business Intelligence untuk Analisis Kinerja Akademik Mahasiswa di Lingkungan Jurusan Teknologi Informasi Politeknik Caltex Riau,” Politeknik Caltex Riau, 2018.

E. Marshila, “Sistem Informasi Apotek Menggunakan Teknologi Enterprise Service Bus ( ESB ) ( Studi Kasus : Apotek Rumbai Sehat ),” J. Aksara Komput. Terap. Politek. Caltex Riau, vol. 2, no. 1, 2013.

I. M. D. J. Sulastra, M. Sudarma, and I. N. S. Kumara, “Pemodelan Integrasi Nearly Real Time Data Warehouse dengan Service Oriented Architecture Untuk Menunjang Sistem Informasi Retail,” Maj. Ilm. Teknol. Elektro, vol. 14, no. 2, p. 11, 2015.

A. A. G. Y. Paramartha, N. K. Kertiasih, and G. R. Dantes, “Integrasi Data Penelitian , Pengabdian kepada Masyarakat , dan Kinerja Dosen di Universitas Pendidikan Ganesha,” Semin. Nas. Vokasi dan Teknol., pp. 314–320, 2016.

A. A. Ali and W. M. Mohamed, “Using a Business Activity Monitoring and SOA for a Real-Time ETL,” Int. J. Comput. Appl., vol. 180, no. 10, pp. 975–8887, 2018.

A. Halevy and J. Ordille, “Data Integration : The Teenage Years,” Artif. Intell., vol. 41, no. 1, pp. 9–16, 2006.

M. A. P. M. Van Den Bosch, M. E. Van Steenbergen, M. Lamaitre, and R. Bos, “A Selection-Method for Enterprise Application,” Perspect. Bus. Informatics Res. 9th Int. Conf. BIR 2010, Rostock Ger. 2010. Proc., vol. 9th Intern, pp. 176–187, 2010.

A. Wibowo, “Problems and Available Solutions on the Stage of Extract, Transform, and Loading in Near Real-Time Data Warehousing (A Literature Study),” 2015 Int. Semin. Intell. Technol. Its Appl. ISITIA 2015 - Proceeding, pp. 345–349, 2015.

I. S. Gracia, A. Wibowo, and I. Muslim, “Rancang Bangun Aplikasi E-commerce dengan Mengotomatisasi Purchase Order (PO) Menggunakan Service Oriented Architecture dan Metode Fast Slow Non (FSN) Analysis,” J. Aksara Komput. Terap., vol. 5, no. 1, 2016.

E. Curry, “Message-Oriented Middleware,” in Middleware for Communication, Q. H. Mahmoud, Ed. Chicester: Wiley, 2004, pp. 1–28.

B. Woolf and G. Hohpe, Enterprise Integration Patterns: Designing, Building, and Deploying Messaging Solutions. Boston: Addison-Wesley, 2004.




DOI: http://dx.doi.org/10.12962/j24068535.v18i1.a898

Refbacks

  • There are currently no refbacks.