548-0921/03 – Spatial Databases (PDB)
Gurantor department | Department of Geoinformatics | Credits | 10 |
Subject guarantor | prof. Ing. Jiří Horák, Dr. | Subject version guarantor | prof. Ing. Jiří Horák, Dr. |
Study level | postgraduate | Requirement | Choice-compulsory |
Year | | Semester | winter + summer |
| | Study language | English |
Year of introduction | 2017/2018 | Year of cancellation | 2022/2023 |
Intended for the faculties | HGF, FEI | Intended for study types | Doctoral |
Subject aims expressed by acquired skills and competences
The objective is to develop student’s knowledge in the field of object-relational and NoSQL databases dedicated to spatial data and spatial tasks, and increase his/her capability to utilize spatial databases in case studies with topics related to the theme of his/her PhD thesis.
Teaching methods
Individual consultations
Project work
Summary
The course is focused to storage, indexation, maintenance and querying of spatial data in object-relational databases such as Oracle or PostgreSQL+PostGIS and in NoSQL databases (namely graph, document, multidimensional) such as Gephi, Hadoop, MongoDB, storage of vector, raster, TIN and lidar data, extension of SQL for spatial operations, advanced methods of indexation of spatial data, spatial trajectories, data mining of spatial data.
Compulsory literature:
Recommended literature:
Way of continuous check of knowledge in the course of semester
E-learning
Classic teaching methods (lesson, practice) are completed with tests and indepedent work. The emphasize is given to the ability to defend proposed solution and critically evaluate different alternatives.
Other requirements
No additional requirements.
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
Subject syllabus:
Data administration in RDBMS and ORDBMS. Client-server processes. Extension of SQL. Geometrical data types. SQL/MM:1999. OGC Simple Feature Specification. Storing and indexing of spatial data stored in databases. Spatial queries. Spatial trajectories. Data mining and pattern. Transaction, distributed processing.
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction