Qolqa: A Metrics-Driven Design Tool for Document-Oriented NoSQL Databases

• Anghelo Alagon-Fernandez Universidad Nacional de San Antonio Abad del Cusco (UNSAAC)
• Yerson Joab Chirinos-Vilca Universidad Nacional de San Antonio Abad del Cusco (UNSAAC)
• Maristela Holanda Universidade de Brasília (UnB)
• Harley Vera-Olivera Universidad Nacional de San Antonio Abad del Cusco (UNSAAC) https://orcid.org/0000-0003-2011-8797

DOI: https://doi.org/10.5753/sbbd_estendido.2026.249376

Resumo

Document-oriented NoSQL databases, although considered schema-less, require design tools to understand the structural context of schemas, including document organization, attributes, and nesting levels. However, current tools present limitations as they rely heavily on the designer’s experience, lack metrics to evaluate schema quality, and do not integrate queries as part of the design process. Additionally, many of these solutions are commercial or have restricted free versions, which hinders the development of optimal solutions. In this context, this work proposes Qolqa, a web-based tool for designing schemas in document-oriented NoSQL databases that incorporates evaluation metrics, integrates queries as a relevant component of the design, and supports multiple schemas within a single solution. The proposed approach aims to facilitate decision-making in schema design and improve the quality of solutions, regardless of the designer’s level of experience.

Palavras-chave: NoSQL Databases, Document-Oriented Databases, Schema Optimization, Evaluation Metrics

Referências

Datensen (2025). Moon modeler – nosql data modeling for mongodb & mongoose. [link]. Sitio web oficial.

DbSchema (2025). Dbschema: Diseñador de bases de datos con diagramas er. [link]. Sitio web oficial.

Feature-Sliced Design (2018). Docs. [link]. Accessed: 2026-04-16.

Hackolade (2025). Hackolade: Data modeling tool for sql and nosql. [link]. Sitio web oficial.

Luiz, F. C. (2025). Incorporação do modelo de agregados na ferramenta brmodeloweb.

Martin, R. C. (2017). Clean Architecture: A Craftsman’s Guide to Software Structure and Design. Prentice Hall, Boston.

Mozaffari, M., Dignös, A., Gamper, J., and Störl, U. (2024). Self-tuning database systems: A systematic literature review of automatic database schema design and tuning. ACM Comput. Surv., 56(11).

Vera, H., Boaventura, W., Holanda, M., Guimaraes, V., and Hondo, F. (2015). Data modeling for nosql document-oriented databases. In CEUR Workshop Proceedings, volume 1478, pages 129–135. sn.

Vera-Olivera, H. and Holanda, M. (2024). Métricas para análise de esquemas em banco de dados nosql orientado a documentos. In Anais do XXXIX Simpósio Brasileiro de Bancos de Dados, pages 381–393, Porto Alegre, RS, Brasil. SBC.