NoSQL Database Modeling and Management: A Systematic Literature Review

The NoSQL databases that emerged this century were created to solve the limitations of relational database systems due to the different types of data that have appeared for information processing. In this paper, we present the results of a secondary study carried out to find and synthesize the research made up to now on modeling processes, characteristics of the used types of data, and management tools for NoSQL Databases. Currently, four types are recognized and classified according to the data model they use: key-value, document-oriented, column-based, and graph-based. With this study, it was possible to identify that the most frequently type of NoSQL database model is that of documents because it offers greater flexibility and versatility compared to the other three models. Although it offers more complex search methods, in terms of data, column and document schemas are the ones that usually describe their characteristics. It was also possible to observe a trend in the use of the column-oriented model and the document-oriented model in the management tools, and, although they all comply with the basic functionalities, the differences lie in the way in which the information is stored and the way they can be accessed.

• Fecha de publicación: 2023
• Institución: Universidad Pedagógica y Tecnológica de Colombia
• Repositorio: RiUPTC: Repositorio Institucional UPTC
• Idioma: eng
• OAI Identifier: oai:repositorio.uptc.edu.co:001/14383
• Acceso en línea: https://revistas.uptc.edu.co/index.php/ingenieria/article/view/16519; https://repositorio.uptc.edu.co/handle/001/14383
• Palabra clave: NoSQL; Database Modeling; Review Systematic Literature; Software Engineering; ingeniería de software; modelado de bases de datos; NoSQL; revisión sistemática de la literatura
• License: Copyright (c) 2023 Raul Aguilar Vera, Andrés Naal Jácome, Julio Díaz Mendoza, Omar Gómez Gómez