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

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.