文章基本信息

标题：Benchmarking geospatial database on Kubernetes cluster
本地全文：下载
作者：Bharti Sharma ; Poonam Bansal ; Mohak Chugh 等
期刊名称：EURASIP Journal on Advances in Signal Processing
印刷版ISSN：1687-6172
电子版ISSN：1687-6180
出版年度：2021
卷号：2021
期号：1
页码：1
DOI：10.1186/s13634-021-00754-2
出版社：Hindawi Publishing Corporation
摘要：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.
关键词：Distributed data processing ; Geospatial databases ; Cluster computing ; Geospatial-data ; Geospatial-databases ; Benchmarking ; Database-as-a-service (DBaaS)