<?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>1405-5546</journal-id>
<journal-title><![CDATA[Computación y Sistemas]]></journal-title>
<abbrev-journal-title><![CDATA[Comp. y Sist.]]></abbrev-journal-title>
<issn>1405-5546</issn>
<publisher>
<publisher-name><![CDATA[Instituto Politécnico Nacional, Centro de Investigación en Computación]]></publisher-name>
</publisher>
</journal-meta>
<article-meta>
<article-id>S1405-55462020000401461</article-id>
<article-id pub-id-type="doi">10.13053/cys-24-4-3292</article-id>
<title-group>
<article-title xml:lang="en"><![CDATA[Comparison of the Response Times of MongoDB and PostgreSQL According to Type of Query in Geographical Databases]]></article-title>
</title-group>
<contrib-group>
<contrib contrib-type="author">
<name>
<surname><![CDATA[Treviño Villalobos]]></surname>
<given-names><![CDATA[Marlen]]></given-names>
</name>
<xref ref-type="aff" rid="Aff"/>
</contrib>
<contrib contrib-type="author">
<name>
<surname><![CDATA[Víquez Acuña]]></surname>
<given-names><![CDATA[Leonardo]]></given-names>
</name>
<xref ref-type="aff" rid="Aff"/>
</contrib>
<contrib contrib-type="author">
<name>
<surname><![CDATA[Quirós Oviedo]]></surname>
<given-names><![CDATA[Rocío]]></given-names>
</name>
<xref ref-type="aff" rid="Aff"/>
</contrib>
</contrib-group>
<aff id="Af1">
<institution><![CDATA[,Instituto Tecnológico de Costa Rica  ]]></institution>
<addr-line><![CDATA[ ]]></addr-line>
<country>Costa Rica</country>
</aff>
<pub-date pub-type="pub">
<day>00</day>
<month>12</month>
<year>2020</year>
</pub-date>
<pub-date pub-type="epub">
<day>00</day>
<month>12</month>
<year>2020</year>
</pub-date>
<volume>24</volume>
<numero>4</numero>
<fpage>1461</fpage>
<lpage>1469</lpage>
<copyright-statement/>
<copyright-year/>
<self-uri xlink:href="http://www.scielo.org.mx/scielo.php?script=sci_arttext&amp;pid=S1405-55462020000401461&amp;lng=en&amp;nrm=iso"></self-uri><self-uri xlink:href="http://www.scielo.org.mx/scielo.php?script=sci_abstract&amp;pid=S1405-55462020000401461&amp;lng=en&amp;nrm=iso"></self-uri><self-uri xlink:href="http://www.scielo.org.mx/scielo.php?script=sci_pdf&amp;pid=S1405-55462020000401461&amp;lng=en&amp;nrm=iso"></self-uri><abstract abstract-type="short" xml:lang="en"><p><![CDATA[Abstract: A hybrid and distributed geographical database is being developed which utilizes the database engines PostgreSQL and MongoDB for later implementation in Geoserver&#8217;s architecture. In the course of the study, it was necessary to establish whether there was difference between the response times of PostgreSQL and MongoDB per type of query and the use of geographical indexes, in order to appropriately select the Database Management System to be used by the Geoserver implemented Web Map Service. After a statistical analysis with 11 different types of query, the conclusion was that the type of query affects the response time of the Database Management Systems.]]></p></abstract>
<kwd-group>
<kwd lng="en"><![CDATA[Performance evaluation]]></kwd>
<kwd lng="en"><![CDATA[SQL]]></kwd>
<kwd lng="en"><![CDATA[relational database]]></kwd>
<kwd lng="en"><![CDATA[NoSQL]]></kwd>
</kwd-group>
</article-meta>
</front><back>
<ref-list>
<ref id="B1">
<label>1</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Moreno-Jiménez]]></surname>
<given-names><![CDATA[A.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Nuevas tecnologías de la información y revalorización del conocimiento geográfico]]></article-title>
<source><![CDATA[Scripta Nova: Revista Electrónica de Geografía y Ciencias Sociales]]></source>
<year>2004</year>
<volume>8</volume>
<numero>170</numero>
<issue>170</issue>
</nlm-citation>
</ref>
<ref id="B2">
<label>2</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Ruiz]]></surname>
<given-names><![CDATA[E.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Consideraciones acerca de la explosión geográfica: Geografía colaborativa e información geográfica voluntaria acreditada]]></article-title>
<source><![CDATA[GeoFocus. Revista Internacional de Ciencia y Tecnología de la Información Geográfica]]></source>
<year>2010</year>
<numero>10</numero>
<issue>10</issue>
<page-range>280&#8211;298</page-range></nlm-citation>
</ref>
<ref id="B3">
<label>3</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Agarwal]]></surname>
<given-names><![CDATA[S.]]></given-names>
</name>
<name>
<surname><![CDATA[Rajan]]></surname>
<given-names><![CDATA[K.S.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Performance analysis of MongoDB versus PostGIS/PostGreSQL databases for line intersection and point containment spatial queries]]></article-title>
<source><![CDATA[Spatial Information Research]]></source>
<year>2016</year>
<volume>24</volume>
<page-range>671&#8211;677</page-range></nlm-citation>
</ref>
<ref id="B4">
<label>4</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Colorado-Pérez]]></surname>
<given-names><![CDATA[M.A.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[NoSQL, ¿es necesario ahora?]]></article-title>
<source><![CDATA[Tecnología Investigación Y Academia]]></source>
<year>2017</year>
<volume>5</volume>
<numero>2</numero>
<issue>2</issue>
<page-range>174&#8211;179</page-range></nlm-citation>
</ref>
<ref id="B5">
<label>5</label><nlm-citation citation-type="confpro">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Goyal]]></surname>
<given-names><![CDATA[S.]]></given-names>
</name>
<name>
<surname><![CDATA[Srivastava]]></surname>
<given-names><![CDATA[P.P.]]></given-names>
</name>
<name>
<surname><![CDATA[Kumar]]></surname>
<given-names><![CDATA[A.]]></given-names>
</name>
</person-group>
<source><![CDATA[An overview of hybrid databases]]></source>
<year>2015</year>
<conf-name><![CDATA[ International Conference on Green Computing and Internet of Things]]></conf-name>
<conf-loc> </conf-loc>
<page-range>285&#8211;288</page-range></nlm-citation>
</ref>
<ref id="B6">
<label>6</label><nlm-citation citation-type="">
<collab>The</collab>
<source><![CDATA[PostgreSQL 10.3 Released! The World's Most Advanced Open Source Database]]></source>
<year>2018</year>
</nlm-citation>
</ref>
<ref id="B7">
<label>7</label><nlm-citation citation-type="">
<collab>PostGIS</collab>
<source><![CDATA[PostGIS&#8212;Spatial and Geographic Objects for PostgreSQL]]></source>
<year>2018</year>
</nlm-citation>
</ref>
<ref id="B8">
<label>8</label><nlm-citation citation-type="">
<collab>NoSQL</collab>
<source><![CDATA[]]></source>
<year>2018</year>
</nlm-citation>
</ref>
<ref id="B9">
<label>9</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Ramírez-Arévalo]]></surname>
<given-names><![CDATA[H.H.]]></given-names>
</name>
<name>
<surname><![CDATA[Herrera-Cubides]]></surname>
<given-names><![CDATA[J.F.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Un viaje a través de bases de datos espaciales NoSQL]]></article-title>
<source><![CDATA[Redes de Ingeniería]]></source>
<year>2013</year>
<volume>4</volume>
<numero>2</numero>
<issue>2</issue>
<page-range>57&#8211;69</page-range></nlm-citation>
</ref>
<ref id="B10">
<label>10</label><nlm-citation citation-type="confpro">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Jung]]></surname>
<given-names><![CDATA[M.G.]]></given-names>
</name>
<name>
<surname><![CDATA[Youn]]></surname>
<given-names><![CDATA[S.A.]]></given-names>
</name>
<name>
<surname><![CDATA[Bae]]></surname>
<given-names><![CDATA[J.]]></given-names>
</name>
<name>
<surname><![CDATA[Choi]]></surname>
<given-names><![CDATA[Y.L.]]></given-names>
</name>
</person-group>
<source><![CDATA[A Study on Data Input and Output Performance Comparison of MongoDB and PostgreSQL in the Big Data Environment]]></source>
<year>2015</year>
<conf-name><![CDATA[ 8th International Conference on Database Theory and Application (DTA)]]></conf-name>
<conf-loc> </conf-loc>
<page-range>14&#8211;17</page-range></nlm-citation>
</ref>
<ref id="B11">
<label>11</label><nlm-citation citation-type="">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Politowski]]></surname>
<given-names><![CDATA[C.]]></given-names>
</name>
<name>
<surname><![CDATA[Maran]]></surname>
<given-names><![CDATA[V.]]></given-names>
</name>
</person-group>
<source><![CDATA[Performance entre PostgreSQL e MongoDB, X Escola Regional de Banco de Dados]]></source>
<year>2014</year>
<page-range>1&#8211;10</page-range></nlm-citation>
</ref>
<ref id="B12">
<label>12</label><nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Santos]]></surname>
<given-names><![CDATA[P.O.]]></given-names>
</name>
<name>
<surname><![CDATA[Moro]]></surname>
<given-names><![CDATA[M.M.]]></given-names>
</name>
<name>
<surname><![CDATA[Davis]]></surname>
<given-names><![CDATA[C.A.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Comparative Performance Evaluation of Relational and NoSQL Databases for Spatial and Mobile Applications]]></article-title>
<person-group person-group-type="editor">
<name>
<surname><![CDATA[Chen]]></surname>
<given-names><![CDATA[Q.]]></given-names>
</name>
<name>
<surname><![CDATA[Hameurlain]]></surname>
<given-names><![CDATA[A.]]></given-names>
</name>
<name>
<surname><![CDATA[Toumani]]></surname>
<given-names><![CDATA[F.]]></given-names>
</name>
<name>
<surname><![CDATA[Wagner]]></surname>
<given-names><![CDATA[R.]]></given-names>
</name>
<name>
<surname><![CDATA[Decker]]></surname>
<given-names><![CDATA[H.]]></given-names>
</name>
</person-group>
<source><![CDATA[Database and Expert Systems Applications. Globe´15, DEXA´15]]></source>
<year>2015</year>
<volume>9261</volume>
<publisher-name><![CDATA[Lecture Notes in Computer Science]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B13">
<label>13</label><nlm-citation citation-type="">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Orellana-Cordero]]></surname>
<given-names><![CDATA[M.]]></given-names>
</name>
<name>
<surname><![CDATA[Vele-Zhingri]]></surname>
<given-names><![CDATA[C.A.]]></given-names>
</name>
</person-group>
<source><![CDATA[Análisis de rendimiento para bases de datos geográficas: PostgreSQL vs MongoDB. de COMPDES]]></source>
<year>2018</year>
</nlm-citation>
</ref>
<ref id="B14">
<label>14</label><nlm-citation citation-type="confpro">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Slutz]]></surname>
<given-names><![CDATA[D.R.]]></given-names>
</name>
</person-group>
<source><![CDATA[Massive stochastic testing of SQL]]></source>
<year>1998</year>
<conf-name><![CDATA[ 24th Very Large Data Base Conference (VLDB)]]></conf-name>
<conf-loc> </conf-loc>
</nlm-citation>
</ref>
<ref id="B15">
<label>15</label><nlm-citation citation-type="book">
<collab>Apache Software Foundation</collab>
<source><![CDATA[JMeter]]></source>
<year>2017</year>
<publisher-name><![CDATA[Apache]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B16">
<label>16</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Patel]]></surname>
<given-names><![CDATA[B.]]></given-names>
</name>
<name>
<surname><![CDATA[Parikh]]></surname>
<given-names><![CDATA[J.]]></given-names>
</name>
<name>
<surname><![CDATA[Shah]]></surname>
<given-names><![CDATA[R.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[A Review Paper on Comparison of SQL Performance Analyzer Tools: Apache JMeter and HP LoadRunner]]></article-title>
<source><![CDATA[International Journal of Current Engineering and Technology]]></source>
<year>2014</year>
<volume>4</volume>
<numero>5</numero>
<issue>5</issue>
<page-range>3642&#8211;3645</page-range></nlm-citation>
</ref>
<ref id="B17">
<label>17</label><nlm-citation citation-type="confpro">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Díaz]]></surname>
<given-names><![CDATA[F.J.]]></given-names>
</name>
<name>
<surname><![CDATA[Banchoff-Tzancoff]]></surname>
<given-names><![CDATA[C.M.]]></given-names>
</name>
<name>
<surname><![CDATA[Rodríguez]]></surname>
<given-names><![CDATA[A.S.]]></given-names>
</name>
<name>
<surname><![CDATA[Soria]]></surname>
<given-names><![CDATA[V.]]></given-names>
</name>
</person-group>
<source><![CDATA[Usando Jmeter para pruebas de rendimiento]]></source>
<year>2008</year>
<conf-name><![CDATA[ XIV Congreso Argentino de Ciencias de la Computación]]></conf-name>
<conf-loc> </conf-loc>
</nlm-citation>
</ref>
<ref id="B18">
<label>18</label><nlm-citation citation-type="book">
<collab>ESRI</collab>
<source><![CDATA[Shapefile Technical Description]]></source>
<year>1998</year>
<publisher-name><![CDATA[ESRI White Paper]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B19">
<label>19</label><nlm-citation citation-type="">
<collab>Instituto</collab>
<source><![CDATA[IDE Región Huetar Norte]]></source>
<year>2017</year>
</nlm-citation>
</ref>
<ref id="B20">
<label>20</label><nlm-citation citation-type="">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Butler]]></surname>
<given-names><![CDATA[H.]]></given-names>
</name>
<name>
<surname><![CDATA[Daly]]></surname>
<given-names><![CDATA[M.]]></given-names>
</name>
<name>
<surname><![CDATA[Doyle]]></surname>
<given-names><![CDATA[A.]]></given-names>
</name>
<name>
<surname><![CDATA[Gillies]]></surname>
<given-names><![CDATA[S.]]></given-names>
</name>
<name>
<surname><![CDATA[Schaub]]></surname>
<given-names><![CDATA[T.]]></given-names>
</name>
<name>
<surname><![CDATA[Schmidt]]></surname>
<given-names><![CDATA[C.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[The GeoJSON format specification]]></article-title>
<source><![CDATA[Rapport Technique]]></source>
<year>2008</year>
</nlm-citation>
</ref>
<ref id="B21">
<label>21</label><nlm-citation citation-type="">
<collab>QGIS</collab>
<source><![CDATA[Bienvenido Al Proyecto QGIS!]]></source>
<year>2018</year>
</nlm-citation>
</ref>
<ref id="B22">
<label>22</label><nlm-citation citation-type="">
<collab>Mongodb</collab>
<source><![CDATA[Geospatial Queries - MongoDB Manual 3.6]]></source>
<year>2018</year>
</nlm-citation>
</ref>
<ref id="B23">
<label>23</label><nlm-citation citation-type="confpro">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Schmid]]></surname>
<given-names><![CDATA[S.]]></given-names>
</name>
<name>
<surname><![CDATA[Galicz]]></surname>
<given-names><![CDATA[E.]]></given-names>
</name>
<name>
<surname><![CDATA[Reinhardt]]></surname>
<given-names><![CDATA[W.]]></given-names>
</name>
</person-group>
<source><![CDATA[WMS performance of selected SQL and NoSQL databases]]></source>
<year>2015</year>
<conf-name><![CDATA[ International Conference on Military Technologies]]></conf-name>
<conf-loc> </conf-loc>
<page-range>1&#8211;16</page-range></nlm-citation>
</ref>
<ref id="B24">
<label>24</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Suárez]]></surname>
<given-names><![CDATA[M.J.]]></given-names>
</name>
<name>
<surname><![CDATA[Tuya]]></surname>
<given-names><![CDATA[J.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Coverage Measurement for SQL Queries]]></article-title>
<source><![CDATA[IEEE Latin America Transactions]]></source>
<year>2005</year>
<volume>3</volume>
<numero>1</numero>
<issue>1</issue>
<page-range>49&#8211;55</page-range></nlm-citation>
</ref>
<ref id="B25">
<label>25</label><nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Ramsey]]></surname>
<given-names><![CDATA[P.]]></given-names>
</name>
</person-group>
<source><![CDATA[Postgis Manual]]></source>
<year>2005</year>
<volume>17</volume>
<publisher-name><![CDATA[Refractions Research Inc.]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B26">
<label>26</label><nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Membrey]]></surname>
<given-names><![CDATA[P.]]></given-names>
</name>
<name>
<surname><![CDATA[Plugge]]></surname>
<given-names><![CDATA[E.]]></given-names>
</name>
<name>
<surname><![CDATA[Hawkins]]></surname>
<given-names><![CDATA[D.]]></given-names>
</name>
</person-group>
<source><![CDATA[The definitive guide to MongoDB: the noSQL database for cloud and desktop computing]]></source>
<year>2011</year>
<publisher-name><![CDATA[Apress]]></publisher-name>
</nlm-citation>
</ref>
<ref id="B27">
<label>27</label><nlm-citation citation-type="">
<collab>MongoDB</collab>
<source><![CDATA[The MongoDB 3.4 Manual]]></source>
<year>2017</year>
</nlm-citation>
</ref>
<ref id="B28">
<label>28</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Anderson]]></surname>
<given-names><![CDATA[T.W.]]></given-names>
</name>
<name>
<surname><![CDATA[Darling]]></surname>
<given-names><![CDATA[D.A.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[A test of goodness of fit]]></article-title>
<source><![CDATA[Journal of the American Statistical Association]]></source>
<year>1954</year>
<volume>49</volume>
<numero>268</numero>
<issue>268</issue>
<page-range>765&#8211;769</page-range></nlm-citation>
</ref>
<ref id="B29">
<label>29</label><nlm-citation citation-type="journal">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Anderson]]></surname>
<given-names><![CDATA[T.W.]]></given-names>
</name>
<name>
<surname><![CDATA[Darling]]></surname>
<given-names><![CDATA[D.A.]]></given-names>
</name>
</person-group>
<article-title xml:lang=""><![CDATA[Asymptotic theory of certain "goodness of fit" criteria based on stochastic processes]]></article-title>
<source><![CDATA[The Annals of Mathematical Statistics]]></source>
<year>1952</year>
<volume>23</volume>
<numero>2</numero>
<issue>2</issue>
<page-range>193&#8211; 212</page-range></nlm-citation>
</ref>
<ref id="B30">
<label>30</label><nlm-citation citation-type="book">
<person-group person-group-type="author">
<name>
<surname><![CDATA[Schmid]]></surname>
<given-names><![CDATA[S.]]></given-names>
</name>
<name>
<surname><![CDATA[Galicz]]></surname>
<given-names><![CDATA[E.]]></given-names>
</name>
<name>
<surname><![CDATA[Reinhardt]]></surname>
<given-names><![CDATA[W.]]></given-names>
</name>
</person-group>
<source><![CDATA[Performance investigation of selected SQL and NoSQL databases]]></source>
<year>2015</year>
<publisher-name><![CDATA[AGILE/15]]></publisher-name>
</nlm-citation>
</ref>
</ref-list>
</back>
</article>
