Test model for database architectures: an assessment for job search engine systems

Main Article Content

Mary Carlota Bernal
https://orcid.org/0000-0001-7565-2909
Yeimer Molina

Abstract

Data is a fundamental part of information and management systems; thus, controlling its complexity is an essential step nowadays. NoSQL databases adopt new approaches to data management differing from relational structures. For this study, two database systems are considered, MongoDB as a NoSQL data storage model and PostgreSQL as a relational data model, they are compared and evaluated on a job search system. For this purpose, a dataset was defined, and its representation was constructed in databases based on each technology. This process allowed the data modeling in terms of the best practices, then, the development of a test plan prepared the environment for the determination of the comparison metrics of both databases under the methodology specified by the International Software Testing Qualifications Board (ISTQB) and the types of database testing. This study determined that the SQL schema provides greater functionality, that ensures the support of transactions and data integrity, the opposite happened with the NoSQL schemas, resulting in more efficient but lacking functionalities that are characteristic and required for data representation of a consistent system.

 

PLUM ANALYTICS

Article Details

How to Cite
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
Author Biography

Mary Carlota Bernal, Universidad Simón Bolívar

Assistant Professor . Systems Engineering Program.  Researcher. Universidad Simón Bolívar. Cúcuta, Colombia

Aggregate Professor. Computer Engineering Department. Universidad Nacional Experimental del Táchira. Táchira, Venezuela

MSc. Computer Science. Universidad de los Andes, Mérida, Venezuela

Computer Engineer. Universidad Nacional Experimental del Táchira. Táchira, Venezuela

Research Groups

  • IngeBioCaribe. Universidad Simón Bolívar. Barranquilla, Departamento del Atlántico, Colombia
  • Investigación e Innovación en Ingenierías Aplicadas. Cúcuta, Departamento de Norte de Santander, Colombia
  • Laboratorio de Investigación y Desarrollo en Informática. San Cristóbal, Estado Táchira, Venezuela
  • Student PhD Computer Science and Mathematics of Security. Smart Health Research Group. University Rovira I Virgili. Tarragona, Spain