Data Mining Framework for EDC Terminal Repair Protocol: Combining Apriori and PrefixSpan

Authors

  • Suwandhy Praharto Pradita University, Indonesia
  • Handri Santoso Pradita University, Indonesia

DOI:

10.33395/sinkron.v9i2.14759

Keywords:

Apriori, Association Rule Mining, Data Mining, EDC Repair, PrefixSpan, Repair Protocols, Sequential Pattern Mining

Abstract

Electronic Data Capture (EDC) terminals are vital for financial transactions, but their repair processes often lack standardization, causing inefficiencies. Data mining techniques like Association Rule Mining (ARM) and Sequential Pattern Mining (SPM) can extract hidden patterns from service logs to inform maintenance strategies. This research addresses the limited use of these techniques within Electronic Data Capture (EDC) repair centers. Specifically, it applies Association Rule Mining (ARM) using the Apriori algorithm, and Sequential Pattern Mining (SPM) using the PrefixSpan algorithm, to optimize repair protocols based on historical repair data from PT. XYZ Indonesia. The study aimed to discover frequent fault-action-component associations and repair sequences to formulate standardized procedures. A quantitative case study analyzed 56,629 repair transactions. After data cleaning and transformation, Apriori (evaluated by support, confidence, lift) mined association rules, while PrefixSpan found frequent sequential patterns (evaluated by minimum support). Several high-confidence rules emerged: "Battery Not Charging" almost always led to "Replace Battery Pack" (≈95% confidence, lift ≈6.0), and error "2000000" (tamper indication) strongly correlated with detampering procedures and internal battery replacement (≈96% confidence, lift ≈4.9). PrefixSpan uncovered consistent repair sequences, including length-3 patterns for complex issues, with "Replace CMOS → Reinstall OS" for error "7FFFFF" being a prominent shorter sequence. Integrating these data-driven patterns into protocols and aligning inventory can improve service efficiency, reduce repair time, and enhance EDC reliability.

GS Cited Analysis

Downloads

Download data is not yet available.

References

Aggarwal, H., Kumar, V., & Arora, H. D. (2023). Data mining algorithm based on Renyi fuzzy association rule: An application for the selection of suitable course. Research in Statistics, 1(1), 2271902. https://doi.org/10.1080/27684520.2023.2271902

Al-Refaie, A., & Hamdieh, M. (2023). A data mining framework to predict the sequential pattern of maintenance activities and spare parts. Journal of Quality in Maintenance Engineering, 29(3), 697-718. https://doi.org/10.1108/JQME-06-2022-0056

Bai, Y., Li, H., Wang, W., Liu, S., Zhang, N., & Zhang, C. (2024). Optimization algorithm of Association Rule Mining for heavy-haul railway freight train Fault data based on distributed parallel computing. Science Progress, 107(4), 00368504241301181. https://doi.org/10.1177/00368504241301181

Esteban, A., Zafra, A., & Ventura, S. (2023). Data mining in predictive maintenance systems: A taxonomy and systematic review. Wiley Interdisciplinary Reviews: Data Mining and Knowledge Discovery, 13(1), e1471. https://doi.org/10.1002/widm.1471

Figueiredo, L. E. N., Caetano, I., & Almeida, V. (2022). A fault management preventive maintenance approach in mobile networks using sequential pattern mining. In Proceedings of the 19th International Conference on Wireless Networks and Mobile Systems (WINSYS) (pp. 77–85). SCITEPRESS – Science and Technology Publications. https://doi.org/10.5220/0011371900003281

Fournier-Viger, P. (n.d.). The PrefixSpan Algorithm Documentation. Retrieved May 6, 2025, from https://www.philippe-fournier-viger.com/spmf/PrefixSpan.php

Gunawan, D., ., S., & ., S. (n.d.). Perbandingan Algoritma GSP, PrefixSpan Dan SPADE Dalam Menemukan Pola Runtun Pada Keranjang Belanja Konsumen. Jurnal Ilmiah MATRIK, 23(1), 89-96. https://doi.org/10.30812/matrik.v23i1.1651 (Year needed for APA 7th)

Ingle, M. G., & Suryavanshi, N. Y. (2015). Association Rule Mining using Improved Apriori Algorithm. International Journal of Computer Applications, 112(4), 37–42. https://doi.org/10.5120/19658-1297

