MongoDB Vs PostgreSQL: A comparative study on performance aspects

Antonios Makris, Konstantinos Tserpes, Giannis Spiliopoulos, Dimitrios Zissis & Dimosthenis Anagnostopoulos

GeoInformatica (2020), 2020

Abstract

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.

This work was supported by the MASTER Project through the European Union’s Hori-zon 2020 research and innovation program under Marie-Slodowska Curie under Grant 777695. The work reflects only the author’s view and that the EU Agency is not responsible for any use that may be made of the information it contains.

This work has been also developed in the frame of the SmartShip project, which have received funding from the European Union’s Horizon 2020 research and innovation programme under the Marie Slodowska-Curie grant agreement No 823916 respectively.

This work was supported in part by MarineTraffic which provided data access for research purposes.

OUR WORLDWIDE PARTNERS
Previous
Next
December 3, 2023
Big Data
Machine Learning
Navigating through dense waters: a toolbox for creating maritime density maps
Read more
December 3, 2023
Big Data
Data Driven Digital Twins for the Maritime Domain
Read more
December 4, 2023
Satellite Imagery
Vessel Traffic Density Maps Based on Vessel Detection in Satellite Imagery
Read more
December 4, 2023
Big Data
COVID-19 impact on global maritime mobility
Read more
December 4, 2023
Machine Learning
A computer vision approach for trajectory classification
Read more
December 4, 2023
Big Data
A Big Data framework for Modelling and Simulating high-resolution hydrodynamic models in sea harbours
Read more
December 4, 2023
No items found.
Modelling and simulating vessel emissions in real time based on terrestrial AIS data
Read more
December 4, 2023
No items found.
Vessel detection using image processing and Neural Networks
Read more
December 10, 2023
Big Data
MongoDB Vs PostgreSQL: A comparative study on performance aspects
Read more
December 10, 2023
Machine Learning
Big Data
A distributed framework for extracting maritime traffic patterns
Read more
December 10, 2023
Artificial Intelligence
Satellite Imagery
Automatic Maritime Object Detection Using Satellite imagery
Read more
December 10, 2023
Satellite Imagery
Vessel detection using image processing and Neural Networks
Read more
December 10, 2023
Stream Processing
Real-time maritime anomaly detection: detecting intentional AIS switch-off
Read more
December 10, 2023
Machine Learning
Stream Processing
Industry Paper: Classification of vessel activity in streaming data
Read more
December 10, 2023
Data Fusion
Machine Learning
Automatic Fusion of Satellite Imagery and AIS data for Vessel Detection
Read more
December 10, 2023
Big Data
Machine Learning
A distributed spatial method for modeling maritime routes
Read more
December 10, 2023
Big Data
Machine Learning
A data driven approach to maritime anomaly detection
Read more
December 10, 2023
Artificial Intelligence
Monitoring Marine Protected Areas using Data Fusion and AI Techniques
Read more
December 10, 2023
Big Data
Machine Learning
Anomaly Detection white paper
Read more
December 10, 2023
Big Data
Machine Learning
Stream Processing
A distributed lightning fast maritime anomaly detection service
Read more
December 15, 2023
Autonomous Vessels
Data Fusion
Preliminary Inter-comparison of AIS Data and Optimal Ship Tracks
Read more
December 15, 2023
Big Data
Machine Learning
A comparison of supervised learning schemes for the detection of search and rescue (SAR) vessel patterns
Read more
December 15, 2023
Big Data
BigDataOcean Project: Early Anomaly Detection from Big Maritime Vessel Traffic Data
Read more
December 15, 2023
Machine Learning
Vessel Profile Indicators using Fuzzy Logic Reasoning and AIS
Read more
December 15, 2023
Artificial Intelligence
Autonomous Vessels
Real Time Autonomous Maritime Navigation using Dynamic Visibility Graphs
Read more
December 15, 2023
Big Data
Stream Processing
Countering Real-Time Stream Poisoning: An Architecture for Detecting Vessel Spoofing in Streams of AIS Data
Read more
December 15, 2023
Big Data
Machine Learning
Mining Vessel Trajectory Data for Patterns of Search and Rescue
Read more
January 10, 2024
No items found.
SELECT – Artificial Intelligence in Inland Navigation
Read more
January 10, 2024
No items found.
CADMUSS – an innovative project to improve maritime safety
Read more
January 10, 2024
No items found.
Determining the bilge water waste risk and management in the Gulf of Antalya by the Monte Carlo method
Read more
January 10, 2024
No items found.
FleetMon Supports the Development of Environmental Impact Assessment on the Brazilian Coast
Read more
January 10, 2024
Emissions
Scrapping Probabilities and Committed CO2 Emissions of the International Ship Fleet
Read more
January 10, 2024
Emissions
The CO2 reduction potential of shore-side electricity in Europe
Read more
January 10, 2024
Emissions
Estimation of worldwide ship emissions using AIS signals
Read more
January 10, 2024
Machine Learning
Routing Network
Scalable In-Database Machine Learning for the Prediction of Port-to-Port Routes
Read more
January 10, 2024
Emissions
Green shipping: using AIS data to assess global emissions
Read more
January 10, 2024
Routing Network
How a real-time-based sea traffic forecast helps to organize and optimize the flow of maritime goods
Read more
January 10, 2024
Routing Network
Generating a node in an AIS-based routing graph for improved Estimated Time of Arrival. (Big) Data challenge: using AIS for generating a routing graph
Read more
January 10, 2024
No items found.
Composition, spatial distribution and sources of macro-marine litter on the Gulf of Alicante seafloor (Spanish Mediterranean)
Read more
January 10, 2024
No items found.
Climate change, non-indigenous species and shipping: assessing the risk of species introduction to a high-Arctic archipelago
Read more
January 15, 2024
No items found.
The Big Picture: An Improved Method for Mapping Shipping Activities
Read more

Require AIS data for your project?

Please reach out to us to discuss which Kpler offering will support your research project or academic study in the best possible and efficient way.