548-0921/03 – Spatial Databases (PDB)

Gurantor departmentDepartment of GeoinformaticsCredits10
Subject guarantorprof. Ing. Jiří Horák, Dr.Subject version guarantorprof. Ing. Jiří Horák, Dr.
Study levelpostgraduateRequirementChoice-compulsory
YearSemesterwinter + summer
Study languageEnglish
Year of introduction2017/2018Year of cancellation2022/2023
Intended for the facultiesHGF, FEIIntended for study typesDoctoral
Instruction secured by
LoginNameTuitorTeacher giving lectures
HOR10 prof. Ing. Jiří Horák, Dr.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Examination 20+0
Part-time Examination 20+0

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:

YEUNG A.K.W, HALL G.B: Spatial Database Systems. Desing, Implementation and Project Management. Springer, Dordrecht, 2007. 553 p. ISBN 10-1-4020-5393-2. MANOLOPOULOS Y., PAPADOPOULOS, VASSILAKOPOULOS M. Spatial Databases: Technologies, Techniques, Trends. Idea Group Publishing. 340 stran, Hershey, 2005. ISBN 1-59140-387-1 OBE R., HSU L. PostGIS in Action. Manning Publications, 2011. ISBN 1935182269 SULLIVAN, D., 2015. NoSQL for mere mortals. Addison-Wesley, Hoboken, NJ. 510 s. ISBN 978-0-13-402321-2

Recommended literature:

MARQUEZ A. PostGIS Essentials. Packt Publishing, 2015. ISBN 978-1-78439-529-2 SAMET H. Foundations of Multidimensional and Metric Data Structures, Morgan Kaufmann, 2006. PostGIS 3.0dev Manual. Available at https://postgis.net/docs/ BEINAT, E., GODFRIND, A., KOTHURI, R. Pro Oracle Spatial for Oracle Database 11g. Springer, 2007, 787 p. ISBN 1590598997. RIGAUX P., SCHOLL M., VOISARD A. Spatial Databases with Application to GIS. Kaufmann, San Francisco, 2002. ISBN 1-55860-588-6. 410 pages.

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

Full-time form (validity from: 2017/2018 Winter semester, validity until: 2022/2023 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of pointsMax. počet pokusů
Examination Examination   3
Mandatory attendence participation:

Show history

Conditions for subject completion and attendance at the exercises within ISP:

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2022/2023 (P3657) Geodesy, Cartography and Geoinformatics (3602V002) Geoinformatics P English Ostrava Choice-compulsory study plan
2021/2022 (P3657) Geodesy, Cartography and Geoinformatics (3602V002) Geoinformatics P English Ostrava Choice-compulsory study plan
2020/2021 (P3657) Geodesy, Cartography and Geoinformatics (3602V002) Geoinformatics P English Ostrava Choice-compulsory study plan
2019/2020 (P3657) Geodesy, Cartography and Geoinformatics (3602V002) Geoinformatics P English Ostrava Choice-compulsory study plan
2018/2019 (P3657) Geodesy, Cartography and Geoinformatics (3602V002) Geoinformatics P English Ostrava Choice-compulsory study plan
2017/2018 (P3657) Geodesy, Cartography and Geoinformatics (3602V002) Geoinformatics P English Ostrava Choice-compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction



2018/2019 Winter