SciELO - Scientific Electronic Library Online

vol.34 número1Monoclonal antibodies and the treatment of systemic lupus erythematosusSequencing of operations by simulation in the company Puntadas, S.G. índice de autoresíndice de assuntospesquisa de artigos
Home Pagelista alfabética de periódicos  

Serviços Personalizados




Links relacionados

  • Não possue artigos similaresSimilares em SciELO


Revista Tecnología en Marcha

versão On-line ISSN 0379-3982versão impressa ISSN 0379-3982


HERRERA-RAMIREZ, José A.; TREVINO-VILLALOBOS, Marlen  e  VIQUEZ-ACUNA, Leonardo. Hybrid storage engine for geospatial data using NoSQL and SQL paradigms. Tecnología en Marcha [online]. 2021, vol.34, n.1, pp.40-54. ISSN 0379-3982.

The design and implementation of services to handle geospatial data involves thinking about storage engine performance and optimization for the desired use. NoSQL and relational databases bring their own advantages; therefore, it is necessary to choose one of these options according to the requirements of the solution. These requirements can change, or some operations may be performed in a more efficient way on another database engine, so using just one engine means being tied to its features and work model. This paper presents a hybrid approach (NoSQL-SQL) to store geospatial data on MongoDB, which are replicated and mapped on a PostgreSQL database, using an open source tool called ToroDB Stampede; solutions then can take advantage from either NoSQL or SQL features, to satisfy most of the requirements associated to the storage engine performance. A descriptive analysis to explain the workflow of the replication and synchronization in both engines precedes the quantitative analysis by which it was possible to determine that a normal database in PostgreSQL has a shorter response time than to perform the query in PostgreSQL with the hybrid database. In addition, the type of geometry increases the update response time of a materialized view.

Palavras-chave : Database; SQL; NoSQL; ToroDB; MongoDB; PostgreSQL; replication; mirroring.

        · resumo em Espanhol     · texto em Inglês     · Inglês ( pdf )