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...

Full description

Bibliographic Details
Main Authors: Aguilar Vera, Raul, Naal Jácome, Andrés, Díaz Mendoza, Julio, Gómez Gómez, Omar
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
Description
Summary: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.