ASYNCHRONOUS PROCESSING SCHEME WITH DATABASE OPTIMIZATION FOR BOTTLENECK MITIGATION IN HIGH-DEMAND DISTRIBUTED SYSTEMS
DOI:
https://doi.org/10.66104/q1aek837Keywords:
Network Management, Service Resilience, Asynchronous Processing, Message Queues, Performance EngineeringAbstract
Digital transformation in education requires network infrastructures capable of managing high-demand seasonal events, such as academic re-enrollment. Traditional synchronous architectures often lead to critical network congestion, database contention, and service unavailability under peak loads. This paper proposes a distributed management scheme that integrates asynchronous processing, message queuing, and Database Optimization (DBO) to enhance service resilience in resource-constrained environments. By utilizing a message broker for I/O decoupling and implementing batch processing with asynchronous commits, the system optimizes resource allocation and traffic flow. Experimental results from stress tests with 1,000 concurrent users demonstrate that the DBO-enhanced asynchronous model increased throughput (RPS) by over 50% and reduced median end-to-end latency by 60%.
Downloads
References
BANDARU, R. Cloud-native microservices with Docker and Kubernetes: build and deploy scalable microservices using Docker, Kubernetes, and Helm. 2. ed. Birmingham: Packt Publishing, 2022.
BLINOWSKI, G.; OJDAK, J.; PRZYBYŁEK, A. Monolithic vs. Microservice Architecture: A Performance Comparison. IEEE Access, v. 10, p. 20301-20314, 2022. DOI: https://doi.org/10.1109/ACCESS.2022.3152803
CAMPOS, G. et al. Análise de Saturação e Eficiência de Recursos em Ambientes de Computação em Nuvem. In: SIMPÓSIO BRASILEIRO DE REDES DE COMPUTADORES E SISTEMAS DISTRIBUÍDOS (SBRC), 42. , 2024, Niterói. Anais [...]. Porto Alegre: Sociedade Brasileira de Computação, 2024. p. 102-115.
FERREIRA, A. et al. Transformação Digital no Ensino Superior: Desafios e Oportunidades em Tempos de Sazonalidade. Revista Brasileira de Informática na Educação, v. 30, p. 112-135, 2022.
ISHANKHODJAEV, A. et al. Thread-blocking reduction through asynchronous programming: A performance study. Journal of Systems and Software, v. 185, p. 111-125, 2024.
KAMIŃSKI, T.; KLONICA, J.; PAŃCZYK, B. Comparative analysis of RabbitMQ and Kafka for granular routing in Spring Boot applications. International Journal of Distributed Systems, v. 16, n. 2, p. 45-58, 2025.
LAIGNER, R. et al. Benchmarking databases under extreme saturation: Methodologies and pitfalls. Journal of Performance Engineering, v. 12, n. 3, p. 88-102, 2024.
LINHARES, J. et al. Diagnóstico proativo de desempenho de rede: uma abordagem baseada em técnicas de regressão sobre dados de monitoramento. In: WORKSHOP DE GERÊNCIA E OPERAÇÃO DE REDES E SERVIÇOS (WGRS - SBRC), 23. , 2025, Porto Alegre. Anais [...]. Porto Alegre: SBC, 2025. p. 1-14. DOI: https://doi.org/10.5753/wgrs.2025.8765
MEDEIROS, L. et al. Orquestração Resiliente de Microsserviços: Uma Abordagem Baseada em Monitoramento Ativo e Auto-recuperação. Revista Brasileira de Computação Aplicada, Passo Fundo, v. 15, n. 2, p. 45-58, jul. 2023.
NASSER, H.; JABER, M. Managing connections efficiently in postgresql to optimize cpu, i/o and memory usage. International Journal of Science and Research Archive, v. 15, n. 1, p. 1726-1729, 2025. DOI: https://doi.org/10.30574/ijsra.2025.15.1.0650
POPOVIC, M. Performance engineering of a microservice-based system. New York: Springer, 2025.
SALUNKE, S. V.; OUDA, A. A performance benchmark for the postgresql and mysql databases. Future Internet, v. 16, n. 10, p. 382, 2024. DOI: https://doi.org/10.3390/fi16100382
SANTOS, B. et al. IoT sensor networks in smart buildings: A performance assessment using queuing models. Sensors, v. 21, n. 16, p. 5660, 2021. DOI: https://doi.org/10.3390/s21165660
SHYAM MOHAN, J. S.; GOSWAMI, K. Performance analysis and comparison of node.js and java spring boot in implementation of restful applications. Software: Practice and Experience, 2025. DOI: https://doi.org/10.1002/spe.3418
TOPALIDI, A. Asynchronous processes and message queues in ruby applications: efficiency analysis of sidekiq and rabbitmq. International Journal on Science and Technology, v. 16, n. 4, 2025. DOI: https://doi.org/10.71097/IJSAT.v16.i4.9271
PINYAGIN, M.; SADOVYKH, A. Automating Performance Testing in CI/CD - Tools Evaluation. In: BONFANTI, S.; PAPADOPOULOS, G. A. (Eds.). Testing Software and Systems. ICTSS 2025. Lecture Notes in Computer Science, vol. 16107. Cham: Springer, 2026. DOI:https://doi.org/10.1007/978-3-032-05188-2_13. DOI: https://doi.org/10.1007/978-3-032-05188-2_13
SOBIERAJ, M.; KOTYŃSKI, D. Docker Performance Evaluation across Operating Systems. Applied Sciences, v. 14, n. 15, p. 6672, 2024. DOI: https://doi.org/10.3390/app14156672. DOI: https://doi.org/10.3390/app14156672
STĘPIEŃ, K.; SKUBLEWSKA-PASZKOWSKA, M. Performance evaluation of REST and GraphQL API aproaches in data retrieval scenarios using NestJS. Journal of Computer Sciences Institute, v. 36, 2025. DOI: https://doi.org/10.35784/jcsi.7794. DOI: https://doi.org/10.35784/jcsi.7794
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Ivan de Jesus Coelho Correa Junior, Kauan da Silva Pacheco, Estêvão Damasceno Santos
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish in this journal agree to the following terms:
Authors retain copyright and grant the journal the right of first publication, with the work simultaneously licensed under the Creative Commons Attribution License, which permits the sharing of the work with proper acknowledgment of authorship and initial publication in this journal;
Authors are authorized to enter into separate, additional agreements for the non-exclusive distribution of the version of the work published in this journal (e.g., posting in an institutional repository or publishing it as a book chapter), provided that authorship and initial publication in this journal are properly acknowledged, and that the work is adapted to the template of the respective repository;
Authors are permitted and encouraged to post and distribute their work online (e.g., in institutional repositories or on their personal websites) at any point before or during the editorial process, as this may lead to productive exchanges and increase the impact and citation of the published work (see The Effect of Open Access);
Authors are responsible for correctly providing their personal information, including name, keywords, abstracts, and other relevant data, thereby defining how they wish to be cited. The journal’s editorial board is not responsible for any errors or inconsistencies in these records.
PRIVACY POLICY
The names and email addresses provided to this journal will be used exclusively for the purposes of this publication and will not be made available for any other purpose or to third parties.
Note: All content of the work is the sole responsibility of the author and the advisor.
