Back to search

Aristotle University Of Thessaloniki (AUTH)

Οργάνωση και διαχείριση χωροχρονικών χαρτογραφικών δεδομένων σε περιβάλλον Συστημάτων Γεωγραφικών Πληροφοριών

Abstract

dc:description

This PhD thesis is part of the broader field of research on the investigation of the use of IT technologies for the implementation of complex spatio-temporal data management systems in the field of Archaeology. The aim of the PhD thesis is to propose and implement a spatio-temporal data management system in a Geographic Information Systems environment, using data warehouses infrastructure. As a pilot application, a geospatial infrastructure was designed and implemented for the monitoring and recording of the research archaeological results of the European research project PLANTCULT and further analysis of these data with data mining tools. PLANTCULT is a research project that aims to explore the prehistoric cuisines of Europe, in particular their plant components and their transformation into meals. The aim of the project is to identify culinary cultures and their changes through time in a large part of Europe, from the Aegean to Central Europe. Research at various archaeological sites and literature, combined with the chronological periods to which all observations and finds are attributed, create the initial data sources used in the thesis. Databases of plant food remains, associated processing equipment (ceramics, grinding tools, cooking utensils, etc.) are several data sources whose structure was designed and implemented. Different researchers from different countries use different terminology for chronological periods, therefore all chronological information was organized with an absolute chronological range (from-to) and a large index of chronological period terminology to accommodate all groups of researchers. The implementation of the thesis includes the organization and standardization of the researchers' needs, the design and implementation of a spatio-temporal data management system and the creation of spatio-temporal correlation models for the collected information. The analysis and development of the proposed solution in the form of a data warehouse is based on High Performance Database Management Systems, which allows client/server architecture to integrate different types of data in a single infrastructure. The collected dataset includes the spatiotemporal dimensions and the integration into a data warehouse structure logic allows its extraction into structures that allow the analysis of spatio-temporal data. The data used, from the four dimensions that location and time provides, are transformed into multidimensional data formats, considering the additional descriptive features collected for each of the individual data sources. Tools to extract, transform and load (ETL) were designed and developed to convert the individual structures into a unified data warehouse. The methodology applied for the conversion-adaptation of the data from a structured data format to a data warehouse and from there to Online Analytical Processing (OLAP) support structures and the use of Data cubes is based on table structure replication techniques and query predicate restrictions, which allows for continuous data loading into the data warehouse with minimal impact on the execution time of the final queries. The final data format by homogenizing and organizing the data into structures supporting OLAP functions aims at correlation detection results in a multiparametric environment.

Degree

thesis:*
Grantor dc:publisher
Aristotle University Of Thessaloniki (AUTH)
Year dc:date
2024

Author and committee

dc:creator, dc:contributor.*
Authors dc:creator
  • Roustanis, Themistoklis
  • Ρουστάνης, Θεμιστοκλής

Subjects

dc:subject × 14

Rights

Language dc:language
gre

Identifiers

dc:identifier.*
Identifier
10.12681/eadd/58508

Chain of custody

source
Harvested from
Greek National Archive of PhD Theses
Base URL
phdtheses.ekt.gr/eadd_oai/request
Last updated
2026-11-18
Source record
OAI-PMH GetRecord
citation

Roustanis, Themistoklis; Ρουστάνης, Θεμιστοκλής. Οργάνωση και διαχείριση χωροχρονικών χαρτογραφικών δεδομένων σε περιβάλλον Συστημάτων Γεωγραφικών Πληροφοριών. Aristotle University Of Thessaloniki (AUTH), 2024. http://hdl.handle.net/10442/hedi/58508