TY - JOUR
T1 - Comparison of the response times of mongodb and postgresql according to type of query in geographical databases
AU - Villalobos, Marlen Treviño
AU - Acuña, Leonardo Víquez
AU - Oviedo, Rocío Quirós
N1 - Publisher Copyright:
© 2020 Instituto Politecnico Nacional. All rights reserved.
PY - 2020
Y1 - 2020
N2 - A hybrid and distributed geographical database is being developed which utilizes the database engines PostgreSQL and MongoDB for later implementation in Geoserver’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.
AB - A hybrid and distributed geographical database is being developed which utilizes the database engines PostgreSQL and MongoDB for later implementation in Geoserver’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.
KW - NoSQL
KW - Performance evaluation
KW - Relational database
KW - SQL
UR - http://www.scopus.com/inward/record.url?scp=85098748638&partnerID=8YFLogxK
U2 - 10.13053/CYS-24-4-3292
DO - 10.13053/CYS-24-4-3292
M3 - Artículo
AN - SCOPUS:85098748638
SN - 1405-5546
VL - 24
SP - 1461
EP - 1469
JO - Computacion y Sistemas
JF - Computacion y Sistemas
IS - 4
ER -