<?xml version="1.0" encoding="ISO-8859-1"?><article xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<front>
<journal-meta>
<journal-id>1665-6423</journal-id>
<journal-title><![CDATA[Journal of applied research and technology]]></journal-title>
<abbrev-journal-title><![CDATA[J. appl. res. technol]]></abbrev-journal-title>
<issn>1665-6423</issn>
<publisher>
<publisher-name><![CDATA[Universidad Nacional Autónoma de México, Instituto de Ciencias Aplicadas y Tecnología]]></publisher-name>
</publisher>
</journal-meta>
<article-meta>
<article-id>S1665-64232022000300306</article-id>
<article-id pub-id-type="doi">10.22201/icat.24486736e.2022.20.3.1169</article-id>
<title-group>
<article-title xml:lang="en"><![CDATA[A test model for database architectures: an assessment for job search engine systems]]></article-title>
</title-group>
<contrib-group>
<contrib contrib-type="author">
<name>
<surname><![CDATA[Bernal]]></surname>
<given-names><![CDATA[Mary Carlota]]></given-names>
</name>
<xref ref-type="aff" rid="Aff"/>
</contrib>
<contrib contrib-type="author">
<name>
<surname><![CDATA[Molina]]></surname>
<given-names><![CDATA[Yeimer]]></given-names>
</name>
<xref ref-type="aff" rid="Aff"/>
</contrib>
</contrib-group>
<aff id="Af1">
<institution><![CDATA[,Universidad Simón Bolívar Facultad de Ingenierías ]]></institution>
<addr-line><![CDATA[Cúcuta ]]></addr-line>
<country>Colombia</country>
</aff>
<aff id="Af2">
<institution><![CDATA[,Universidad Nacional Experimental del Táchira Laboratorio de Investigación y Desarrollo en Informática ]]></institution>
<addr-line><![CDATA[San Cristóbal ]]></addr-line>
<country>Venezuela</country>
</aff>
<pub-date pub-type="pub">
<day>00</day>
<month>00</month>
<year>2022</year>
</pub-date>
<pub-date pub-type="epub">
<day>00</day>
<month>00</month>
<year>2022</year>
</pub-date>
<volume>20</volume>
<numero>3</numero>
<fpage>306</fpage>
<lpage>319</lpage>
<copyright-statement/>
<copyright-year/>
<self-uri xlink:href="http://www.scielo.org.mx/scielo.php?script=sci_arttext&amp;pid=S1665-64232022000300306&amp;lng=en&amp;nrm=iso"></self-uri><self-uri xlink:href="http://www.scielo.org.mx/scielo.php?script=sci_abstract&amp;pid=S1665-64232022000300306&amp;lng=en&amp;nrm=iso"></self-uri><self-uri xlink:href="http://www.scielo.org.mx/scielo.php?script=sci_pdf&amp;pid=S1665-64232022000300306&amp;lng=en&amp;nrm=iso"></self-uri><abstract abstract-type="short" xml:lang="en"><p><![CDATA[Abstract 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.]]></p></abstract>
<kwd-group>
<kwd lng="en"><![CDATA[Relational database]]></kwd>
<kwd lng="en"><![CDATA[NoSQL]]></kwd>
<kwd lng="en"><![CDATA[functionality]]></kwd>
<kwd lng="en"><![CDATA[efficiency]]></kwd>
<kwd lng="en"><![CDATA[test model]]></kwd>
<kwd lng="en"><![CDATA[job search engine systems]]></kwd>
</kwd-group>
</article-meta>
</front><back>
<ref-list>
<ref id="B1">
<nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Antaño]]></surname>
<given-names><![CDATA[A. C. M.]]></given-names>
</name>
<name>
<surname><![CDATA[Castro]]></surname>
<given-names><![CDATA[J. M. M.]]></given-names>
</name>
<name>
<surname><![CDATA[Valencia]]></surname>
<given-names><![CDATA[R. E. C.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Migración de Bases de Datos SQL a NoSQL]]></article-title>
<source><![CDATA[Tlamati]]></source>
<year>2014</year>
<numero>Especial 3</numero>
<issue>Especial 3</issue>
<page-range>144-8</page-range><publisher-name><![CDATA[CICOM]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B2">
<nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Beach]]></surname>
<given-names><![CDATA[P. M.]]></given-names>
</name>
<name>
<surname><![CDATA[Langhals]]></surname>
<given-names><![CDATA[B. T.]]></given-names>
</name>
<name>
<surname><![CDATA[Grimaila]]></surname>
<given-names><![CDATA[M. R.]]></given-names>
</name>
<name>
<surname><![CDATA[Hodson]]></surname>
<given-names><![CDATA[D. D.]]></given-names>
</name>
<name>
<surname><![CDATA[Engle]]></surname>
<given-names><![CDATA[R. D. L.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[A Methodology to Identify Alternative Suitable NoSQL Data Models via Observation of Relational Database Interactions]]></article-title>
<source><![CDATA[Theses and Dissertations]]></source>
<year>2020</year>
</nlm-citation>
</ref>
<ref id="B3">
<nlm-citation citation-type="">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Bugiotti]]></surname>
<given-names><![CDATA[F.]]></given-names>
</name>
<name>
<surname><![CDATA[Cabibbo]]></surname>
<given-names><![CDATA[L.]]></given-names>
</name>
<name>
<surname><![CDATA[Atzeni]]></surname>
<given-names><![CDATA[P.]]></given-names>
</name>
<name>
<surname><![CDATA[Torlone]]></surname>
<given-names><![CDATA[R.]]></given-names>
</name>
</person-group>
<source><![CDATA[Database design for NoSQL systems]]></source>
<year>2014</year>
<volume>8824</volume>
<page-range>223-31</page-range></nlm-citation>
</ref>
<ref id="B4">
<nlm-citation citation-type="">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Codd]]></surname>
<given-names><![CDATA[E. F.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[A data base sublanguage founded on the relational calculus]]></article-title>
<source><![CDATA[Proceedings of the 1971 ACM SIGFIDET (now SIGMOD) workshop on data description, access and control]]></source>
<year>1971</year>
<page-range>35-68</page-range></nlm-citation>
</ref>
<ref id="B5">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Date]]></surname>
<given-names><![CDATA[C. J.]]></given-names>
</name>
</person-group>
<source><![CDATA[An Introduction to Database Systems]]></source>
<year>2000</year>
<edition>7</edition>
<publisher-name><![CDATA[eBook Addison-Wesley Longman Publishing Co., Inc.]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B6">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Ercan]]></surname>
<given-names><![CDATA[M. Z.]]></given-names>
</name>
<name>
<surname><![CDATA[Lane]]></surname>
<given-names><![CDATA[M.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[An evaluation of NoSQL databases for EHR systems]]></article-title>
<source><![CDATA[Proceedings of the 25th Australasian Conference on Information Systems]]></source>
<year>2014</year>
<publisher-name><![CDATA[Auckland University of Technology]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B7">
<nlm-citation citation-type="">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Fouad]]></surname>
<given-names><![CDATA[T.]]></given-names>
</name>
<name>
<surname><![CDATA[Mohamed]]></surname>
<given-names><![CDATA[B.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Model Transformation From Object Relational Database to NoSQL Document Database]]></article-title>
<source><![CDATA[Proceedings of the 2nd International Conference on Networking, Information Systems &amp; Security]]></source>
<year>2019</year>
<page-range>1-5</page-range></nlm-citation>
</ref>
<ref id="B8">
<nlm-citation citation-type="">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Fraczek]]></surname>
<given-names><![CDATA[K.]]></given-names>
</name>
<name>
<surname><![CDATA[Plechawska-Wojcik]]></surname>
<given-names><![CDATA[M.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Comparative analysis of relational and non-relational databases in the context of performance in web applications]]></article-title>
<source><![CDATA[International Conference: Beyond Databases, Architectures and Structures]]></source>
<year>2017</year>
<volume>716</volume>
<page-range>153-64</page-range></nlm-citation>
</ref>
<ref id="B9">
<nlm-citation citation-type="">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Ghotiya]]></surname>
<given-names><![CDATA[S.]]></given-names>
</name>
<name>
<surname><![CDATA[Mandal]]></surname>
<given-names><![CDATA[J.]]></given-names>
</name>
<name>
<surname><![CDATA[Kandasamy]]></surname>
<given-names><![CDATA[S.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Migration from relational to NoSQL database]]></article-title>
<source><![CDATA[IOP Conference Series: Materials Science and Engineering]]></source>
<year>2017</year>
<volume>263</volume>
<numero>4</numero>
<issue>4</issue>
</nlm-citation>
</ref>
<ref id="B10">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Han]]></surname>
<given-names><![CDATA[J.]]></given-names>
</name>
<name>
<surname><![CDATA[Haihong]]></surname>
<given-names><![CDATA[E.]]></given-names>
</name>
<name>
<surname><![CDATA[Le]]></surname>
<given-names><![CDATA[G.]]></given-names>
</name>
<name>
<surname><![CDATA[Du]]></surname>
<given-names><![CDATA[J.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Survey on NoSQL database]]></article-title>
<source><![CDATA[2011 6th International Conference on Pervasive Computing and Applications]]></source>
<year>2011</year>
<page-range>363-6</page-range><publisher-name><![CDATA[IEEE]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B11">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Hows]]></surname>
<given-names><![CDATA[D.]]></given-names>
</name>
<name>
<surname><![CDATA[Membrey]]></surname>
<given-names><![CDATA[P.]]></given-names>
</name>
<name>
<surname><![CDATA[Plugge]]></surname>
<given-names><![CDATA[E.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[MongoDB Basics]]></article-title>
<source><![CDATA[MongoDB Basics]]></source>
<year>2014</year>
<publisher-name><![CDATA[Apress]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B12">
<nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Imam]]></surname>
<given-names><![CDATA[A. A.]]></given-names>
</name>
<name>
<surname><![CDATA[Basri]]></surname>
<given-names><![CDATA[S.]]></given-names>
</name>
<name>
<surname><![CDATA[Ahmad]]></surname>
<given-names><![CDATA[R.]]></given-names>
</name>
<name>
<surname><![CDATA[González-Aparicio]]></surname>
<given-names><![CDATA[M. T.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Schema proposition model for NoSQL applications]]></article-title>
<source><![CDATA[Advances in Intelligent Systems and Computing]]></source>
<year>2019</year>
<volume>843</volume>
<page-range>30-9</page-range></nlm-citation>
</ref>
<ref id="B13">
<nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Imam]]></surname>
<given-names><![CDATA[A. A.]]></given-names>
</name>
<name>
<surname><![CDATA[Basri]]></surname>
<given-names><![CDATA[S.]]></given-names>
</name>
<name>
<surname><![CDATA[Ahmad]]></surname>
<given-names><![CDATA[R.]]></given-names>
</name>
<name>
<surname><![CDATA[Watada]]></surname>
<given-names><![CDATA[J.]]></given-names>
</name>
<name>
<surname><![CDATA[González-Aparicio]]></surname>
<given-names><![CDATA[M. T.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Automatic schema suggestion model for NoSQL document-stores databases]]></article-title>
<source><![CDATA[Journal of Big Data]]></source>
<year>2018</year>
<volume>5</volume>
<numero>1</numero>
<issue>1</issue>
<page-range>46</page-range></nlm-citation>
</ref>
<ref id="B14">
<nlm-citation citation-type="">
<collab>ISO</collab>
<source><![CDATA[ISO/IEC. Systems and software engineering - Systems and software Quality Requirements and Evaluation (SQuaRE) - Guide to SQuaRE]]></source>
<year>2014</year>
</nlm-citation>
</ref>
<ref id="B15">
<nlm-citation citation-type="">
<collab>International Software Testing Qualifications Board</collab>
<source><![CDATA[Downloads - ISTQB® International Software Testing Qualifications Board]]></source>
<year>2019</year>
</nlm-citation>
</ref>
<ref id="B16">
<nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Kumar]]></surname>
<given-names><![CDATA[M. S.]]></given-names>
</name>
<name>
<surname><![CDATA[. Jayagopal]]></surname>
<given-names><![CDATA[P.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Comparison of NoSQL Database and Traditional Database-An emphatic analysis]]></article-title>
<source><![CDATA[JOIV : International Journal on Informatics Visualization]]></source>
<year>2018</year>
<volume>2</volume>
<numero>2</numero>
<issue>2</issue>
<page-range>51</page-range></nlm-citation>
</ref>
<ref id="B17">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Marqués]]></surname>
<given-names><![CDATA[M.]]></given-names>
</name>
</person-group>
<source><![CDATA[Bases de datos]]></source>
<year>2011</year>
<edition>Primera</edition>
<publisher-name><![CDATA[Publicacions de la Universitat Jaume I. Servei de Comunicació i Publicacions]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B18">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Mearaj]]></surname>
<given-names><![CDATA[I.]]></given-names>
</name>
<name>
<surname><![CDATA[Maheshwari]]></surname>
<given-names><![CDATA[P.]]></given-names>
</name>
<name>
<surname><![CDATA[Kaur]]></surname>
<given-names><![CDATA[M. J.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Data conversion from Traditional Relational Database to MongoDB using XAMPP and NoSQL]]></article-title>
<source><![CDATA[2018 Fifth HCT Information Technology Trends (ITT)]]></source>
<year>2019</year>
<page-range>94-8</page-range><publisher-name><![CDATA[IEEE]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B19">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Ramez]]></surname>
<given-names><![CDATA[Elmasri]]></given-names>
</name>
<name>
<surname><![CDATA[Shamkant]]></surname>
<given-names><![CDATA[Navathe]]></given-names>
</name>
<name>
<surname><![CDATA[Dissano]]></surname>
<given-names><![CDATA[S.]]></given-names>
</name>
</person-group>
<source><![CDATA[Fundamentals of Database Systems]]></source>
<year>2022</year>
<edition>7</edition>
<publisher-loc><![CDATA[USA ]]></publisher-loc>
<publisher-name><![CDATA[Pearson]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B20">
<nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Paredaens]]></surname>
<given-names><![CDATA[J.]]></given-names>
</name>
<name>
<surname><![CDATA[De Bra]]></surname>
<given-names><![CDATA[P.]]></given-names>
</name>
<name>
<surname><![CDATA[Gyssens]]></surname>
<given-names><![CDATA[M.]]></given-names>
</name>
<name>
<surname><![CDATA[Van Gucht]]></surname>
<given-names><![CDATA[D.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Relational Database Model. In The Structure of the Relational Database Model]]></article-title>
<source><![CDATA[EATCS Monographs on Theoretical Computer Science]]></source>
<year>1989</year>
<volume>17</volume>
</nlm-citation>
</ref>
<ref id="B21">
<nlm-citation citation-type="">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Scherzinger]]></surname>
<given-names><![CDATA[S.]]></given-names>
</name>
<name>
<surname><![CDATA[Klettke]]></surname>
<given-names><![CDATA[M.]]></given-names>
</name>
<name>
<surname><![CDATA[Störl]]></surname>
<given-names><![CDATA[U.]]></given-names>
</name>
</person-group>
<source><![CDATA[Managing schema evolution in NoSQL data stores]]></source>
<year>2013</year>
</nlm-citation>
</ref>
<ref id="B22">
<nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Schreiner]]></surname>
<given-names><![CDATA[G. A.]]></given-names>
</name>
<name>
<surname><![CDATA[Duarte]]></surname>
<given-names><![CDATA[D.]]></given-names>
</name>
<name>
<surname><![CDATA[dos Santos Mello]]></surname>
<given-names><![CDATA[R.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Bringing SQL databases to key-based NoSQL databases: a canonical approach]]></article-title>
<source><![CDATA[Computing]]></source>
<year>2020</year>
<volume>102</volume>
<numero>1</numero>
<issue>1</issue>
<page-range>221-46</page-range></nlm-citation>
</ref>
<ref id="B23">
<nlm-citation citation-type="">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Sokolova]]></surname>
<given-names><![CDATA[M. V.]]></given-names>
</name>
<name>
<surname><![CDATA[Gómez]]></surname>
<given-names><![CDATA[F. J.]]></given-names>
</name>
<name>
<surname><![CDATA[Borisoglebskaya]]></surname>
<given-names><![CDATA[L. N.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Migration from an SQL to a hybrid SQL/NoSQL data model]]></article-title>
<source><![CDATA[Journal of Management Analytics]]></source>
<year>2020</year>
<volume>7</volume>
<numero>1</numero>
<issue>1</issue>
<page-range>1-11</page-range></nlm-citation>
</ref>
<ref id="B24">
<nlm-citation citation-type="">
<collab>The PostgreSQL Global Development Group</collab>
<source><![CDATA[The world&#8217;s most advanced open source database]]></source>
<year>2013</year>
</nlm-citation>
</ref>
<ref id="B25">
<nlm-citation citation-type="">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Tziatzios]]></surname>
<given-names><![CDATA[D.]]></given-names>
</name>
</person-group>
<source><![CDATA[Model-based Testing for SQL Databases]]></source>
<year>2019</year>
</nlm-citation>
</ref>
<ref id="B26">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Wijaya]]></surname>
<given-names><![CDATA[Y. S.]]></given-names>
</name>
<name>
<surname><![CDATA[Arman]]></surname>
<given-names><![CDATA[A. A.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[A framework for data migration between different datastore of NoSQL database]]></article-title>
<source><![CDATA[2018 International Conference on ICT for Smart Society (ICISS)]]></source>
<year>2018</year>
<page-range>1-6</page-range><publisher-name><![CDATA[IEEE]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B27">
<nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Zafar]]></surname>
<given-names><![CDATA[R.]]></given-names>
</name>
<name>
<surname><![CDATA[Yafi]]></surname>
<given-names><![CDATA[E.]]></given-names>
</name>
<name>
<surname><![CDATA[Zuhairi]]></surname>
<given-names><![CDATA[M. F.]]></given-names>
</name>
<name>
<surname><![CDATA[Dao]]></surname>
<given-names><![CDATA[H.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Big data: the NoSQL and RDBMS review]]></article-title>
<source><![CDATA[2016 International Conference on Information and Communication Technology (ICICTM)]]></source>
<year>2016</year>
<page-range>120-6</page-range><publisher-name><![CDATA[IEEE]]></publisher-name>
</nlm-citation>
</ref>
</ref-list>
</back>
</article>
