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
- Tarwoto Tarwoto, Adam Prayogo Kuncoro, Evaluasi Penerapan Sistem Informasi Smart Prodi dengan Pendekatan Delone Mclean dan Framework Cobit 5 , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 18 No. 2 (2019)
- Dinny Komalasari, Maria Ulfa, Pengujian Usability Heuristic Terhadap Perangkat Lunak Pembelajaran Matematika , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 19 No. 2 (2020)
- Jusmita Weriza, Ismail Husein, Noranizamardia Noranizamardia, M Fakhariza, Khairan Marzuki, Development of OnlineWeb-Based New Student Graduation Application in Junior High School , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 21 No. 3 (2022)
- Apriani Apriani, Sandi Justitia Putra, Ismarmiaty Ismarmiaty, Ni Gusti Ayu Dasriani, E-Alert Application in Facing Earthquake Disaster , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 19 No. 2 (2020)
- Sepyan Purnama Kristanto, Lutfi Hakim, Ekstraksi Informasi Destinasi Wisata Populer Jawa Timur Menggunakan Depth-First Crawling , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 21 No. 1 (2021)
- Imanuddin Imanuddin, Fachrid Alhadi, Raza Oktafian, Ahmad Ihsan, Deteksi Mata Mengantuk pada Pengemudi Mobil Menggunakan Metode Viola Jones , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 18 No. 2 (2019)
- Dewa putu yudhi Ardiana, I Made Shaja Dwiputra, Sistem Informasi Penanganan Keluhan Pelanggan di Rumah Sakit Umum Surya Husadha Denpasar Berbasis Web , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 18 No. 2 (2019)
- Amir Ali, Klasterisasi Data Rekam Medis Pasien Menggunakan Metode K-Means Clustering di Rumah Sakit Anwar Medika Balong Bendo Sidoarjo , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 19 No. 1 (2019)
- Samsurizal Samsurizal, Arif Nur Afandi, Mohamad Rodhi Faiz, Artificial Intelligence Enhanced Direct Current Fast ChargingIntegration for Electric Vehicles on 20 kV Grids: A Technical andOntological Study , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 24 No. 3 (2025)
- Erna Daniati, Sucipto Sucipto, Anita Sari Wardani, Akmal Hisyam Pradhana, Usability Test on the System Determination Decision Support ReleaseProduct Towards Contribution Level Decision Maker , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 24 No. 3 (2025)
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)
