Comparison of the Response Times of MongoDB and PostgreSQL According to Type of Query in Geographical Databases

Authors

  • Marlen Treviño Villalobos Instituto Tecnológico de Costa Rica
  • Leonardo Víquez Acuña Instituto Tecnológico de Costa Rica
  • Rocío Quirós Oviedo Instituto Tecnológico de Costa Rica

DOI:

https://doi.org/10.13053/cys-24-4-3292

Keywords:

Performance evaluation, SQL, relational database, NoSQL

Abstract

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.

Author Biographies

Marlen Treviño Villalobos, Instituto Tecnológico de Costa Rica

Carrera de Ingeniería en Computación, Docente e investigadora

Leonardo Víquez Acuña, Instituto Tecnológico de Costa Rica

Carrera de Ingeniería en Computación, Docente e investigador

Rocío Quirós Oviedo, Instituto Tecnológico de Costa Rica

Carrera de Ingeniería en Computación, Docente e investigadora

Downloads

Published

2020-12-02

Issue

Vol. 24 No. 4 (2020): 24(4)2020

Section

Articles

License 

Hereby I transfer exclusively to the Journal "Computación y 
Sistemas", published by the Computing Research Center (CIC-IPN),
the Copyright of the aforementioned paper. I also accept that these 
rights will not be transferred to any other publication, in any other 
format, language or other existing means of developing.
I certify that the paper has not been previously disclosed or simultaneo
usly submitted to any other publication, and that it does not contain 
material whose publication would violate the Copyright or other 
proprietary rights of any person, company or institution. I certify that 
I have the permission from the institution or company where I work or 
study to publish this work.
The representative author accepts the responsibility for the publication
of this paper on behalf of each and every one of the authors. 
This transfer is subject to the following conditions:
  • The authors retain all ownership rights (such as patent rights) of this work, except for the publishing rights transferred to the CIC, through this document.
  • Authors retain the right to publish the work in whole or in part in any book they are the authors or publishers. They can also make use of this work in conferences, courses, personal web pages, and so on.
  • Authors may include working as part of his thesis, for non-profit distribution only.