{"id":"https://openalex.org/W3033093379","doi":"https://doi.org/10.1007/s10707-020-00407-w","title":"MongoDB Vs PostgreSQL: A comparative study on performance aspects","display_name":"MongoDB Vs PostgreSQL: A comparative study on performance aspects","publication_year":2020,"publication_date":"2020-06-05","ids":{"openalex":"https://openalex.org/W3033093379","doi":"https://doi.org/10.1007/s10707-020-00407-w","mag":"3033093379"},"language":"en","primary_location":{"id":"doi:10.1007/s10707-020-00407-w","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s10707-020-00407-w","pdf_url":"https://link.springer.com/content/pdf/10.1007/s10707-020-00407-w.pdf","source":{"id":"https://openalex.org/S4210168194","display_name":"GeoInformatica","issn_l":"1384-6175","issn":["1384-6175","1573-7624"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"GeoInformatica","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://link.springer.com/content/pdf/10.1007/s10707-020-00407-w.pdf","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5076592473","display_name":"Antonios Makris","orcid":"https://orcid.org/0000-0003-0514-4292"},"institutions":[{"id":"https://openalex.org/I32762134","display_name":"Harokopio University of Athens","ror":"https://ror.org/02k5gp281","country_code":"GR","type":"education","lineage":["https://openalex.org/I32762134"]}],"countries":["GR"],"is_corresponding":true,"raw_author_name":"Antonios Makris","raw_affiliation_strings":["Department of Informatics, Telematics, Harokopio University of Athens, Athens, Greece"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Informatics, Telematics, Harokopio University of Athens, Athens, Greece","institution_ids":["https://openalex.org/I32762134"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5021420035","display_name":"Konstantinos Tserpes","orcid":"https://orcid.org/0000-0001-5183-1443"},"institutions":[{"id":"https://openalex.org/I32762134","display_name":"Harokopio University of Athens","ror":"https://ror.org/02k5gp281","country_code":"GR","type":"education","lineage":["https://openalex.org/I32762134"]}],"countries":["GR"],"is_corresponding":false,"raw_author_name":"Konstantinos Tserpes","raw_affiliation_strings":["Department of Informatics, Telematics, Harokopio University of Athens, Athens, Greece"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Informatics, Telematics, Harokopio University of Athens, Athens, Greece","institution_ids":["https://openalex.org/I32762134"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5054072214","display_name":"Giannis Spiliopoulos","orcid":"https://orcid.org/0000-0002-5003-7923"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Giannis Spiliopoulos","raw_affiliation_strings":["MarineTraffic, London, UK"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"MarineTraffic, London, UK","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5076536574","display_name":"Dimitris Zissis","orcid":"https://orcid.org/0000-0003-2870-2656"},"institutions":[{"id":"https://openalex.org/I98805295","display_name":"University of the Aegean","ror":"https://ror.org/03zsp3p94","country_code":"GR","type":"education","lineage":["https://openalex.org/I98805295"]}],"countries":["GR"],"is_corresponding":false,"raw_author_name":"Dimitrios Zissis","raw_affiliation_strings":["Department of Product and Systems Design Engineering, University of the Aegean, Syros, Greece","MarineTraffic, London, UK"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Product and Systems Design Engineering, University of the Aegean, Syros, Greece","institution_ids":["https://openalex.org/I98805295"]},{"raw_affiliation_string":"MarineTraffic, London, UK","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5023717678","display_name":"Dimosthenis Anagnostopoulos","orcid":"https://orcid.org/0000-0003-0747-4252"},"institutions":[{"id":"https://openalex.org/I32762134","display_name":"Harokopio University of Athens","ror":"https://ror.org/02k5gp281","country_code":"GR","type":"education","lineage":["https://openalex.org/I32762134"]}],"countries":["GR"],"is_corresponding":false,"raw_author_name":"Dimosthenis Anagnostopoulos","raw_affiliation_strings":["Department of Informatics, Telematics, Harokopio University of Athens, Athens, Greece"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Informatics, Telematics, Harokopio University of Athens, Athens, Greece","institution_ids":["https://openalex.org/I32762134"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5076592473"],"corresponding_institution_ids":["https://openalex.org/I32762134"],"apc_list":{"value":2590,"currency":"EUR","value_usd":3190},"apc_paid":{"value":2590,"currency":"EUR","value_usd":3190},"fwci":3.6467,"has_fulltext":true,"cited_by_count":71,"citation_normalized_percentile":{"value":0.9382837,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":95,"max":100},"biblio":{"volume":"25","issue":"2","first_page":"243","last_page":"268"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9957000017166138,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.995199978351593,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/nosql","display_name":"NoSQL","score":0.8952511548995972},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7284390330314636},{"id":"https://openalex.org/keywords/polygon","display_name":"Polygon (computer graphics)","score":0.5643660426139832},{"id":"https://openalex.org/keywords/intersection","display_name":"Intersection (aeronautics)","score":0.5564534664154053},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.5320259928703308},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5288825035095215},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.48157548904418945},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4735495150089264},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4464885890483856},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.3849390149116516},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.34355223178863525},{"id":"https://openalex.org/keywords/geography","display_name":"Geography","score":0.1558845341205597},{"id":"https://openalex.org/keywords/cartography","display_name":"Cartography","score":0.10107335448265076},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.0795479416847229}],"concepts":[{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.8952511548995972},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7284390330314636},{"id":"https://openalex.org/C190694206","wikidata":"https://www.wikidata.org/wiki/Q3276654","display_name":"Polygon (computer graphics)","level":3,"score":0.5643660426139832},{"id":"https://openalex.org/C64543145","wikidata":"https://www.wikidata.org/wiki/Q162942","display_name":"Intersection (aeronautics)","level":2,"score":0.5564534664154053},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.5320259928703308},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5288825035095215},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.48157548904418945},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4735495150089264},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4464885890483856},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.3849390149116516},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.34355223178863525},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.1558845341205597},{"id":"https://openalex.org/C58640448","wikidata":"https://www.wikidata.org/wiki/Q42515","display_name":"Cartography","level":1,"score":0.10107335448265076},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0795479416847229},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0},{"id":"https://openalex.org/C126042441","wikidata":"https://www.wikidata.org/wiki/Q1324888","display_name":"Frame (networking)","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/s10707-020-00407-w","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s10707-020-00407-w","pdf_url":"https://link.springer.com/content/pdf/10.1007/s10707-020-00407-w.pdf","source":{"id":"https://openalex.org/S4210168194","display_name":"GeoInformatica","issn_l":"1384-6175","issn":["1384-6175","1573-7624"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"GeoInformatica","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1007/s10707-020-00407-w","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s10707-020-00407-w","pdf_url":"https://link.springer.com/content/pdf/10.1007/s10707-020-00407-w.pdf","source":{"id":"https://openalex.org/S4210168194","display_name":"GeoInformatica","issn_l":"1384-6175","issn":["1384-6175","1573-7624"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"GeoInformatica","raw_type":"journal-article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","score":0.6499999761581421,"display_name":"Industry, innovation and infrastructure"}],"awards":[{"id":"https://openalex.org/G1494532855","display_name":null,"funder_award_id":"823916","funder_id":"https://openalex.org/F4320320300","funder_display_name":"European Commission"},{"id":"https://openalex.org/G483297964","display_name":null,"funder_award_id":"777695","funder_id":"https://openalex.org/F4320320300","funder_display_name":"European Commission"}],"funders":[{"id":"https://openalex.org/F4320320300","display_name":"European Commission","ror":"https://ror.org/00k4n6c32"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3033093379.pdf","grobid_xml":"https://content.openalex.org/works/W3033093379.grobid-xml"},"referenced_works_count":25,"referenced_works":["https://openalex.org/W16670200","https://openalex.org/W75281627","https://openalex.org/W643082433","https://openalex.org/W1569570229","https://openalex.org/W2093766169","https://openalex.org/W2110086534","https://openalex.org/W2115583184","https://openalex.org/W2115687261","https://openalex.org/W2119400430","https://openalex.org/W2142031898","https://openalex.org/W2155356570","https://openalex.org/W2164631912","https://openalex.org/W2295338537","https://openalex.org/W2494684283","https://openalex.org/W2538875704","https://openalex.org/W2584587216","https://openalex.org/W2601615769","https://openalex.org/W2783194322","https://openalex.org/W2879698168","https://openalex.org/W2889201433","https://openalex.org/W2904451801","https://openalex.org/W2934392475","https://openalex.org/W2962736902","https://openalex.org/W3009754812","https://openalex.org/W3010188954"],"related_works":["https://openalex.org/W2295775753","https://openalex.org/W4381416854","https://openalex.org/W2603313942","https://openalex.org/W4306877231","https://openalex.org/W2143602713","https://openalex.org/W4386408829","https://openalex.org/W4241927984","https://openalex.org/W4236503624","https://openalex.org/W2765185163","https://openalex.org/W3124817491"],"abstract_inverted_index":{"Abstract":[0],"Several":[1],"modern":[2],"day":[3],"problems":[4],"need":[5],"to":[6,18,29,53,76,89],"deal":[7],"with":[8,149,165],"large":[9,49],"amounts":[10],"of":[11,32,51,66,68,80,99,104,108,143,152,168,174],"spatio-temporal":[12,56],"data.":[13,34],"As":[14],"such,":[15],"in":[16,97,139,145,171],"order":[17],"meet":[19],"the":[20,30,41,64,78,85,91,105,109,141,150,153,158,166,172],"application":[21],"requirements,":[22],"more":[23,25],"and":[24,113,117,127,137],"systems":[26,72],"are":[27],"adapting":[28],"specificities":[31],"those":[33,69],"The":[35,119],"most":[36,92,106],"prominent":[37],"case":[38,173],"is":[39,61,73,121,162],"perhaps":[40],"data":[42,57,70,94],"storage":[43,71],"systems,":[44],"that":[45],"have":[46],"developed":[47],"a":[48],"number":[50],"functionalities":[52],"efficiently":[54],"support":[55],"operations.":[58],"This":[59],"work":[60,86],"motivated":[62],"by":[63],"question":[65],"which":[67],"better":[74],"suited":[75],"address":[77],"needs":[79],"industrial":[81],"applications.":[82],"In":[83],"particular,":[84],"conducted,":[87],"set":[88],"identify":[90],"efficient":[93],"store":[95],"system":[96],"terms":[98],"response":[100,160],"times,":[101],"comparing":[102],"two":[103,110],"representative":[107],"categories":[111],"(NoSQL":[112],"relational),":[114],"i.e.":[115],"MongoDB":[116],"PostgreSQL.":[118],"evaluation":[120],"based":[122],"upon":[123],"real,":[124],"business":[125],"scenarios":[126],"their":[128,134],"subsequent":[129],"queries":[130],"as":[131,133],"well":[132],"underlying":[135],"infrastructures":[136],"concludes":[138],"confirming":[140],"superiority":[142],"PostgreSQL":[144],"almost":[146],"all":[147],"cases":[148],"exception":[151],"polygon":[154],"intersection":[155],"queries.":[156],"Furthermore,":[157],"average":[159],"time":[161],"radically":[163],"reduced":[164],"use":[167],"indexes,":[169],"especially":[170],"MongoDB.":[175]},"counts_by_year":[{"year":2026,"cited_by_count":7},{"year":2025,"cited_by_count":18},{"year":2024,"cited_by_count":22},{"year":2023,"cited_by_count":8},{"year":2022,"cited_by_count":13},{"year":2021,"cited_by_count":3}],"updated_date":"2026-05-23T08:51:43.019350","created_date":"2025-10-10T00:00:00"}