Benchmarking geospatial database on Kubernetes cluster

EURASIP Journal on Advances in Signal Processing

Achin Jain¹  Qiaozhi Hua²  Bharti Sharma³  Adisakshya Chauhan³  Poonam Bansal³  Mohak Chugh³  Prateek Anand⁴ 

[1] Bharati Vidyapeeth’s College of Engineering;Computer School, Hubei University of Arts and Science;MSIT, GGSIPU;NSUT;

关键词: Distributed data processing;    Geospatial databases;    Cluster computing;    Geospatial-data;    Geospatial-databases;    Benchmarking;   

DOI  :  10.1186/s13634-021-00754-2

来源: DOAJ

【 摘 要 】

Abstract Kubernetes is an open-source container orchestration system for automating container application operations and has been considered to deploy various kinds of container workloads. Traditional geo-databases face frequent scalability issues while dealing with dense and complex spatial data. Despite plenty of research work in the comparison of relational and NoSQL databases in handling geospatial data, there is a shortage of existing knowledge about the performance of geo-database in a clustered environment like Kubernetes. This paper presents benchmarking of PostgreSQL/PostGIS geospatial databases operating on a clustered environment against non-clustered environments. The benchmarking process considers the average execution times of geospatial structured query language (SQL) queries on multiple hardware configurations to compare the environments based on handling computationally expensive queries involving SQL operations and PostGIS functions. The geospatial queries operate on data imported from OpenStreetMap into PostgreSQL/PostGIS. The clustered environment powered by Kubernetes demonstrated promising improvements in the average execution times of computationally expensive geospatial SQL queries on all considered hardware configurations compared to their average execution times in non-clustered environments.

【 授权许可】

Unknown