Desarrollo de un sistema web para el seguimiento eficiente a clientes en la empresa Support L&P basada en la arquitectura de llamadas a procedimientos remotos gRPC.

Abstract

The objective of this Curriculum Integration work was the development of a web system for the efficient monitoring of clients of the "Support L&P" company, with the implementation of the architecture of remote procedures call GRPC, to mitigate events of loss of information and reprocessing in the efficient treatment of its clients. In the requirement phase, we detailed 50 user stories and 9 technical stories that were planned and presented in Sprint with 16 deliverables, we utilized the agile SCRUM methodology with a successful result in its application. The development tools were SQL_SERVER, Visual Studio C#, Blazor Pages C# and proto3 framework for the deployment of GRPC services. We implemented the ISO/IEC 25010 standard to evaluate efficiency with time, resource utilization and capacity metrics. The result of the Anova analysis of variance with respect to time was a 0.001% relationship with the cut-off criterion of 0.05%, showing a significant difference in favor of utilizing the system. The Google Chrome browser was the best option for system deployment, in terms of use of memory sources (205.5 MB), processor (5.3%) and network (933.7 Kbps / 10.1 Kbps (TX/RX). With a capacity of 3500 tasks at the same time due to stress overloads in the Jmeter application. We concluded that the implementation of the system presents a significant change in benefit to the efficient monitoring of the clients of the "Support L&P" company. The implementation of GRPC architecture is recommended for future developments since it presents a high performance in simultaneous tasks, as well as the use of its official documentation issued by Google