AQUA+: Query Optimization for Hybrid Database-MapReduce System

Pang, Zhifei; Wu, Sai; Huang, Haichao; Hong, Zhouzhenyan; Xie, Yuqing

doi:10.1109/icbk.2019.00034

Cited by 1 publication

(1 citation statement)

References 19 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…A hybrid database model is a database system that uses two or more different database models in a system [6] and functions as an abstraction layer that sits on top of databases, for example in the paradigms SQL and NoSQL [7]. Some benefits in using multiple database models in a system are flexibility [8], increased performance [9,10,11], logical distribution [12], their design conceived for the web [6,13].…”

Section: Introductionmentioning

confidence: 99%

Hybrid storage engine for geospatial data using NoSQL and SQL paradigms

Herrera-Ramírez¹,

Treviño-Villalobos²,

Víquez-Acuña³

2021

View full text Add to dashboard Cite

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.

show abstract