MongoDB Vs PostgreSQL: A comparative study on performance aspects

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

doi:10.1007/s10707-020-00407-w

Cited by 36 publications

(21 citation statements)

References 18 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…Resource for Geospatial Information and Standards (Makris et al, 2021). PostGIS adds a spatial aspect to the PostgreSQL server, and the server becomes eligible to be used as a backend spatial database for geographic information systems (GIS).…”

Section: The Database (Design and Creation)mentioning

confidence: 99%

See 1 more Smart Citation

Design and Implementation of a Web-GIS for the management of road infrastructure in Zimbabwe

Mazhindu¹,

Madamombe²

2022

SA J of Geomatics

View full text Add to dashboard Cite

Road asset mapping has the potential of reducing: costs in keeping all assets data, time-consuming activities like retrieving asset attribute from large files, risks associated with losing all the data by using Geographic Information Systems (GIS). Traditional road data has been stored in the form of hard copy maps showing the different road infrastructure. The World Wide Web (WWW), has revolutionized the provision, dissemination, and data access to people in different geographical locations. Web-GIS based applications have gained popularity because their low cost, ease of use and availability to a large population – that is anyone with a web-browser. Through browsers, web-GIS based applications can display a map with useful information. The design and development of an interactive web-GIS based digital road infrastructure management tool not only allows users to visualize the road infrastructure content but also help in decision making. It makes use of open source GIS tools, PostgreSQL and PostGIS (to manage spatial and non-spatial data), Geoserver (to connect the database to the client mapping application) and Apache Tomcat (to build and deploy the application). The maps are published through Geoserver with their associated information using JavaScript libraries (Open Layers and Geoext). Further spatial analysis (attribute queries) can be done online. Results show that a web-GIS was developed that manages road asset infrastructure like road signs, bridges, animal grids, rest areas. A user can query precise assets they want to visualize for instance damaged bridges. HoweGIS:here is still need to further improve the application for instance allowing user to put complaints about damaged road assets. Thus, the development of the application will help decision makers as well as other users to utilize the information for the benefit of the country.

show abstract

Section: The Database (Design and Creation)mentioning

confidence: 99%

“…PostGIS adds a spatial aspect to the PostgreSQL server, and the server becomes eligible to be used as a backend spatial database for geographic information systems (GIS). It adds special geometry data types and spatial function to the PostgreSQL object-relational database (Makris et al, 2021).…”

Section: The Database (Design and Creation)mentioning

confidence: 99%

Design and Implementation of a Web-GIS for the management of road infrastructure in Zimbabwe

Mazhindu¹,

Madamombe²

2022

SA J of Geomatics

View full text Add to dashboard Cite

show abstract

“…A dataset 4 with sparse points which contains the trajectory information of three animal species from Starkey project. In this dataset, major habitat variables derived for radiotelemetry studies of elk, mule deer and cattle at the Starkey Experimental Forest and Range, 28 miles southwest of La Grande, Oregon.…”

Section: Animals Datasetmentioning

confidence: 99%

“…For instance, one AIS 1 -receiving station receives 6 AIS messages, or 1800 bytes, per second. Considering that a ship tracking company may operate thousands of such receivers, we end up with terabytes of data to deal with each month [4]. For example, MarineTraffic's on-line monitoring service collects 60Mb of AIS and weather data every second [5].…”

Section: Introductionmentioning

confidence: 99%

Evaluating the effect of compressing algorithms for trajectory similarity and classification problems

et al. 2021

Self Cite

View full text Add to dashboard Cite

During the last few years the volumes of the data that synthesize trajectories have expanded to unparalleled quantities. This growth is challenging traditional trajectory analysis approaches and solutions are sought in other domains. In this work, we focus on data compression techniques with the intention to minimize the size of trajectory data, while, at the same time, minimizing the impact on the trajectory analysis methods. To this extent, we evaluate five lossy compression algorithms: Douglas-Peucker (DP), Time Ratio (TR), Speed Based (SP), Time Ratio Speed Based (TR_SP) and Speed Based Time Ratio (SP_TR). The comparison is performed using four distinct real world datasets against six different dynamically assigned thresholds. The effectiveness of the compression is evaluated using classification techniques and similarity measures. The results showed that there is a trade-off between the compression rate and the achieved quality. The is no “best algorithm” for every case and the choice of the proper compression algorithm is an application-dependent process.

show abstract

“…In [4], the comparison is made in terms of the response time in a 5 node cluster, which showed that PostgreSQL outperformed MongoDB in all cases. The speedup of PostgreSQL over MongoDB was on average above 2.6, clearly showing the superiority of PostgreSQL when it comes to query handling.…”

Section: Literature Reviewmentioning

confidence: 99%

Analysis of Data Oriented Web Application Systems

Dinkar¹,

Biswagar²

2021

JUSST

View full text Add to dashboard Cite

The purpose of this paper is to study and analyse the various tools that are used in modern day web application systems, which include but are not limited to Flask, Django, PostgreSQL, MongoDB, Docker containers, virtual machines, and so on. The main aim is to allow users of these technologies to be able to choose the right technology based on their needs and the scale of their applications. This is done with the help of sysbench and Docker and Linux based containers, along with basic Flask and Django web applications. Flask could be preferred for simpler web applications over Django. Docker and LXD do perform similarly for the most part, but due to its low storage footprint (only essential libraries are installed in the container, not an entire OS), and its ease of configurability in almost all operating systems, Docker is generally preferred over the others. PostgreSQL seemed to perform 2 times better than MongoDB in terms of the number of queries it handled.

show abstract

MongoDB Vs PostgreSQL: A comparative study on performance aspects

Cited by 36 publications

References 18 publications

Design and Implementation of a Web-GIS for the management of road infrastructure in Zimbabwe

Design and Implementation of a Web-GIS for the management of road infrastructure in Zimbabwe

Evaluating the effect of compressing algorithms for trajectory similarity and classification problems

Analysis of Data Oriented Web Application Systems

Contact Info

Product

Resources

About