Jämförande analys av frågor för enskilda och flera geometrityper för hämtning av geospatiala data i MySQL och MongoDB : Bedömning av frågeprestanda för platsbaserad information i MySQL och MongoDB / Comparative analysis of single and multiple geometric type queries for geospatial data retrieval in MySQL and MongoDB : Assessing fetch query performance for location-based information in MySQL and MongoDB

Description

The use of databases for managing spatial data is widespread due to the efficiency of traditional SQL databases like Azure SQL. However, the exponential growth of data from sources like social media has led to the popularity of NoSQL databases such as MongoDB that handle large volumes of data effectively. NoSQL databases, including MongoDB, have built-in support for geospatial queries, making them suitable for managing geospatial data. Geospatial data combines geometric and geographic information and is represented by spatial datatypes like Point, LineString, and Polygon. MySQL and MongoDB both support geospatial data, but limited studies are comparing their performance in geospatial queries. An experiment was conducted to compare the fetch speed of geospatial data in these databases. The results were analyzed using graphs and related studies to draw conclusions, which showed that MongoDB performed slower fetch requests than MySQL. Future studies can use more data points and different queries.

Links & Downloads

1. http://urn.kb.se/resolve?urn=urn:nbn:se:his:diva-22966

Tags

MongoDB

MySQL

geospatial data

single-geometry types

multiple-geometry types

Information Systems, Social aspects

Additional Fields

Identifer	oai:union.ndltd.org:UPSALLA1/oai:DiVA.org:his-22966
Date	January 2023
Creators	Larsson, William
Publisher	Högskolan i Skövde, Institutionen för informationsteknologi
Source Sets	DiVA Archive at Upsalla University
Language	Swedish
Detected Language	English
Type	Student thesis, info:eu-repo/semantics/bachelorThesis, text
Format	application/pdf
Rights	info:eu-repo/semantics/openAccess