{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,4,29]],"date-time":"2026-04-29T22:13:02Z","timestamp":1777500782481,"version":"3.51.4"},"reference-count":28,"publisher":"Springer Science and Business Media LLC","issue":"2","license":[{"start":{"date-parts":[[2020,6,5]],"date-time":"2020-06-05T00:00:00Z","timestamp":1591315200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0"},{"start":{"date-parts":[[2020,6,5]],"date-time":"2020-06-05T00:00:00Z","timestamp":1591315200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0"}],"funder":[{"name":"H2020 Marie Sk&lstrok;odowska-Curie Actions","award":["777696"],"award-info":[{"award-number":["777696"]}]},{"name":"H2020 Marie Sk&lstrok;odowska-Curie Actions","award":["823916"],"award-info":[{"award-number":["823916"]}]}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["Geoinformatica"],"published-print":{"date-parts":[[2021,4]]},"abstract":"<jats:title>Abstract<\/jats:title><jats:p>Several modern day problems need to deal with large amounts of spatio-temporal data. As such, in order to meet the application requirements, more and more systems are adapting to the specificities of those data. The most prominent case is perhaps the data storage systems, that have developed a large number of functionalities to efficiently support spatio-temporal data operations. This work is motivated by the question of which of those data storage systems is better suited to address the needs of industrial applications. In particular, the work conducted, set to identify the most efficient data store system in terms of response times, comparing two of the most representative of the two categories (NoSQL and relational), i.e. MongoDB and PostgreSQL. The evaluation is based upon real, business scenarios and their subsequent queries as well as their underlying infrastructures and concludes in confirming the superiority of PostgreSQL in almost all cases with the exception of the polygon intersection queries. Furthermore, the average response time is radically reduced with the use of indexes, especially in the case of MongoDB.<\/jats:p>","DOI":"10.1007\/s10707-020-00407-w","type":"journal-article","created":{"date-parts":[[2020,6,5]],"date-time":"2020-06-05T16:03:50Z","timestamp":1591373030000},"page":"243-268","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":57,"title":["MongoDB Vs PostgreSQL: A comparative study on performance aspects"],"prefix":"10.1007","volume":"25","author":[{"given":"Antonios","family":"Makris","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Konstantinos","family":"Tserpes","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Giannis","family":"Spiliopoulos","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Dimitrios","family":"Zissis","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Dimosthenis","family":"Anagnostopoulos","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2020,6,5]]},"reference":[{"key":"407_CR1","unstructured":"Leptoukh G (2005) Nasa remote sensing data in earth sciences: processing, archiving, distribution, applications at the ges disc. In: Proceedings of the 31st intl symposium of remote sensing of environment"},{"key":"407_CR2","unstructured":"Telescope hubble site. http:\/\/hubble.stsci.edu\/the_telescope\/hubble_essentials\/quick_facts.php. Accessed: 2018-7-15"},{"key":"407_CR3","unstructured":"Automatic dependent surveillance-broadcast (ads-b). https:\/\/www.faa.gov\/nextgen\/programs\/adsb\/. Accessed: 2018-7-15"},{"key":"407_CR4","doi-asserted-by":"crossref","unstructured":"Varlamis I, Tserpes K, Sardianos C (2018) Detecting search and rescue missions from ais data. In: 2018 IEEE 34Th international conference on data engineering workshops (ICDEW). IEEE","DOI":"10.1109\/ICDEW.2018.00017"},{"key":"407_CR5","doi-asserted-by":"crossref","unstructured":"Sloan L, Morgan J (2015) Who tweets with their location? understanding the relationship between demographic characteristics and the use of geoservices and geotagging on twitter. Plos one 10(11):e0142209","DOI":"10.1371\/journal.pone.0142209"},{"key":"407_CR6","doi-asserted-by":"crossref","unstructured":"Membrey P, Plugge E, Hawkins T, Hawkins D (2010) The definitive guide to mongoDB: the noSQL database for cloud and desktop computing. Springer, Berlin","DOI":"10.1007\/978-1-4302-3052-6"},{"key":"407_CR7","unstructured":"Matthew N, Stones R (2005) Beginning Databases with postgreSQL. Apress"},{"key":"407_CR8","unstructured":"Werstein P (1998) A performance benchmark for spatiotemporal databases. In: Proceedings of the 10th annual colloquium of the spatial information research centre. Citeseer, pp 365\u2013373"},{"key":"407_CR9","unstructured":"DeWitt DJ (1993) The wisconsin benchmark: past, present and future"},{"key":"407_CR10","doi-asserted-by":"crossref","unstructured":"Stonebraker Mx, Frew J, Gardels K, Meredith J (1993) The sequoia 2000 storage benchmark. In: ACM SIGMOD Record, vol 22. ACM, pp 2\u201311","DOI":"10.1145\/170036.170038"},{"key":"407_CR11","doi-asserted-by":"crossref","unstructured":"Patel J, Yu J, Kabra N, Tufte K, Nag B, Burger J, Hall N, Ramasamy K, Lueder R, Ellmann C et al (1997) Building a scaleable geo-spatial dbms: technology, implementation, and evaluation. In: ACM SIGMOD Record, vol 26. ACM, pp 336\u2013347","DOI":"10.1145\/253262.253342"},{"key":"407_CR12","doi-asserted-by":"crossref","unstructured":"Ray S, Simion B, Jackpine ADB (2011) A benchmark to evaluate spatial database performance. In: 2011 IEEE 27th international conference on Data engineering (ICDE). IEEE, pp 1139\u20131150","DOI":"10.1109\/ICDE.2011.5767929"},{"issue":"11","key":"407_CR13","doi-asserted-by":"publisher","first-page":"1661","DOI":"10.14778\/3236187.3236213","volume":"11","author":"V Pandey","year":"2018","unstructured":"Pandey V, Kipf A, Neumann T, Kemper A (2018) How good are modern spatial analytics systems? Proc VLDB Endowment 11(11):1661\u20131673","journal-title":"Proc VLDB Endowment"},{"key":"407_CR14","doi-asserted-by":"crossref","unstructured":"Hulbert A, Kunicki T, Hughes JN, Fox AD, Eichelberger CN (2016) An experimental study of big spatial data systems. In: 2016 IEEE international conference on Big data (big data). IEEE, pp 2664\u20132671","DOI":"10.1109\/BigData.2016.7840909"},{"key":"407_CR15","doi-asserted-by":"crossref","unstructured":"Yu J, Wu J, Geospark MS (2015) A cluster computing framework for processing large-scale spatial data. In: Proceedings of the 23rd SIGSPATIAL International Conference on Advances in Geographic Information Systems. ACM, pp 70","DOI":"10.1145\/2820783.2820860"},{"key":"407_CR16","doi-asserted-by":"crossref","unstructured":"Gong Y, Morandini L, Sinnott RO (2017) The design and benchmarking of a cloud-based platform for processing and visualization of traffic data. In: 2017 IEEE international conference on Big data and smart computing (bigcomp). IEEE, pp 13\u201320","DOI":"10.1109\/BIGCOMP.2017.7881699"},{"issue":"2","key":"407_CR17","doi-asserted-by":"publisher","first-page":"1626","DOI":"10.14778\/1687553.1687609","volume":"2","author":"A Thusoo","year":"2009","unstructured":"Thusoo A, Sarma JS, Jain N, Shao Z, Chakka P, Anthony S, Liu H, Wyckoff P, Murthy R (2009) Hive: a warehousing solution over a map-reduce framework. Proc VLDB Endowment 2(2):1626\u20131629","journal-title":"Proc VLDB Endowment"},{"issue":"2","key":"407_CR18","doi-asserted-by":"publisher","first-page":"1414","DOI":"10.14778\/1687553.1687568","volume":"2","author":"AF Gates","year":"2009","unstructured":"Gates AF, Natkovich O, Chopra S, Kamath P, Narayanamurthy SM, Olston C, Reed B, Srinivasan S, Srivastava U (2009) Building a high-level dataflow system on top of map-reduce: the pig experience. Proc VLDB Endowment 2 (2):1414\u20131425","journal-title":"Proc VLDB Endowment"},{"issue":"2","key":"407_CR19","doi-asserted-by":"publisher","first-page":"1265","DOI":"10.14778\/1454159.1454166","volume":"1","author":"R Chaiken","year":"2008","unstructured":"Chaiken R, Jenkins B, Larson P, Ramsey B, Shakib D, Weaver S, Zhou J (2008) Scope: easy and efficient parallel processing of massive data sets. Proc VLDB Endowment 1(2):1265\u20131276","journal-title":"Proc VLDB Endowment"},{"issue":"11","key":"407_CR20","doi-asserted-by":"publisher","first-page":"1009","DOI":"10.14778\/2536222.2536227","volume":"6","author":"A Aji","year":"2013","unstructured":"Aji A, Wang F, Vo H, Lee R, Liu Q, Zhang X, Saltz J (2013) Hadoop gis: a high performance spatial data warehousing system over mapreduce. Proc VLDB Endowment 6(11):1009\u20131020","journal-title":"Proc VLDB Endowment"},{"key":"407_CR21","unstructured":"Mongodb. https:\/\/www.mongodb.com\/. Accessed: 2018-7-15"},{"key":"407_CR22","unstructured":"Binary json. http:\/\/bsonspec.org\/. Accessed: 2018-7-15"},{"key":"407_CR23","doi-asserted-by":"publisher","first-page":"94","DOI":"10.1016\/j.procs.2016.08.284","volume":"97","author":"A Makris","year":"2016","unstructured":"Makris A, Tserpes K, Andronikou V, Anagnostopoulos D (2016) A classification of nosql data stores based on key design characteristics. Procedia Comput Science 97:94\u2013103","journal-title":"Procedia Comput Science"},{"key":"407_CR24","unstructured":"The geojson format specification. http:\/\/geojson.org\/geojson-spec.html. Accessed: 2018-7-15"},{"key":"407_CR25","doi-asserted-by":"crossref","unstructured":"Makris A, Tserpes K, Anagnostopoulos D, Nikolaidou M, de Macedo JAF (2019) Database system comparison based on spatiotemporal functionality. In: Proceedings of the 23rd International Database Applications & Engineering Symposium. ACM, pp 21","DOI":"10.1145\/3331076.3331101"},{"key":"407_CR26","unstructured":"Makris A, Tserpes K, Spiliopoulos G, Anagnostopoulos D (2019) Performance evaluation of mongodb and postgresql for spatio-temporal data"},{"key":"407_CR27","doi-asserted-by":"crossref","unstructured":"Makris A, Tserpes K, Anagnostopoulos D (2017) A novel object placement protocol for minimizing the average response time of get operations in distributed key-value stores. In: 2017 IEEE international conference on Big data (big data). IEEE, pp 3196\u20133205","DOI":"10.1109\/BigData.2017.8258300"},{"key":"407_CR28","unstructured":"B LOUIS Decker. World geodetic system 1984. Technical report, Defense Mapping Agency Aerospace Center St Louis Afs Mo 1986"}],"updated-by":[{"DOI":"10.1007\/s10707-020-00424-9","type":"correction","label":"Correction","source":"publisher","updated":{"date-parts":[[2020,9,25]],"date-time":"2020-09-25T00:00:00Z","timestamp":1600992000000}}],"container-title":["GeoInformatica"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s10707-020-00407-w.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/article\/10.1007\/s10707-020-00407-w\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s10707-020-00407-w.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2021,7,30]],"date-time":"2021-07-30T15:28:00Z","timestamp":1627658880000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/s10707-020-00407-w"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2020,6,5]]},"references-count":28,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2021,4]]}},"alternative-id":["407"],"URL":"https:\/\/doi.org\/10.1007\/s10707-020-00407-w","relation":{},"ISSN":["1384-6175","1573-7624"],"issn-type":[{"value":"1384-6175","type":"print"},{"value":"1573-7624","type":"electronic"}],"subject":[],"published":{"date-parts":[[2020,6,5]]},"assertion":[{"value":"7 August 2019","order":1,"name":"received","label":"Received","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"10 March 2020","order":2,"name":"revised","label":"Revised","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"13 April 2020","order":3,"name":"accepted","label":"Accepted","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"5 June 2020","order":4,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"25 September 2020","order":5,"name":"change_date","label":"Change Date","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"Correction","order":6,"name":"change_type","label":"Change Type","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"A Correction to this paper has been published:","order":7,"name":"change_details","label":"Change Details","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"https:\/\/doi.org\/10.1007\/s10707-020-00424-9","URL":"https:\/\/doi.org\/10.1007\/s10707-020-00424-9","order":8,"name":"change_details","label":"Change Details","group":{"name":"ArticleHistory","label":"Article History"}}]}}