Implement a System Based on Hybrid Databases that Expedites Documentary Management for the Development of the Urban Area of the Municipality of Breña

Abstract

The article addresses the problem of document management in the Municipality of Breña, where systems with SQL Server databases are used. The goal of the research is to improve query performance and user satisfaction by implementing a hybrid database and microservices architecture components. It seeks to optimize document management times and offer more efficient and fluid systems. To achieve this, a hybrid database was implemented that combined SQL Server and MongoDB (a NoSQL database). In addition, a microservices architecture was chosen to increase the flexibility and scalability of the system. The Scrum agile methodology was adopted to manage the project, dividing it into sprints with specific objectives. Database migration was prioritized using Python libraries and the development of microservices components. In addition, a dummy, a desktop application, was created to perform concept tests and validate the correct functioning of the microservices API. This hybrid approach and the use of the Scrum methodology proved to be effective in optimizing document management in the Municipality of Breña, providing tangible improvements in system performance and efficiency. Of which based on the results it was achieved greater efficiency in municipal management, data integration and increased ability to adapt and grow. On this, the results of the survey are based on questions related to the four dimensions around the independent variable showing an existence of Spearman correlation supporting to take a question from each dimension which showed results of “Strongly agree” and “Agree” in the dimensions of 40%, 32.5%, 37.5% and 35%. © The Author(s), under exclusive license to Springer Nature Switzerland AG 2024.