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
- Erwin Mardinat, Saiful Khair, MEMBANGUN SISTEM INFORMASI PENGELOLAHAN DATA NASABAH BERBASIS WEB DI BANK SAMPAH SAMAWA , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 17 No. 1 (2017)
- Khaerul Yasin, Ahmat Adil, Implementasi Google Maps API Pemetaan Jalur Evakuasi Bencana Alam di Kabupatem Lombok Utara , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 19 No. 1 (2019)
- Haryati Haryati, Shinta Esabella, Rancang Bangun Aplikasi Sastra Lisan (Lawas) Khas Sumbawa Berbasis Android , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 18 No. 2 (2019)
- Romi Choirudin, Ahmat Adil, Implementasi Rest Api Web Service dalam Membangun Aplikasi Multiplatform untuk Usaha Jasa , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 18 No. 2 (2019)
- Anthony Anggrawan, Azhari Azhari, APLIKASI DETEKSI KEMIRIPAN TUGAS PAPER , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 15 No. 2 (2016)
- Winny purbaratri, Hindriyanto Dwi Purnomo, Danny Manongga, Iwan Setyawan, Hendry Hendry, Sentiment Analysis of e-Government Service Using the Naive Bayes Algorithm , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 23 No. 2 (2024)
- Muhammad Yusuf, Arizal Arizal, Ira Rosianal Hikmah, Implementation Cryptography and Access Control on IoT-Based Warehouse Inventory Management System , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 22 No. 1 (2022)
- Muhammad Tajuddin, Abdul Manan, RANCANG BANGUN SISTEM INFORMASI MONITORING SATUAN KERJA DALAM RANGKA GOOD GOVERNANCE , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 15 No. 1 (2015)
- Muchammad Ismail Hamzah, DESAIN DAN IMPLEMENTASI WEB SMP ISLAM NGEBRUK MENGGUNAKAN PHP DAN MYSQL , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 16 No. 2 (2017)
- Melati Rosanensi, Improving E-Commerce Effectiveness Using Augmented Reality , MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer: Vol. 19 No. 2 (2020)
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)
