Services on Demand
Journal
Article
Indicators
Cited by SciELO
Access statistics
Related links
Similars in SciELO
Share
Computación y Sistemas
On-line version ISSN 2007-9737Print version ISSN 1405-5546
Abstract
TREVINO VILLALOBOS, Marlen; VIQUEZ ACUNA, Leonardo and QUIROS OVIEDO, Rocío. Comparison of the Response Times of MongoDB and PostgreSQL According to Type of Query in Geographical Databases. Comp. y Sist. [online]. 2020, vol.24, n.4, pp.1461-1469. Epub June 11, 2021. ISSN 2007-9737. https://doi.org/10.13053/cys-24-4-3292.
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.
Keywords : Performance evaluation; SQL; relational database; NoSQL.