2026-05-05T01:43:18.325Z http://ezaposleni.singidunum.ac.rs/rest/sciNaucniRezultati/oai

ezaposleni.singidunum.ac.rs/rest/sciNaucniRezultati/oai:1:11662 2025-10-27T16:06:14Z 1

A Comparative Evaluation of PostgreSQL, MongoDB, and MySQL for Ethiopian Migrant Data Management 2025 http://ezaposleni.singidunum.ac.rs/rest/sciNaucniRezultati/oai/record/1/11662 https://ceur-ws.org/Vol-4077/paper1.pdf T. Emad Ali F. Imad Ali H. Sakerc F. Eyvazov P. Dakić A. Dhulfiqar Zoltan In the face of rising international migration, dealing with large-scale, established migrant data is a monumental task. This article discusses the Ethiopian Migrant Database Management System (EMDMS) as a real-world software that necessitates effective, scalable, and dependable statistics garage solutions. The goal of this study is to undertake a comprehensive comparison of three database control structures (PostgreSQL, MongoDB, and MySQL) in the EMDMS environment to verify their suitability for dealing with migration-related data. Using an AWS cloud-based deployment and containerized microservices architecture, the test links each DBMS with real-time APIs via Hasura and collects performance data via Prometheus and Grafana. Insert, pick out, and delete are benchmark procedures that are measured on datasets ranging from 100 to 100,000 rows in size. PostgreSQL outperformed other databases in terms of managing large amounts of data, particularly in insert, select, and delete operations. MongoDB offered schema flexibility but confirmed decreased performance at higher volumes. MySQL performed well with smaller datasets but lagged in scalability. PostgreSQL emerged as the most suitable DBMS for dealing with existing migration records within EMDMS, providing both overall performance and operational reliability. MongoDB is ideal for flexible information models, but MySQL is better suited to simple, lightweight applications. conferenceObject https://ceur-ws.org/Vol-4077/paper1.pdf https://ceur-ws.org/Vol-4077/paper1.pdf