Aristotle University Of Thessaloniki (AUTH)
Οργάνωση και διαχείριση χωροχρονικών χαρτογραφικών δεδομένων σε περιβάλλον Συστημάτων Γεωγραφικών Πληροφοριών
Abstract
dc:descriptionThis 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- Χωροχρονικά δεδομένα
- Γεωγραφικά Συστήματα Πληροφοριών (GIS)
- Αρχαιολογία
- Αποθήκες δεδομένων
- Spatiotemporal data
- Geographic information systems (GIS)
- Archaeology
- Data warehouses
- Άλλες Επιστήμες Μηχανικού και Τεχνολογίες
- Επιστήμες Μηχανικού και Τεχνολογία
- Μηχανική και Τεχνολογίες, άλλοι τομείς
- Other Engineering and Technologies
- Engineering and Technology
- Engineering and Technologies, miscellaneous
Rights
- Language dc:language
- gre
Identifiers
dc:identifier.*- Identifier
- 10.12681/eadd/58508