Test model for database architectures: an assessment for job search engine systems
Cargando...
Fecha
2022
Autores
Bernal, Mary Carlota
Molina, Yeimer
Título de la revista
ISSN de la revista
Título del volumen
Editor
Instituto de Ciencias Aplicadas y Tecnología, ICAT
Resumen
Information systems are increasingly complex structures due to the diversity of processes
involved and the big data generated, hence data management is essential. NoSQL databases adopt
new approaches to data management differing from relational structures. In this study, three
databases were designed, a relational database using PostgreSQL and two NoSQL databases made in
MongoDB applied to operation of a job offer system, with the aim of comparing its operation and
efficiency. A method was proposed for the metric-guided evaluation of database models using
functionality and efficiency criteria according to Systems and Software Standard Quality Requirements
and Evaluation (SQuaRE). Testing cases were created considering the International Software Testing
Qualifications Board (ISTQB) best practices. Relational data model was selected as a pattern, for this
reason, to populate NoSQL databases a reference framework was applied for data migration from one
environment to another, thus the tests were performed under the same hardware, software and data
conditions. This study determined that the SQL schema provides greater functionality, ensuring
transaction support and data integrity. On the other hand, the NoSQL schemas are more efficient in
response to big data processing, although they have a certain level of data duplication, transaction
support fails and some join operations are not support.
Descripción
Palabras clave
Relational database, NoSQL, Functionality, Efficiency, Test model, Job search engine systems
Citación
Bernal, M., & Molina, Y. (2022). Test model for database architectures: an assessment for job search engine systems. Journal of Applied Research and Technology, 20(3), 306-319. https://doi.org/10.22201/icat.24486736e.2022.20.3.1169