Professional paper

https://doi.org/10.19279/TVZ.PD.2020-8-4-01

IMPLEMENTATION OF SPATIAL DATABASES

Marin Leontenko ; Zagreb University of Applied Sciences, Zagreb, Croatia, student
Ognjen Mitrović ; Zagreb University of Applied Sciences, Zagreb, Croatia
Jelena Kapelac Gulić ; Zagreb University of Applied Sciences, Zagreb, Croatia

Abstract

Existing relational database management systems need to be extended with spatial functions for storing, editing, viewing and analysis of spatial data. In this paper we showcase technologies for implementing spatial databases with focus on PostGIS extension for PostgreSQL relational database management system. The paper lists pros of using this technology and explains techniques and algorithms for indexing spatial data along with data types supported by mentioned systems. At the end of this paper we described our own solution of spatial database implementation for multiuser access, which we demonstrated by building simple but efficient application for using spatial data.

Keywords

database; spatial data; indexing; PostGIS; R-Tree; QGIS

Hrčak ID:

256088

URI

https://hrcak.srce.hr/256088

Publication date:

20.1.2021.

Article data in other languages: croatian

Visits: 1.180 *