Razvoj usluge interaktivne karte za prikaz podataka o kretanju vozila prometnom mrežom

master's thesis

• Title (english): Development of an Interactive Map for Displaying Vehicle Movement Data in the Transport Network
• Author: Hrvoje Goldner
• Mentor: Tomislav Erdelić (mentor)
• Committee member: Tonči Carić (predsjednik povjerenstva)
• Committee member: Marko Matulin (član povjerenstva)
• Committee member: Ivan Cvitić (član povjerenstva)
• Granter: University of Zagreb; Faculty of Transport and Traffic Sciences; (Division of Intelligent Transport Systems and Logistics); (Department of Intelligent Transport Systems); Zagreb
• Defense date and country: 2023-07-04, Croatia
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Traffic and Transport Technology; Postal and Telecommunications Traffic

Abstract

U ovom radu predstavljen je razvoj sučelja za obradu, filtriranje i prikaz velike količine podataka o kretanju vozila kroz prometnu mrežu. Cilj rada je prezentacija informacija o dostupnim rješenjima u polju prostornovremenskih baza podataka te korištenje istih u svrhu učinkovite pohrane, dohvaćanja i vizualizacije prostornovremenskih podataka, te razvoja aplikacija koje koriste iste. Prikazane su osnove sustava baza podataka, relacijskog modela, relacijskih baza podataka i SQL jezika, kreiranja pokazivača i različitih dostupnih stabala za pohranu istih. Zatim su opisane mogućnosti implementacije prostorno-vremenskih podataka kroz dostupne inačice baza podataka i sustava za upravljanje istim, te usporedbe performansi njihovog rada prilikom dohvata podataka. Implementirano je sučelje za dohvat prostorno-vremenskih podataka iz Mireo Space-Time baze podataka, te prikaz na karti, čime su prikazana moguća rješenja i dostupne mogućnosti za obradu, prikaz, prijenos i pohranu prostornovremenskih podataka.

Abstract (english)

This paper describes the creation of an interface that will process, filter, and display a sizable amount of traffic network vehicle movement data. The objective is to provide information about the solutions that are available for effective store, data retrieval, and visualization of spatio-temporal data, as well as details on how to use those data to develop applications. The fundamentals of relational model and databases, the development of indices and the various tree types that can be used to store them, as well as the modern technologies that are currently available, are discussed. The implementation of spatio-temporal data through numerous database and control system versions is then covered, along with performance comparisons. Viable solutions and accessible capabilities for processing, visualization, transmission, and storage of spatio-temporal data have been highlighted through the implementation of an interface for retrieving data from the Mireo Space-Time database and displaying it on a map.

• Keywords: relacijske baze podataka; SQL; prostorno-vremenske baze podataka; stabla pokazivača; prikaz podataka o kretanju vozila; Mireo Space-Time; SECONDO; interaktivna karta; Leaflet; GeoJSON
• Keywords (english): relation databases; SQL; spatio-temporal databases; indexing trees; displaying vehicle movement data; Mireo Space-Time; SECONDO; interactive map; Leaflet; GeoJSON
• Language: croatian
• URN:NBN: urn:nbn:hr:119:504179
• Study programme: Title: Traffic and Transport; specializations in: Road Traffic and Transport, Railway Traffic and Transport, Water Traffic and Transport, Air Traffic and Transport, Postal Traffic, Information and Communication Traffic, Urban Traffic and Transport; Course: Road Traffic and Transport; Study programme type: university; Study level: graduate; Academic / professional title: magistar/magistra inženjer/inženjerka prometa (magistar/magistra inženjer/inženjerka prometa)
• Type of resource: Text
• File origin: Born digital
• Access conditions: Open access
• Created on: 2023-07-14 10:32:21