Middleware Development for Heterogeneous Databases on Multi-Architecture Systems Small Medium Enterprise
DOI:
https://doi.org/10.30812/matrik.v25i1.5545Keywords:
Application Programming Interface, Information Systems, Sales ForecastingAbstract
The fisheries industry is highly complex, requiring information technology to support data recording, information management, and sales forecasting. At Kampunglawo, a sales information system has been developed to manage transactions and track shipments of fishery products. However, the sales forecasting systems were developed separately, with different architectures and underlying data structures, necessitating data duplication and restructuring and resulting in inefficiencies. The objective of this research is to develop an Application Programming Interface (API) that connects the two systems, enabling data sharing without redundancy. The methods used were literature review, system requirements analysis, design, implementation, functional and performance testing, and evaluation. The results of this research show that the developed API can synchronize data between the sales and forecasting systems with high efficiency. Testing showed that for 1, 10, and 50 synchronized data sets, the server response ratio was 1:1,057:1,869, with an increase in processing time of only 41.7% for the largest data volume. The conclusion of this research shows that using APIs can reduce processing time and eliminate the need for data restructuring, thereby increasing the efficiency of the company’s
information system integration.
Downloads
References
[1] T. Taipalus, “Database management system performance comparisons: A systematic literature review,” Journal of Systems and
Software, vol. 208, p. 111872, Feb. 2024, https://doi.org/10.1016/j.jss.2023.111872.
[2] A. Krasnikov, E. Romanova, and O. Kireeva, “Development of fishery information system for production processes organization,”
BIO Web of Conferences, vol. 83, p. 03005, 2024, https://doi.org/10.1051/bioconf/20248303005.
[3] R. Kurniawan, “Application of Random Forest Algorithm on Credit Risk Analysis,” Procedia Computer Science, vol. 245, pp.
740–749, 2024, https://doi.org/10.1016/j.procs.2024.10.300.
[4] G. E. Mushi, P.-Y. Burgi, and G. Di Marzo Serugendo, “State of Agricultural E-Government Services to Farmers in Tanzania:
Toward the Participatory Design of a Farmers Digital Information System (FDIS),” Agriculture, vol. 14, no. 3, p. 475, Mar.
2024, https://doi.org/10.3390/agriculture14030475.
[5] I. M. Putrama and P. Martinek, “Heterogeneous data integration: Challenges and opportunities,” Data in Brief, vol. 56, p.
110853, Oct. 2024, https://doi.org/10.1016/j.dib.2024.110853.
[6] C. Li, Y. Chen, and Y. Shang, “A review of industrial big data for decision making in intelligent manufacturing,” Engineering
Science and Technology, an International Journal, vol. 29, p. 101021, May 2022, https://doi.org/10.1016/j.jestch.2021.06.001.
[7] S. Benjelloun, M. E. M. El Aissi, Y. Lakhrissi, and S. El Haj Ben Ali, “Data Lake Architecture for Smart Fish Farming Data-
Driven Strategy,” Applied System Innovation, vol. 6, no. 1, p. 8, Jan. 2023, https://doi.org/10.3390/asi6010008.
[8] C. A. Gy˝or¨odi, D. V. Dums¸e-Burescu, D. R. Zmaranda, R. S¸ . Gy˝or¨odi, G. A. Gabor, and G. D. Pecherle, “Performance Analysis
of NoSQL and Relational Databases with CouchDB and MySQL for Application’s Data Storage,” Applied Sciences, vol. 10,
no. 23, p. 8524, Nov. 2020, https://doi.org/10.3390/app10238524.
[9] J. I. Janjua, T. A. Khan, S. Zulfiqar, and M. Q. Usman, “An Architecture of MySQL Storage Engines to Increase the Resource
Utilization,” in 2022 International Balkan Conference on Communications and Networking (BalkanCom). Sarajevo, Bosnia
and Herzegovina: IEEE, Aug. 2022, pp. 68–72, https://doi.org/10.1109/BalkanCom55633.2022.9900616.
[10] A. Rehman, S. Naz, and I. Razzak, “Leveraging big data analytics in healthcare enhancement: Trends, challenges and opportunities,”
Multimedia Systems, vol. 28, no. 4, pp. 1339–1371, Aug. 2022, https://doi.org/10.1007/s00530-020-00736-8.
[11] J. Chaudhary, V. Vyas, and C. K. Jha, “Qualitative Analysis of SQL and NoSQL Database with an Emphasis on Performance,”
in IOT with Smart Systems, J. Choudrie, P. Mahalle, T. Perumal, and A. Joshi, Eds. Singapore: Springer Nature Singapore,
2023, vol. 312, pp. 155–165, https://doi.org/10.1007/978-981-19-3575-6 18.
[12] E. Lupu, A. Olteanu, and A. D. Ionita, “Concurrent Access Performance Comparison Between Relational Databases and Graph
NoSQL Databases for Complex Algorithms,” Applied Sciences, vol. 14, no. 21, p. 9867, Oct. 2024, https://doi.org/10.3390/
app14219867.
[13] Sasmoko, Y. Indrianti, S. R. Manalu, and J. Danaristo, “Analyzing Database Optimization Strategies in Laravel for an Enhanced
Learning Management,” Procedia Computer Science, vol. 245, pp. 799–804, 2024, https://doi.org/10.1016/j.procs.2024.10.306.
[14] I. vSuvster and T. Ranisavljevic, “Optimization of MySQL database,” Journal of Process Management and New Technologies,
vol. 11, no. 1-2, pp. 141–151, 2023, https://doi.org/10.5937/jouproman2301141Q.
[15] M. Boyd, L. Vaccari, M. Posada, and D. Gattwinkel, “An Application Programming Interface (API) framework for digital
government,” Publications Office of the European Union, 2020.
[16] L. Vaccari, M. Posada, M. Boyd, and M. Santoro, “APIs for EU Governments: A Landscape Analysis on Policy Instruments,
Standards, Strategies and Best Practices,” Data, vol. 6, no. 6, p. 59, Jun. 2021, https://doi.org/10.3390/data6060059.
[17] M. A. Ali and S. M. Salih, “Impact of Application Programming Interfaces (APIs) Economy on Digital Economics in Saudi
Arabia,” Sustainability, vol. 17, no. 9, p. 4104, May 2025, https://doi.org/10.3390/su17094104.
[18] P. Gowda and A. N. Gowda, “Best Practices in REST API Design for Enhanced Scalability and Security,” Journal of Artificial
Intelligence, Machine Learning and Data Science, vol. 2, no. 1, pp. 827–830, Feb. 2024, https://doi.org/10.51219/JAIMLD/
priyanka-gowda/202.
[19] I. R. D. Muhammad and I. V. Paputungan, “Development of Backend Server Based on REST API Architecture in E-Wallet
Transfer System,” Jurnal Sains, Nalar, dan Aplikasi Teknologi Informasi, vol. 3, no. 2, pp. 79–87, Jan. 2024, https://doi.org/10.
20885/snati.v3.i2.35.
[20] J. Shang, L. Xiao, Z. Wu, J. Yang, Z. Xiao, J. Wang, Y. Zhang, X. Chen, J. Wang, and H. Li, “GvdsSQL: Heterogeneous
Database Unified Access Technology for Wide-Area Environments,” Electronics, vol. 13, no. 8, p. 1521, Apr. 2024, https:
//doi.org/10.3390/electronics13081521.
[21] B. Namdeo and U. Suman, “A Middleware Model for SQL to NoSQL Query Translation,” Indian Journal of Science and
Technology, vol. 15, no. 16, pp. 718–728, Apr. 2022, https://doi.org/10.17485/IJST/v15i16.2250.
[22] S. Bhatt, “Best Practices for Designing Scalable REST APIs in Cloud Environments,” Journal of Sustainable Solutions, vol. 1,
no. 4, pp. 48–71, Oct. 2024, https://doi.org/10.36676/j.sust.sol.v1.i4.26.
[23] Y. Mesmoudi, M. Lamnaour, Y. El Khamlichi, A. Tahiri, A. Touhafi, and A. Braeken, “A Middleware based on Service Oriented
Architecture for Heterogeneity Issues within the Internet of Things (MSOAH-IoT),” Journal of King Saud University - Computer
and Information Sciences, vol. 32, no. 10, pp. 1108–1116, Dec. 2020, https://doi.org/10.1016/j.jksuci.2018.11.011.
[24] H. Valentine and B. Kabaso, “Design and Development of a Unified Query Platform as Middleware for NoSQL Data Stores,”
International Journal of Advanced Computer Science and Applications, vol. 15, no. 7, 2024, https://doi.org/10.14569/IJACSA.
2024.0150762.
[25] F. F. Yudan and M. Arief Virgy, “Implementasi Open Government Data oleh Pemerintah Kota Bandung,” Jurnal Transformative,
vol. 7, no. 1, pp. 128–153, Mar. 2021, https://doi.org/10.21776/ub.transformative.2021.007.01.6.
[26] Y. Ikhwani, A. Ramadhan, M. Bahit, and T. H. Faesal, “Single elimination tournament design using dynamic programming
algorithm,” MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer, vol. 23, no. 1, pp. 113–130, Nov. 2023,
https://doi.org/10.30812/matrik.v23i1.3290.
[27] A. Niarman, Iswandi, and A. K. Candri, “Comparative Analysis of PHP Frameworks for Development of Academic Information
System Using Load and Stress Testing,” International Journal Software Engineering and Computer Science (IJSECS), vol. 3,
no. 3, pp. 424–436, Dec. 2023, https://doi.org/10.35870/ijsecs.v3i3.1850.
[28] G. Locicero, A. D. Maria, S. Alaimo, and A. Pulvirenti, “MASFENON: Implementing a multi-agent simulation framework
for interconnected networks with distributed programming,” Procedia Computer Science, vol. 255, pp. 73–82, 2025, https:
//doi.org/10.1016/j.procs.2025.02.262.
[29] K. N. Markert, G. Da Silva, D. P. Ames, I. Maghami, G. P. Williams, E. J. Nelson, J. Halgren, A. Patel, A. Santos, and M. J.
Ames, “Design and implementation of a BigQuery dataset and application programmer interface (API) for the U.S. National
Water Model,” Environmental Modelling & Software, vol. 179, p. 106123, Aug. 2024, https://doi.org/10.1016/j.envsoft.2024.
106123.
Downloads
Published
Issue
Section
License
Copyright (c) 2025 Christopel H. Simanjuntak, Musfiah, Muhammad Bahit, Cristovani W. Lohonauman, Stenly B. Dodie, Khamla Nonalinsavath
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
How to Cite
Similar Articles
- Renita Fitriani, Muhammad Tajuddin, DESAIN SISTEM INFORMASI SEKOLAH BERBASIS ANDROID , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 16 No. 1 (2016)
- Moh.Erwin Indrawan, Ahmat Adil, IMPLEMENTASI RESTFUL WEB SERVICE ONE CHIP MULTI-CLIENT UNTUK MENGOPTIMALKAN PENJUALAN PULSA ALL OPERATOR , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 15 No. 2 (2016)
- Fiby Nur Afiana, Pungkas Subarkah, A. Kholil Hidayat, Analisis Perbandingan Metode TAM dan Metode UTAUT 2 dalam Mengukur Kesuksesan Penerapan SIMRS pada Rumah Sakit Wijaya Kusuma DKT Purwokerto , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 19 No. 1 (2019)
- Sela Octaviani, Evi Triandini, Dandy Pramana Hostiadi, Evaluating Lecturer Satisfaction on Academic Information System Using Usability and EUCS at Bandung University of Technology , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 25 No. 1 (2025)
- Soleh Ardiansyah, Adani Setiorini, Lovinta Happy Atrinawati, Tegar Palyus Fiqar, Perancangan Arsitektur Sistem dan Teknologi Informasi Menggunakan Togaf ADM (Studi Kasus Dinas Perhubungan Kota Balikpapan) , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 19 No. 1 (2019)
- Ardafa Ihromi, Yuda Syahidin, Erix Gunawan, Neneng Yuniarty, E-Mortality using Agile Scrum Method to Improve Information Services Effectiveness , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 22 No. 3 (2023)
- Anas Syaifudin, Purwanto Purwanto, Heribertus Himawan, M. Arief Soeleman, Customer Segmentation with RFM Model using Fuzzy C-Means and Genetic Programming , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 22 No. 2 (2023)
- Danang Wahyu Utomo, Christy Atika Sari, Folasade Olubusola Isinkaye, Quality Improvement for Invisible Watermarking using Singular Value Decomposition and Discrete Cosine Transform , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 23 No. 3 (2024)
- Muhamad Nur Gunawan, Titi Farhanah, Siti Ummi Masruroh, Ahmad Mukhlis Jundulloh, Nafdik Zaydan Raushanfikar, Rona Nisa Sofia Amriza, Accuracy of K-Nearest Neighbors Algorithm Classification For Archiving Research Publications , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 23 No. 3 (2024)
- Yarza Aprizal, Rabin Ibnu Zainal, Afriyudi Afriyudi, Perbandingan Metode Backpropagation dan Learning Vector Quantization (LVQ) Dalam Menggali Potensi Mahasiswa Baru di STMIK PalComTech , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 18 No. 2 (2019)
You may also start an advanced similarity search for this article.
Most read articles by the same author(s)
- yusri ikhwani, As`ary Ramadhan, Muhammad Bahit, Taufik Hidayat Faesal, Single elimination tournament design using dynamic programming algorithm , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 23 No. 1 (2023)
.png)