Jang, H., Yang, Y., Park, J. S., & Kim, B. (2021). FP-Growth algorithm for discovering region-based association rule in the IoT environment. Electronics, 10(24), 3091. https://doi.org/10.3390/electronics10243091

Kahraman, C., Onar, S. C., Oztaysi, B., Sari, I. U., Al-Refaie, A., & Kob K., B. (Eds.). (2021). Intelligent and Fuzzy Techniques for Emerging Conditions and Digital Transformation: Proceedings of the INFUS 2021 Conference, held August 24-26, 2021. Volume 1 (Vol. 307). Springer Nature. https://doi.org/10.1007/978-3-030-85577-2 (Specific chapter by Kotan needed)

Khasanah, A. U., Erlangga, D. A., & Jamil, A. M. (2018). An application of Data mining techniques in designing catalogue for a laundry service. MATEC Web of Conferences, 154, 01099. https://doi.org/10.1051/matecconf/201815401099

Liu, J., Shi, D., Li, G., Xie, Y., Li, K., Liu, B., & Ru, Z. (2020). Data-driven and Association Rule Mining-based Fault diagnosis and Action mechanism analysis for building chillers. Energy and Buildings, 216, 109957. https://doi.org/10.1016/j.enbuild.2020.109957

Pei, J., Han, J., Mortazavi-Asl, B., Pinto, H., Chen, Q., Dayal, U., & Hsu, M.-C. (2001). PrefixSpan: Mining sequential patterns efficiently by prefix-projected pattern growth. In Proceedings of the 17th International Conference on Data Engineering (ICDE 2001) (pp. 215–224). IEEE Computer Society. https://doi.org/10.1109/ICDE.2001.914830

Pereira, E., Silva, L. C., Silva, D., & Souza, J. (2022). Analyzing alarm logs for failure prediction in cellular networks via sequential pattern mining: A case study in a Tier-1 mobile operator. Computer Networks, 217, 109315. https://doi.org/10.1016/j.comnet.2022.109315

Rachburee, N., Arunrerk, J., & Punlumjeak, W. (2017). Failure part mining using association rules mining by FP-Growth and Apriori algorithms: Case of ATM maintenance in Thailand. In Information Technology and Communications Security (LNCS 449, pp. 19–26). Springer. https://doi.org/10.1007/978-3-319-67131-1_3

Raschka, S. (n.d.). MLxtend: Apriori Module Documentation. Retrieved May 6, 2025, from http://rasbt.github.io/mlxtend/user_guide/frequent_patterns/apriori/

Shaukat, K., Zaheer, S., & Nawaz, I. (2015). Association Rule Mining: An Application Perspective. International Journal of Computer Science and Innovation, 2015(1), 29–38.

Torres-Prieto, R., Martínez-Puerto, P. A., Ortiz, J., & López-Puente, J. (2023). A survey on data mining for data-driven industrial assets maintenance. Technologies, 11(2), 67. https://doi.org/10.3390/technologies11020067

Valtierra-Rodriguez, M., Contreras-Valdez, F., Granados-Lieberman, D., & García-Hernández, G. (2020). Predictive data mining techniques for fault diagnosis of electric equipment: A review. Applied Sciences, 10(3), 950. https://doi.org/10.3390/app10030950

Zaki, M. J. (2001). SPADE: An efficient algorithm for mining frequent sequences. Machine Learning, 42(1-2), 31–60. https://doi.org/10.1023/A:1007652502315

Zhang, X., Tang, Y., Liu, Q., Liu, G., Ning, X., & Chen, J. (2021). A Fault Analysis Method Based on Association Rule Mining for Distribution Terminal Unit. Applied Sciences, 11(11), 5221. https://doi.org/10.3390/app11115221

Downloads


Crossmark Updates

How to Cite

Praharto, S., & Santoso, H. (2025). Data Mining Framework for EDC Terminal Repair Protocol: Combining Apriori and PrefixSpan. Sinkron : Jurnal Dan Penelitian Teknik Informatika, 9(2), 884-894. https://doi.org/10.33395/sinkron.v9i2.14759

Issue

Vol. 9 No. 2 (2025): Research Articles April 2025

Section

Articles

License

Copyright (c) 2025 Suwandhy Praharto, Handri Santoso

Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.

Crossref
Scopus
Google Scholar
Europe PMC

Most read articles by the same author(s)

1 2 3 > >>