Benchmarking geospatial database on Kubernetes cluster

EURASIP journal on advances in signal processing

article

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

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

关键词: Distributed data processing;    Geospatial databases;    Cluster computing;    Geospatial-data;    Geospatial-databases;    Benchmarking;    Database-as-a-service (DBaaS);   

DOI  :  10.1186/s13634-021-00754-2

来源: SpringerOpen

【 摘 要 】

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.

【 授权许可】

CC BY