Claim Missing Document
Check
Articles

Found 1 Documents
Search
Journal : Jurnal Teknik Informatika (JUTIF)

PERFORMANCE ANALYSIS OF EXTRACT, TRANSFORM, AND LOAD METHODS FOR BUSINESS INTELLIGENCE IN E-LEARNING SYSTEMS USING PENTAHO DATA INTEGRATION Saputra, Aulia Kukuh; Laksitowening, Kusuma Ayu; Herdiani, Anisa
Jurnal Teknik Informatika (Jutif) Vol. 6 No. 1 (2025): JUTIF Volume 6, Number 1, February 2025
Publisher : Informatika, Universitas Jenderal Soedirman

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.52436/1.jutif.2025.6.1.4173

Abstract

The rapid adoption of Learning Management Systems (LMS) in higher education has resulted in the generation of large and complex datasets, posing significant challenges for efficient data integration and analysis. The urgency to address these challenges is driven by the growing demand for real-time analytics and data-driven decision-making in educational institutions. This study advances the field of computer science by evaluating and comparing the performance of three Extract, Transform, and Load (ETL) methods—Table Output, Sync After Merge, and Switch Case—using Pentaho Data Integration (PDI). The study introduces novel insights into ETL optimization techniques, focusing on execution time as the primary metric, critical for ensuring timely and reliable insights in Business Intelligence (BI) systems. Performance testing was conducted with synthetic datasets ranging from 150 to 1,000,000 records across five scenarios: data addition, synchronization, insertion, deletion, and combined operations. Results reveal that Sync After Merge outperformed other methods, achieving up to 35% faster execution times, particularly with large datasets. These findings contribute significantly to the advancement of data integration techniques in computer science, enabling institutions to optimize their BI systems, enhance system responsiveness, and support data-driven decision-making processes effectively. The research provides valuable insights for developing scalable ETL solutions in educational technology systems.
Co-Authors Ade Romadhony Adila , Ahmad Fasya Agus Kusnayat Alfian Yulianto Amanda Putri Septiani Andy Satria Aniq Rohmawati Aprillia Rizki Adiati Aristyo Hadikusuma Aryasatya Okta Pradhana Asep Aprianto Ati Suci Dian Martha Aufa Bil Ahdi P Bastomy Bastomy Bety Elysabeth Pasaribu Briliand, Diaz Wahyu Dadang Setiawan Daffa Dhiya Ulhaq Dana Sulistyo Kusumo Danang Junaedi David Winalda Dawam Dwi Jatmiko Suwawi Dhiyaul Haq, Rafif Zhafir Dimas Ikhsanu Fitra Dimitri Mahayana Diyas Puspandari Emil R. Kaburuan Erdiansyah, Muhammad Farras Erlina Wahyu Fadhilah erna febriyanti Fajri, Fikri Muhammad Farah Rahmadiani Gede Agung Ary Wisudiawan Hanifah, Wardah Heri Setyo Nugroho HNW Syahuda Nahatmasuni Ibnu Asror Ika Rahayu Ponilan Imelda Atastina Indra Lukmana Sardi Indriani Mentaruk Intan Widya Rahayu Irvan Dwi Putra Manurung Jahtra Genio Muhammad Jatmiko, Dawam Dwi Junaedi , Danang Kemas Muslim Lhaksmana Kemas Rahmat Saleh Wiharja Laksitowening, Kusuma Ayu Lintani Afina Hajar Raudhoti Lulu Alfi’a Rahma Ningsih Luthfi Shidqi Made Diva Prasetya Martania Triana Dewi Mochammad Fitrah Eka Pramudita Mohammad Yasin Abdul Hafidh Monterico Adrian Muhamad Fauzan Putra Muhammad Arifino Setyawan Muhammad Faris Adri Azka Muhammad Hanafiah Muhammad Husein Adnan Muhammad Johan Alibasa Muhammad Reza Rahmawan Muhammad Rizky Riandi Gunaedi Nadine Azhalia Purbani Nungki Selviandro Nur Muhammad Putra Setiadi Nurmasyitah Nurmasyitah Pasha, Zaky Mahfudz Puput Fajriati Tri S Raginda Firdaus Ridea Valentini Peristiwari Siwabessy Rizaldy Arigi Rizky Dhian Syarif Rizky Wahyu Kurniawati Rizky Wira Pranata Rosa Reska Riskiana Sakti Dewantoro Saputra, Aulia Kukuh Shinta Yulia Puspitasari Sri Martini Tiara Fitri Berlian Trysha Cintantya Dewi Veronikha Effendy Warih Maharani Widi Astuti Widowati , Sri Yodie Dalyono Yogi Putra Prastiawan Yuni Dwiyanti Yusep Rosmansyah Zaid Mukhtar ZK Abdurahman Baizal