Hybrid storage engine for geospatial data using NoSQL and SQL paradigms
সংরক্ষণ করুন:
| লেখক: | , , |
|---|---|
| বিন্যাস: | artículo original |
| বর্তমান অবস্থা: | Versión publicada |
| প্রকাশনার তারিখ: | 2021 |
| বিবরন: | 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. |
| দেশ: | Portal de Revistas TEC |
| প্রতিষ্ঠান: | Instituto Tecnológico de Costa Rica |
| Repositorio: | Portal de Revistas TEC |
| ভাষা: | Inglés |
| OAI Identifier: | oai:ojs.pkp.sfu.ca:article/4822 |
| অনলাইন ব্যবহার করুন: | https://revistas.tec.ac.cr/index.php/tec_marcha/article/view/4822 |
| মুখ্য শব্দ: | Database SQL NoSQL ToroDB MongoDB PostgreSQL Replication Mirroring Base de datos replicación base de datos espejo |