Análise de Desempenho em Banco de Dados NoSQL Orientado a Documentos: Um Índice para Comparação de Modelos de Dados
Resumo
Este estudo compara duas abordagens de modelagem de dados em bancos de dados NoSQL orientados a documentos: documentos referenciados e documentos aninhados, com a finalidade de estabelecer um índice geral entre os desempenhos de acesso dessas duas abordagens. Os resultados da análise, usando regressão múltipla, mostram que, em média, no modo replica set, o acesso aos dados em documentos aninhados é 2.20 vezes mais rápido com cache ativado e 1.74 vezes mais rápido com cache desativado. No modo standalone, o acesso aos dados em documentos aninhados é 1.70 vezes mais rápido com cache ativado e 1.24 vezes mais rápido com cache desativado.
Palavras-chave:
banco de dados, nosql, modelo de dados, desempenho
Referências
Chen, L., Davoudian, A., and Liu, M. (2022). A workload-driven method for designing aggregate-oriented nosql databases. Data & Knowledge Engineering, 142:102089.
Corbellini, A., Mateos, C., Zunino, A., Godoy, D., and Schiaffino, S. (2017). Persisting big-data: The nosql landscape. Information Systems, 63:1–23.
de la Vega, A., García-Saiz, D., Blanco, C., Zorrilla, M., and Sánchez, P. (2020). Mortadelo: Automatic generation of nosql stores from platform-independent data models. Future Generation Computer Systems, 105:455–474.
Diogo, M., Cabral, B., and Bernardino, J. (2019). Consistency models of nosql databases. Future Internet, 11(2):43.
Erraji, A., Maizate, A., and Ouzzif, M. (2022). Toward a smart approach of migration from relational system database to nosql system: Transformation rules of structure. In Innovations in Smart Cities Applications Volume 5: The Proceedings of the 6th International Conference on Smart City Applications, pages 783–794. Springer.
Gómez, P., Casallas, R., and Roncancio, C. (2016). Data schema does matter, even in nosql systems! In 2016 IEEE Tenth International Conference on Research Challenges in Information Science (RCIS), pages 1–6. IEEE.
Gómez, P., Casallas, R., and Roncancio, C. (2020). Automatic schema generation for document-oriented systems. In Database and Expert Systems Applications: 31st International Conference, DEXA 2020, Bratislava, Slovakia, September 14–17, 2020, Proceedings, Part I 31, pages 152–163. Springer.
Gómez, P., Roncancio, C., and Casallas, R. (2021). Analysis and evaluation of document-oriented structures. Data & Knowledge Engineering, 134:101893.
Hamouda, S. and Zainol, Z. (2017). Document-oriented data schema for relational database migration to nosql. In 2017 International conference on big data innovations and applications (innovate-data), pages 43–50. IEEE.
Hewasinghage, M., Abelló, A., Varga, J., and Zimányi, E.(2021). A cost model for random access queries in document stores. The VLDB Journal, 30(4):559–578.
Imam, A. A., Basri, S., Ahmad, R., Wahab, A. A., González-Aparicio, M. T., Capretz, L. F., Alazzawi, A. K., and Balogun, A. O. (2020). Dsp: Schema design for non-relational applications. Symmetry, 12(11):1799.
Imam, A. A., Basri, S., Ahmad, R., Watada, J., and González-Aparicio, M. T. (2018). Automatic schema suggestion model for nosql document-stores databases. Journal of Big Data, 5(1):1–17.
Kuszera, E. M., Peres, L. M., and Didonet Del Fabro, M. (2020). Query-based metrics for evaluating and comparing document schemas. In Advanced Information Systems Engineering: 32nd International Conference, CAiSE 2020 Grenoble, France, June 8–12, 2020, Proceedings 32, pages 530–545. Springer.
Reis, D. G., Gasparoni, F. S., Holanda, M., Victorino, M., Ladeira, M., and Ribeiro, E. O. (2018). An evaluation of data model for nosql document-based databases. In Trends and Advances in Information Systems and Technologies: Volume 1 6, pages 616–625. Springer.
Shah, M., Kothari, A., and Patel, S. (2022). Influence of schema design in nosql document stores. In Mobile Computing and Sustainable Informatics: Proceedings of ICMCSI 2021, pages 435–452. Springer.
Weisburd, D., Wilson, D. B., Wooditch, A., Britt, C., Weisburd, D., Wilson, D. B., Wooditch, A., and Britt, C. (2022). Multiple regression. Advanced Statistics in Criminology and Criminal Justice, pages 15–72.
Corbellini, A., Mateos, C., Zunino, A., Godoy, D., and Schiaffino, S. (2017). Persisting big-data: The nosql landscape. Information Systems, 63:1–23.
de la Vega, A., García-Saiz, D., Blanco, C., Zorrilla, M., and Sánchez, P. (2020). Mortadelo: Automatic generation of nosql stores from platform-independent data models. Future Generation Computer Systems, 105:455–474.
Diogo, M., Cabral, B., and Bernardino, J. (2019). Consistency models of nosql databases. Future Internet, 11(2):43.
Erraji, A., Maizate, A., and Ouzzif, M. (2022). Toward a smart approach of migration from relational system database to nosql system: Transformation rules of structure. In Innovations in Smart Cities Applications Volume 5: The Proceedings of the 6th International Conference on Smart City Applications, pages 783–794. Springer.
Gómez, P., Casallas, R., and Roncancio, C. (2016). Data schema does matter, even in nosql systems! In 2016 IEEE Tenth International Conference on Research Challenges in Information Science (RCIS), pages 1–6. IEEE.
Gómez, P., Casallas, R., and Roncancio, C. (2020). Automatic schema generation for document-oriented systems. In Database and Expert Systems Applications: 31st International Conference, DEXA 2020, Bratislava, Slovakia, September 14–17, 2020, Proceedings, Part I 31, pages 152–163. Springer.
Gómez, P., Roncancio, C., and Casallas, R. (2021). Analysis and evaluation of document-oriented structures. Data & Knowledge Engineering, 134:101893.
Hamouda, S. and Zainol, Z. (2017). Document-oriented data schema for relational database migration to nosql. In 2017 International conference on big data innovations and applications (innovate-data), pages 43–50. IEEE.
Hewasinghage, M., Abelló, A., Varga, J., and Zimányi, E.(2021). A cost model for random access queries in document stores. The VLDB Journal, 30(4):559–578.
Imam, A. A., Basri, S., Ahmad, R., Wahab, A. A., González-Aparicio, M. T., Capretz, L. F., Alazzawi, A. K., and Balogun, A. O. (2020). Dsp: Schema design for non-relational applications. Symmetry, 12(11):1799.
Imam, A. A., Basri, S., Ahmad, R., Watada, J., and González-Aparicio, M. T. (2018). Automatic schema suggestion model for nosql document-stores databases. Journal of Big Data, 5(1):1–17.
Kuszera, E. M., Peres, L. M., and Didonet Del Fabro, M. (2020). Query-based metrics for evaluating and comparing document schemas. In Advanced Information Systems Engineering: 32nd International Conference, CAiSE 2020 Grenoble, France, June 8–12, 2020, Proceedings 32, pages 530–545. Springer.
Reis, D. G., Gasparoni, F. S., Holanda, M., Victorino, M., Ladeira, M., and Ribeiro, E. O. (2018). An evaluation of data model for nosql document-based databases. In Trends and Advances in Information Systems and Technologies: Volume 1 6, pages 616–625. Springer.
Shah, M., Kothari, A., and Patel, S. (2022). Influence of schema design in nosql document stores. In Mobile Computing and Sustainable Informatics: Proceedings of ICMCSI 2021, pages 435–452. Springer.
Weisburd, D., Wilson, D. B., Wooditch, A., Britt, C., Weisburd, D., Wilson, D. B., Wooditch, A., and Britt, C. (2022). Multiple regression. Advanced Statistics in Criminology and Criminal Justice, pages 15–72.
Publicado
25/09/2023
Como Citar
VERA-OLIVERA, Harley; ALVAREZ-MAMANI, Edwin; HOLANDA, Maristela.
Análise de Desempenho em Banco de Dados NoSQL Orientado a Documentos: Um Índice para Comparação de Modelos de Dados. In: SIMPÓSIO BRASILEIRO DE BANCO DE DADOS (SBBD), 38. , 2023, Belo Horizonte/MG.
Anais [...].
Porto Alegre: Sociedade Brasileira de Computação,
2023
.
p. 26-38.
ISSN 2763-8979.
DOI: https://doi.org/10.5753/sbbd.2023.231721.
