{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,12,21]],"date-time":"2025-12-21T10:04:53Z","timestamp":1766311493506,"version":"3.41.0"},"reference-count":37,"publisher":"Springer Science and Business Media LLC","issue":"2","license":[{"start":{"date-parts":[[2025,4,30]],"date-time":"2025-04-30T00:00:00Z","timestamp":1745971200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0"},{"start":{"date-parts":[[2025,4,30]],"date-time":"2025-04-30T00:00:00Z","timestamp":1745971200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0"}],"funder":[{"DOI":"10.13039\/501100006256","name":"Universit\u00e0 degli Studi dell\u2019Aquila","doi-asserted-by":"crossref","id":[{"id":"10.13039\/501100006256","id-type":"DOI","asserted-by":"crossref"}]}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["J Grid Computing"],"published-print":{"date-parts":[[2025,6]]},"abstract":"<jats:title>Abstract<\/jats:title>\n          <jats:p>In the rapid evolution of digitization, geoservices such as Geographical Information Systems are re-emerging as a design tool for innovation, change, and policy development, while traditional databases struggle to handle geodata. Scaling these services can be complex, time-consuming, and computationally intensive. Relying on cloud-based solutions, there is a lack of knowledge about (geo-)database performance in the cluster environment Kubernetes, an open-source orchestrator designed to simplify the deployment, scalability, and operation of containerized applications. However, the integration of geoservices into cloud-edge technologies presents challenges in task scheduling and service placement, thus requiring new management strategies. In this respect, distributed computing offers opportunities, but may introduce network delays that degrade the Quality of Service; such latency is minimized by Multi-access Edge Computing standard technology. This research work presents an experimental comparative analysis for PostgreSQL\/PostGIS relational database geoservices operating in a cluster versus non-cluster environment, focusing on the data management layer. Performance evaluation refers to the average execution times of SQL operations and the PostGIS function under different hardware conditions. With the combination of Kubernetes and Docker, the clustered environment showed improvements in the average execution time of resource-intensive (geo-)queries on all hardware reference setups, outperforming the non-clustered counterparts.<\/jats:p>","DOI":"10.1007\/s10723-025-09806-5","type":"journal-article","created":{"date-parts":[[2025,4,30]],"date-time":"2025-04-30T10:31:09Z","timestamp":1746009069000},"update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":2,"title":["On the Performance of Geospatial Services Deployment: An Experimental Benchmark Analysis"],"prefix":"10.1007","volume":"23","author":[{"given":"Fabio","family":"Franchi","sequence":"first","affiliation":[]},{"given":"Francesco","family":"Smarra","sequence":"additional","affiliation":[]},{"given":"Eleonora","family":"Di Fina","sequence":"additional","affiliation":[]},{"given":"Alessandra","family":"Galassi","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2025,4,30]]},"reference":[{"key":"9806_CR1","doi-asserted-by":"publisher","first-page":"312","DOI":"10.1109\/OJCOMS.2023.3344198","volume":"5","author":"F Franchi","year":"2024","unstructured":"Franchi, F., Graziosi, F., Di Fina, E., Galassi, A.: A survey of cloud-enabled gis solutions toward edge computing: Challenges and perspectives. IEEE Open J. Commun. Soc. 5, 312\u2013331 (2024)","journal-title":"IEEE Open J. Commun. Soc."},{"key":"9806_CR2","doi-asserted-by":"publisher","first-page":"119","DOI":"10.1016\/j.isprsjprs.2015.10.012","volume":"115","author":"S Li","year":"2016","unstructured":"Li, S., Dragicevic, S., Castro, F.A., Sester, M., Winter, S., Coltekin, A., et al.: Geospatial big data handling theory and methods: A review and research challenges. ISPRS J. Photogramm. Remote. Sens. 115, 119\u2013133 (2016)","journal-title":"ISPRS J. Photogramm. Remote. Sens."},{"key":"9806_CR3","doi-asserted-by":"publisher","first-page":"606","DOI":"10.1016\/j.comcom.2019.12.036","volume":"153","author":"L Ma","year":"2020","unstructured":"Ma, L., Wei, D., Wang, P.: Disaster analysis on cultural sites using fuzzy based online open provision geographic data frameworks. Comput. Commun. 153, 606\u2013613 (2020)","journal-title":"Comput. Commun."},{"key":"9806_CR4","doi-asserted-by":"crossref","unstructured":"Zhang, N., Zheng, G., Chen, H., Chen, J., Chen, X.: Hbasespatial: A scalable spatial data storage based on hbase. In: 2014 IEEE 13th international conference on trust, security and privacy in computing and communications. IEEE, pp. 644\u2013651 (2014)","DOI":"10.1109\/TrustCom.2014.83"},{"issue":"4","key":"9806_CR5","doi-asserted-by":"publisher","first-page":"144","DOI":"10.3390\/ijgi7040144","volume":"7","author":"F Hu","year":"2018","unstructured":"Hu, F., Xu, M., Yang, J., Liang, Y., Cui, K., Little, M.M., et al.: Evaluating the open source data containers for handling big geospatial raster data. ISPRS Int. J. Geo Inf. 7(4), 144 (2018)","journal-title":"ISPRS Int. J. Geo Inf."},{"issue":"2","key":"9806_CR6","doi-asserted-by":"publisher","first-page":"289","DOI":"10.1007\/s10619-012-7109-z","volume":"31","author":"S Nishimura","year":"2013","unstructured":"Nishimura, S., Das, S., Agrawal, D., El Abbadi, A.: HBase: design and implementation of an elastic data infrastructure for cloud-scale location services. Distrib. Parallel Databases 31(2), 289\u2013319 (2013)","journal-title":"Distrib. Parallel Databases"},{"issue":"7","key":"9806_CR7","doi-asserted-by":"publisher","first-page":"4337","DOI":"10.1109\/TITS.2020.3042504","volume":"22","author":"K Yu","year":"2020","unstructured":"Yu, K., Lin, L., Alazab, M., Tan, L., Gu, B.: Deep learning-based traffic safety solution for a mixture of autonomous and manual vehicles in a 5G-enabled intelligent transportation system. IEEE Trans. Intell. Transp. Syst. 22(7), 4337\u20134347 (2020)","journal-title":"IEEE Trans. Intell. Transp. Syst."},{"issue":"2","key":"9806_CR8","doi-asserted-by":"publisher","first-page":"95","DOI":"10.3390\/ijgi9020095","volume":"9","author":"M Breunig","year":"2020","unstructured":"Breunig, M., Bradley, P.E., Jahn, M., Kuper, P., Mazroob, N., R\u00f6sch, N., et al.: Geospatial data management research: Progress and future directions. ISPRS Int. J. Geo Inf. 9(2), 95 (2020)","journal-title":"ISPRS Int. J. Geo Inf."},{"key":"9806_CR9","doi-asserted-by":"publisher","first-page":"1185","DOI":"10.1007\/s10586-019-02986-2","volume":"23","author":"P Azad","year":"2020","unstructured":"Azad, P., Navimipour, N.J., Rahmani, A.M., Sharifi, A.: The role of structured and unstructured data managing mechanisms in the Internet of things. Clust. Comput. 23, 1185\u20131198 (2020)","journal-title":"Clust. Comput."},{"issue":"5","key":"9806_CR10","doi-asserted-by":"publisher","first-page":"386","DOI":"10.1016\/j.compenvurbsys.2008.08.004","volume":"32","author":"C Rinner","year":"2008","unstructured":"Rinner, C., Ke\u00dfler, C., Andrulis, S.: The use of Web 2.0 concepts to support deliberation in spatial decision-making. Comput. Environ. Urban Syst. 32(5), 386\u2013395 (2008)","journal-title":"Comput. Environ. Urban Syst."},{"issue":"7","key":"9806_CR11","doi-asserted-by":"publisher","first-page":"2144","DOI":"10.1016\/j.jenvman.2007.06.027","volume":"90","author":"LM Rebelo","year":"2009","unstructured":"Rebelo, L.M., Finlayson, C.M., Nagabhatla, N.: Remote sensing and GIS for wetland inventory, mapping and change analysis. J. Environ. Manage. 90(7), 2144\u20132153 (2009)","journal-title":"J. Environ. Manage."},{"key":"9806_CR12","doi-asserted-by":"crossref","unstructured":"Bartoszewski, D., Piorkowski, A., Lupa, M.: The comparison of processing efficiency of spatial data for PostGIS and MongoDB databases. In: Beyond Databases, Architectures and Structures. Paving the Road to Smart Data Processing and Analysis: 15th International Conference, BDAS 2019, Ustro\u0144, Poland, May 28\u201331, 2019, Proceedings 15. Springer, pp. 291\u2013302 (2019)","DOI":"10.1007\/978-3-030-19093-4_22"},{"issue":"1","key":"9806_CR13","doi-asserted-by":"publisher","first-page":"130","DOI":"10.1109\/MNET.011.2000223","volume":"35","author":"C Feng","year":"2021","unstructured":"Feng, C., Yu, K., Bashir, A.K., Al-Otaibi, Y.D., Lu, Y., Chen, S., et al.: Efficient and secure data sharing for 5G flying drones: A blockchain-enabled approach. IEEE Netw. 35(1), 130\u2013137 (2021)","journal-title":"IEEE Netw."},{"key":"9806_CR14","doi-asserted-by":"crossref","unstructured":"Peng, Y., Wang, Y.: Geographic information system in the cloud computing environment. In: Computer Engineering and Networking: Proceedings of the 2013 International Conference on Computer Engineering and Network (CENet2013). Springer, pp. 893\u2013902 (2014)","DOI":"10.1007\/978-3-319-01766-2_102"},{"issue":"4","key":"9806_CR15","first-page":"17","volume":"1","author":"AG Aly","year":"2013","unstructured":"Aly, A.G., Labib, N.M.: Proposed model of gis-based cloud computing architecture for emergency system. Int. J. Comput. Sci. 1(4), 17\u201328 (2013)","journal-title":"Int. J. Comput. Sci."},{"key":"9806_CR16","doi-asserted-by":"crossref","unstructured":"Yang, J., Wu, S.: Studies on application of cloud computing techniques in GIS. In: 2010 Second IITA International Conference on Geoscience and Remote Sensing. vol.\u00a01. IEEE, pp. 492\u2013495 (2010)","DOI":"10.1109\/IITA-GRS.2010.5602628"},{"key":"9806_CR17","doi-asserted-by":"crossref","unstructured":"Abourezq, M., Idrissi, A.: Database-as-a-service for big data: An overview. Int. J. Adv. Comput. Sci. Appl. 7(1) (2016)","DOI":"10.14569\/IJACSA.2016.070124"},{"key":"9806_CR18","doi-asserted-by":"crossref","unstructured":"Gokhale, S., Poosarla, R., Tikar, S., Gunjawate, S., Hajare, A., Deshpande, S., et al.: Creating helm charts to ease deployment of enterprise application and its related services in kubernetes. In: 2021International Conference on Computing, Communication and Green Engineering (CCGE). IEEE, pp. 1\u20135 (2021)","DOI":"10.1109\/CCGE50943.2021.9776450"},{"key":"9806_CR19","doi-asserted-by":"crossref","unstructured":"Bali, M.K., Mehdi, A., Singh, M.: Implementation of AWS Cloud Infrastructure. In: 2023 14th International Conference on Computing Communication and Networking Technologies (ICCCNT). IEEE, pp. 1\u20138 (2023)","DOI":"10.1109\/ICCCNT56998.2023.10307993"},{"key":"9806_CR20","doi-asserted-by":"crossref","unstructured":"Mell, P., Grance, T.: The NIST definition of cloud computing. Special Publication (NIST SP), National Institute of Standards and Technology, Gaithersburg, MD (2011)","DOI":"10.6028\/NIST.SP.800-145"},{"key":"9806_CR21","doi-asserted-by":"crossref","unstructured":"Shao, Y., Di, L., Bai, Y., Guo, B., Gong, J.: Geoprocessing on the Amazon cloud computing platform-AWS. In: 2012 first international conference on agro-geoinformatics (agro-geoinformatics). IEEE, pp. 1\u20136 (2012)","DOI":"10.1109\/Agro-Geoinformatics.2012.6311655"},{"key":"9806_CR22","unstructured":"Curino, C., Jones, E.P., Popa, R.A., Malviya, N., Wu, E., Madden, S., et\u00a0al.: Relational cloud: A database-as-a-service for the cloud. (2011)"},{"key":"9806_CR23","doi-asserted-by":"crossref","unstructured":"Hu, T., Wang, Y.: A kubernetes autoscaler based on pod replicas prediction. In: 2021 Asia-Pacific Conference on Communications Technology and Computer Science (ACCTCS). IEEE, pp. 238\u2013241 (2021)","DOI":"10.1109\/ACCTCS52002.2021.00053"},{"key":"9806_CR24","doi-asserted-by":"crossref","unstructured":"Khalel, M.M., Pugazhendhi, M.A., Raj, G.R.: Enhanced load balancing in kubernetes cluster by minikube. In: 2022 International Conference on Smart Technologies and Systems for Next Generation Computing (ICSTSN). IEEE, pp. 1\u20135 (2022)","DOI":"10.1109\/ICSTSN53084.2022.9761317"},{"key":"9806_CR25","doi-asserted-by":"crossref","unstructured":"He, Z.: Novel container cloud elastic scaling strategy based on Kubernetes. In: 2020 IEEE 5th information technology and mechatronics engineering conference (ITOEC). IEEE, pp. 1400\u20131404 (2020)","DOI":"10.1109\/ITOEC49072.2020.9141552"},{"key":"9806_CR26","doi-asserted-by":"crossref","unstructured":"Ahmad, M.: AI-enabled spatial intelligence: Revolutionizing data management and decision making in geographic information systems. In: AI and Its Convergence With Communication Technologies. IGI Global, pp. 137\u2013166 (2023)","DOI":"10.4018\/978-1-6684-7702-1.ch005"},{"key":"9806_CR27","doi-asserted-by":"crossref","unstructured":"Mooney, P., Cui, W., Guan, B., Juh\u00e1sz, L.: Towards understanding the geospatial skills of chatgpt: Taking a geographic information systems (gis) exam. In: Proceedings of the 6th ACM SIGSPATIAL International Workshop on AI for Geographic Knowledge Discovery, pp. 85\u201394 (2023)","DOI":"10.1145\/3615886.3627745"},{"key":"9806_CR28","doi-asserted-by":"crossref","unstructured":"Kralidis, A.T.: Geospatial web services: the evolution of geospatial data infrastructure. The Geospatial Web: How Geobrowsers, Social Software and the Web 20 are Shaping the Network Society. pp. 223\u2013228 (2007)","DOI":"10.1007\/978-1-84628-827-2_22"},{"issue":"2","key":"9806_CR29","doi-asserted-by":"publisher","first-page":"256","DOI":"10.1177\/0309132508094076","volume":"33","author":"S Elwood","year":"2009","unstructured":"Elwood, S.: Geographic Information Science: new geovisualization technologies\u2013emerging questions and linkages with GIScience research. Prog. Hum. Geogr. 33(2), 256\u2013263 (2009)","journal-title":"Prog. Hum. Geogr."},{"issue":"7","key":"9806_CR30","doi-asserted-by":"publisher","first-page":"836","DOI":"10.1080\/17538947.2021.1889056","volume":"14","author":"MO Mete","year":"2021","unstructured":"Mete, M.O., Yomralioglu, T.: Implementation of serverless cloud GIS platform for land valuation. Int. J. Digit. Earth 14(7), 836\u2013850 (2021)","journal-title":"Int. J. Digit. Earth"},{"issue":"3","key":"9806_CR31","doi-asserted-by":"publisher","first-page":"218","DOI":"10.1145\/5666.5673","volume":"29","author":"PJ Fleming","year":"1986","unstructured":"Fleming, P.J., Wallace, J.J.: How not to lie with statistics: the correct way to summarize benchmark results. Commun. ACM 29(3), 218\u2013221 (1986)","journal-title":"Commun. ACM"},{"key":"9806_CR32","doi-asserted-by":"crossref","unstructured":"Ray, S., Simion, B., Brown, A.D.: Jackpine: A benchmark to evaluate spatial database performance. In: 2011 IEEE 27th International Conference on Data Engineering. IEEE, pp. 1139\u20131150 (2011)","DOI":"10.1109\/ICDE.2011.5767929"},{"key":"9806_CR33","doi-asserted-by":"crossref","unstructured":"Reddy, G.O.: Spatial data management, analysis, and modeling in GIS: principles and applications. Geospatial Technologies in Land Resources Mapping, Monitoring and Management. pp. 127\u2013142 (2018)","DOI":"10.1007\/978-3-319-78711-4_7"},{"key":"9806_CR34","doi-asserted-by":"crossref","unstructured":"Ramzan, S., Bajwa, I.S., Kazmi, R., Amna.: Challenges in NoSQL-based distributed data storage: a systematic literature review. Electronics 8(5), 488 (2019)","DOI":"10.3390\/electronics8050488"},{"key":"9806_CR35","doi-asserted-by":"crossref","unstructured":"Sahatqija, K., Ajdari, J., Zenuni, X., Raufi, B., Ismaili, F.: Comparison between relational and NOSQL databases. In: 2018 41st International Convention on Information and Communication Technology, Electronics and Microelectronics (MIPRO). IEEE, pp. 0216\u20130221 (2018)","DOI":"10.23919\/MIPRO.2018.8400041"},{"key":"9806_CR36","doi-asserted-by":"crossref","unstructured":"Ioannidis, T., Garbis, G., Kyzirakos, K., Bereta, K., Koubarakis, M.: Evaluating geospatial RDF stores using the benchmark Geographica 2. J. Data Semant. 10(3), 189\u2013228 (2021)","DOI":"10.1007\/s13740-021-00118-x"},{"key":"9806_CR37","doi-asserted-by":"crossref","unstructured":"Franchi, F., Graziosi, F., Di\u00a0Fina, E., Galassi, A.: A Cloud-edge architecture to support post-earthquake reconstruction in central Italy. IEEE Access. (2024)","DOI":"10.1109\/ACCESS.2024.3420695"}],"container-title":["Journal of Grid Computing"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s10723-025-09806-5.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/article\/10.1007\/s10723-025-09806-5\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s10723-025-09806-5.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,23]],"date-time":"2025-06-23T09:51:42Z","timestamp":1750672302000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/s10723-025-09806-5"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,4,30]]},"references-count":37,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2025,6]]}},"alternative-id":["9806"],"URL":"https:\/\/doi.org\/10.1007\/s10723-025-09806-5","relation":{},"ISSN":["1570-7873","1572-9184"],"issn-type":[{"type":"print","value":"1570-7873"},{"type":"electronic","value":"1572-9184"}],"subject":[],"published":{"date-parts":[[2025,4,30]]},"assertion":[{"value":"21 December 2024","order":1,"name":"received","label":"Received","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"20 April 2025","order":2,"name":"accepted","label":"Accepted","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"30 April 2025","order":3,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}},{"order":1,"name":"Ethics","group":{"name":"EthicsHeading","label":"Declarations"}},{"value":"The authors declare no competing interests.","order":2,"name":"Ethics","group":{"name":"EthicsHeading","label":"Competing interests"}},{"value":"Not applicable.","order":3,"name":"Ethics","group":{"name":"EthicsHeading","label":"Ethics approval and consent to participate"}},{"value":"Not applicable.","order":4,"name":"Ethics","group":{"name":"EthicsHeading","label":"Consent for publication"}}],"article-number":"17"}}