dor_id: 4129453

506.#.#.a: Público

590.#.#.d: Los artículos enviados a la revista "Journal of Applied Research and Technology", se juzgan por medio de un proceso de revisión por pares

510.0.#.a: Scopus, Directory of Open Access Journals (DOAJ); Sistema Regional de Información en Línea para Revistas Científicas de América Latina, el Caribe, España y Portugal (Latindex); Indice de Revistas Latinoamericanas en Ciencias (Periódica); La Red de Revistas Científicas de América Latina y el Caribe, España y Portugal (Redalyc); Consejo Nacional de Ciencia y Tecnología (CONACyT); Google Scholar Citation

561.#.#.u: https://www.icat.unam.mx/

650.#.4.x: Ingenierías

336.#.#.b: article

336.#.#.3: Artículo de Investigación

336.#.#.a: Artículo

351.#.#.6: https://jart.icat.unam.mx/index.php/jart

351.#.#.b: Journal of Applied Research and Technology

351.#.#.a: Artículos

harvesting_group: RevistasUNAM

270.1.#.p: Revistas UNAM. Dirección General de Publicaciones y Fomento Editorial, UNAM en revistas@unam.mx

590.#.#.c: Open Journal Systems (OJS)

270.#.#.d: MX

270.1.#.d: México

590.#.#.b: Concentrador

883.#.#.u: https://revistas.unam.mx/catalogo/

883.#.#.a: Revistas UNAM

590.#.#.a: Coordinación de Difusión Cultural

883.#.#.1: https://www.publicaciones.unam.mx/

883.#.#.q: Dirección General de Publicaciones y Fomento Editorial

850.#.#.a: Universidad Nacional Autónoma de México

856.4.0.u: https://jart.icat.unam.mx/index.php/jart/article/view/1169/905

100.1.#.a: Bernal, Mary Carlota; Molina, Yeimer

524.#.#.a: Bernal, Mary Carlota, et al. (2022). Test model for database architectures: an assessment for job search engine systems. Journal of Applied Research and Technology; Vol. 20 Núm. 3, 2022; 306-319. Recuperado de https://repositorio.unam.mx/contenidos/4129453

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

502.#.#.c: Universidad Nacional Autónoma de México

561.1.#.a: Instituto de Ciencias Aplicadas y Tecnología, UNAM

264.#.0.c: 2022

264.#.1.c: 2022-07-01

653.#.#.a: Relational database; NoSQL; functionality; efficiency; test model

506.1.#.a: La titularidad de los derechos patrimoniales de esta obra pertenece a las instituciones editoras. Su uso se rige por una licencia Creative Commons BY-NC-SA 4.0 Internacional, https://creativecommons.org/licenses/by-nc-sa/4.0/legalcode.es, para un uso diferente consultar al responsable jurídico del repositorio por medio del correo electrónico gabriel.ascanio@icat.unam.mx

884.#.#.k: https://jart.icat.unam.mx/index.php/jart/article/view/1169

001.#.#.#: 074.oai:ojs2.localhost:article/1169

041.#.7.h: eng

520.3.#.a: 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.

773.1.#.t: Journal of Applied Research and Technology; Vol. 20 Núm. 3 (2022); 306-319

773.1.#.o: https://jart.icat.unam.mx/index.php/jart

022.#.#.a: ISSN electrónico: 2448-6736; ISSN: 1665-6423

310.#.#.a: Bimestral

300.#.#.a: Páginas: 306-319

264.#.1.b: Instituto de Ciencias Aplicadas y Tecnología, UNAM

doi: https://doi.org/10.22201/icat.24486736e.2022.20.3.1169

harvesting_date: 2023-11-08 13:10:00.0

856.#.0.q: application/pdf

file_creation_date: 2022-06-20 19:21:09.0

file_modification_date: 2022-06-20 19:21:09.0

file_creator: Yolanda G.G.

file_name: 24f6bff4843212bb92129ce26afe254de7346d764215a37a66f0b43d19cd533a.pdf

file_pages_number: 14

file_format_version: application/pdf; version=1.7

file_size: 754007

last_modified: 2024-03-19 14:00:00

license_url: https://creativecommons.org/licenses/by-nc-sa/4.0/legalcode.es

license_type: by-nc-sa

No entro en nada

No entro en nada 2

Artículo

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

Bernal, Mary Carlota; Molina, Yeimer

Instituto de Ciencias Aplicadas y Tecnología, UNAM, publicado en Journal of Applied Research and Technology, y cosechado de Revistas UNAM

Licencia de uso

Procedencia del contenido

Cita

Bernal, Mary Carlota, et al. (2022). Test model for database architectures: an assessment for job search engine systems. Journal of Applied Research and Technology; Vol. 20 Núm. 3, 2022; 306-319. Recuperado de https://repositorio.unam.mx/contenidos/4129453

Descripción del recurso

Autor(es)
Bernal, Mary Carlota; Molina, Yeimer
Tipo
Artículo de Investigación
Área del conocimiento
Ingenierías
Título
Test model for database architectures: an assessment for job search engine systems
Fecha
2022-07-01
Resumen
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.
Tema
Relational database; NoSQL; functionality; efficiency; test model
Idioma
eng
ISSN
ISSN electrónico: 2448-6736; ISSN: 1665-6423

Enlaces