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 resea...
| Main Authors: | , , , |
|---|---|
| Format: | Online |
| Language: | eng |
| Published: |
Universidad Pedagógica y Tecnológica de Colombia
2023
|
| Subjects: | |
| Online Access: | https://revistas.uptc.edu.co/index.php/ingenieria/article/view/16519 |
| _version_ | 1801706104567103488 |
|---|---|
| author | Aguilar Vera, Raul Naal Jácome, Andrés Díaz Mendoza, Julio Gómez Gómez, Omar |
| author_facet | Aguilar Vera, Raul Naal Jácome, Andrés Díaz Mendoza, Julio Gómez Gómez, Omar |
| author_sort | Aguilar Vera, Raul |
| collection | OJS |
| description | 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. |
| format | Online |
| id | oai:oai.revistas.uptc.edu.co:article-16519 |
| institution | Revista Facultad de Ingeniería |
| language | eng |
| publishDate | 2023 |
| publisher | Universidad Pedagógica y Tecnológica de Colombia |
| record_format | ojs |
| spelling | oai:oai.revistas.uptc.edu.co:article-165192024-01-17T01:31:45Z NoSQL Database Modeling and Management: A Systematic Literature Review Modelado y gestión de bases de datos NoSQL: Revisión sistemática Aguilar Vera, Raul Naal Jácome, Andrés Díaz Mendoza, Julio Gómez Gómez, Omar 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 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. Las bases de datos NoSQL que surgieron este siglo fueron creadas para resolver las limitaciones de los sistemas de bases de datos relacionales debido a los diferentes tipos de datos que han aparecido para el procesamiento de la información. En este artículo, presentamos los resultados de un estudio secundario realizado con el fin de encontrar y sintetizar la investigación realizada hasta ahora sobre procesos de modelado, características de los tipos de datos utilizados, y herramientas de gestión para bases de datos NoSQL. Actualmente, se reconocen y clasifican cuatro tipos según el modelo de datos que utilizan: clave-valor, orientada a documentos, basada en columnas y basada en gráficos. Con este estudio se identificó que el tipo de modelo de base de datos NoSQL más frecuente es el de documentos porque ofrece una mayor flexibilidad y versatilidad en comparación con los otros tres modelos. Aunque ofrecen métodos de búsqueda más complejos, en términos de datos, los esquemas de columnas y documentos son los que suelen describir sus características. También se pudo observar una tendencia en el uso del modelo orientado a columnas y el modelo orientado a documentos en las herramientas de gestión, y, aunque todas cumplen con las funcionalidades básicas, las diferencias radican en la forma en que se almacena la información y la forma en que se puede acceder a ellas. Universidad Pedagógica y Tecnológica de Colombia 2023-09-30 info:eu-repo/semantics/article info:eu-repo/semantics/publishedVersion application/pdf text/xml https://revistas.uptc.edu.co/index.php/ingenieria/article/view/16519 10.19053/01211129.v32.n65.2023.16519 Revista Facultad de Ingeniería; Vol. 32 No. 65 (2023): July-September 2023 (Continuous Publication); e16519 Revista Facultad de Ingeniería; Vol. 32 Núm. 65 (2023): Julio-Septiembre 2023 (Publicación Continua); e16519 2357-5328 0121-1129 eng https://revistas.uptc.edu.co/index.php/ingenieria/article/view/16519/13597 https://revistas.uptc.edu.co/index.php/ingenieria/article/view/16519/13817 Copyright (c) 2023 Raul Aguilar Vera, Andrés Naal Jácome, Julio Díaz Mendoza, Omar Gómez Gómez http://creativecommons.org/licenses/by/4.0 |
| spellingShingle | 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 Aguilar Vera, Raul Naal Jácome, Andrés Díaz Mendoza, Julio Gómez Gómez, Omar NoSQL Database Modeling and Management: A Systematic Literature Review |
| title | NoSQL Database Modeling and Management: A Systematic Literature Review |
| title_alt | Modelado y gestión de bases de datos NoSQL: Revisión sistemática |
| title_full | NoSQL Database Modeling and Management: A Systematic Literature Review |
| title_fullStr | NoSQL Database Modeling and Management: A Systematic Literature Review |
| title_full_unstemmed | NoSQL Database Modeling and Management: A Systematic Literature Review |
| title_short | NoSQL Database Modeling and Management: A Systematic Literature Review |
| title_sort | nosql database modeling and management a systematic literature review |
| topic | 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 |
| topic_facet | 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 |
| url | https://revistas.uptc.edu.co/index.php/ingenieria/article/view/16519 |
| work_keys_str_mv | AT aguilarveraraul nosqldatabasemodelingandmanagementasystematicliteraturereview AT naaljacomeandres nosqldatabasemodelingandmanagementasystematicliteraturereview AT diazmendozajulio nosqldatabasemodelingandmanagementasystematicliteraturereview AT gomezgomezomar nosqldatabasemodelingandmanagementasystematicliteraturereview AT aguilarveraraul modeladoygestiondebasesdedatosnosqlrevisionsistematica AT naaljacomeandres modeladoygestiondebasesdedatosnosqlrevisionsistematica AT diazmendozajulio modeladoygestiondebasesdedatosnosqlrevisionsistematica AT gomezgomezomar modeladoygestiondebasesdedatosnosqlrevisionsistematica |
