Primerjava prostorske podatkovne baze Tile38 z relacijskimi sistemi

Palmer, Pascal (author), Kukar, Matjaž (mentor)

V diplomski nalogi predstavljamo specializirano podatkovno bazo za prostorske podatke Tile38, ki jo primerjamo z relacijskima podatkovnima bazama PostgreSQL in MySQL s katerima tudi lahko upravljamo prostorske podatke. Predstavimo v kakšnih formatih in na kakšen način lahko vnašamo prostorske podatke v izbrane podatkovne baze. Pri vsaki bazi smo opisali nekaj ključnih metod in ukazov za upravljanje prostorskih podatkov. Razvili smo spletno aplikacijo za delo s prostorskimi podatki OpenStreetMap in Trola.si API-jem, kjer pokažemo, kako se Tile38 obnese v primerjavi s PostgreSQL.

• Language: Slovenian
• Keywords: prostorski podatki, Tile38, PostGIS, OpenStreetMap, geografska ograja, GeoJSON
• Work type: Bachelor thesis/paper
• Organization: FRI - Faculty of Computer and Information Science
• Year: 2018
• PID: 20.500.12556/RUL-103462
• Publication date in RUL: 18.09.2018

Secondary language

• Language: English
• Title: Comparison of spatial database Tile38 with relational systems

Abstract

In this thesis, we present a specialized database Tile38 for spatial data. For comparison, we chose two relational databases, PostgreSQL and MySQL, that can also be used to manage spatial data. We will show how we can insert spatial data into these databases and in what format. For each database, we have described some of the key methods and commands for managing spatial data. We developed web application to work with OpenStreetMap spatial data and Trola.si API, where we show how Tile38 does compared to PostgreSQL.

• Keywords: spatial data, Tile38, PostGIS, OpenStreetMap, geofence, GeoJSON