Pesquisa comparativa de desempenho entre SGBD relacional e NoSQL: uma análise para pequenas empresas

Abstract

This study conducted a comparative analysis between two database management system models in the context of use by small businesses: the relational model, represented by MySQL, and the NoSQL model, represented by MongoDB. The research was justified by the need for small businesses to find effective solutions for data management, considering their financial and technical limitations. The methodology involved a mixed approach, with quantitative and qualitative analyses of five essential criteria: performance, scalability, ease of use, cost, and security. For performance testing, the benchmarking tools Sysbench, for MySQL, and Apache JMeter, for MongoDB, were used, while the other criteria were evaluated through qualitative analysis. The results indicated that although MySQL excelled in simple read operations, MongoDB showed superior performance in write operations and complex queries optimized for its document model. The study's central conclusion is that there is no universally superior DBMS, but rather a strategic choice: MySQL proved more suitable for scenarios requiring high data consistency and integrity, while MongoDB stood out in environments that prioritize development agility, schema flexibility, and massive scalability, thus guiding small businesses to align the technology with their business model.