Article Per Year (5 Year)
p-Index From 2020 - 2025
0.23
P-Index
This Author published in this journals
All Journal Kesatria : Jurnal Penerapan Sistem Informasi (Komputer dan Manajemen)
Simanjuntak, Yohanes Albryan
Unknown Affiliation
Computer Science & IT Control & Systems Engineering

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

 1 
Optimalisasi Database Mysql Pada Sistem Perancangan Sistem Housekeeping Transaction History Dengan Pentaho Data Integration Simanjuntak, Yohanes Albryan; Wowor, Alz Danny
Kesatria : Jurnal Penerapan Sistem Informasi (Komputer dan Manajemen) Vol 6, No 1 (2025): Edisi Januari
Publisher : LPPM STIKOM Tunas Bangsa

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.30645/kesatria.v6i1.542

Abstract

The volume of transaction data in the banking industry is growing with the increase in customers and transaction complexity. Ineffi-cient data management can lead to server overload, affect system performance, and hinder the delivery of fast, accurate services. Housekeeping processes are needed to move inactive data to sepa-rate storage, allowing the main server to function more efficiently. Pentaho Data Integration (PDI) offers an effective solution for man-aging the ETL (Extract, Transform, Load) process, which is crucial for data housekeeping. This research aims to optimize the manage-ment of banking transaction data using PDI to reduce server load and improve operational efficiency. This quantitative study applies an experimental method, with the ETL process managing Bank XYZ’s transaction data older than six months. The study uses trans-action data from Bank XYZ’s MySQL server, which will be trans-ferred to a data warehouse. The analysis applies clustering algo-rithms to filter and separate active from inactive transactions. The implementation of PDI for housekeeping effectively reduces server load and improves data management efficiency, significantly lower-ing processing time. The combined use of clustering algorithms and PDI delivers substantial improvements in managing banking transac-tion data, enhancing operational efficiency while significantly re-ducing the load on the main server
Co-Authors Alz Danny Wowor