548-0140/01 – Spatial Database Systems 2 (PDBS2)

Gurantor departmentDepartment of GeoinformaticsCredits5
Subject guarantorprof. Ing. Jiří Horák, Dr.Subject version guarantorprof. Ing. Jiří Horák, Dr.
Study levelundergraduate or graduateRequirementCompulsory
Year1Semestersummer
Study languageCzech
Year of introduction2021/2022Year of cancellation
Intended for the facultiesHGFIntended for study typesFollow-up Master
Instruction secured by
LoginNameTuitorTeacher giving lectures
CAH0021 doc. RNDr. Jan Caha, Ph.D.
HOR10 prof. Ing. Jiří Horák, Dr.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 2+2
Part-time Credit and Examination 8+8

Subject aims expressed by acquired skills and competences

The aim of the subject is to educate students how to create databases for spatial data and utilise DBMS, namely spatial extension of SQL for solving of different spatial tasks. Spatial operation are provided in the environment of large object-related database systems.

Teaching methods

Lectures
Tutorials

Summary

The course explains an architecture, concepts and SQL in OR DBMS such as Oracle or PostgreSQL+PostGIS, methods of spatial data storage in the database environment, conceptual models, spatial indeces, usage of spatial functions in SQL and implementation in the selected database environments.

Compulsory literature:

ZURBARÁN M., WIGHTMAN P., CORTI P., MATHER S.V., KRAFT T.J., PARK B.: PostGIS Cookbook - Second Edition: Store, organize, manipulate, and analyze spatial data. Packt, 2018. ISBN-13: 978-1788299329 YEUNG A.K.W, HALL G.B: Spatial Database Systems. Desing, Implementation and Project Management. Springer, Dordrecht, 2007. ISBN 10-1-4020-5393-2. 553 pages. MANOLOPOULOS Y., PAPADOPOULOS, VASSILAKOPOULOS M. Spatial Databases: Technologies, Techniques, Trends. Idea Group Publishing. 340 stran, Hershey, 2005. ISBN 1-59140-387-1. URBANO F., CAGNACCI F. Spatial Database for GPS Wildlife Tracking Data. Springer, 2014. ISBN 9783319037424, p. 200

Recommended literature:

AITCHINSON A. Beginning Spatial with SQL Server 2008. Apress 2009, ISBN 978-1-4309-1828-1, 458 s. BEINAT, E., GODFRIND, A., KOTHURI, R. Pro Oracle Spatial for Oracle Database 11g. Springer, 2007, 787 stran, 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. ADAM N. R., GANGOPADHYAY A.: Database Issues in Geographic Information Systems. Kluwer, 2001.

Way of continuous check of knowledge in the course of semester

Students are asked about knowledge from areas that they should have already known from previous lectures. Students also work on individual tasks. Tasks are frequently based on understanding of previous, simpler tasks.

E-learning

Other requirements

No additional requirements are imposed on the student.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1. Object-relational DBMS. Client-server architecture. Introducion to Oracle. Logical a physical database structure 2. User, role, profile. Locking, data protection, transaction. 3. Data types and integrity constraints in Oracle. SQL DDL, DML 4. PL/SQL, procedure, trigger, XML, Oracle text 5. Principles of spatial data storage and geometry in databases 6. Spatial represenation of objects (mainly SQL/MM:1999, OGC Simple Feature Specification) 7. Integrity of spatial data and spatial integrity constraints, multiple representation 8. Conceptual modelling of spatial objects (MADS, Perceptory) 9. Spatial indeces – quadtree, , K-d tree, range tree, BSP and variants 10. Prostorové indexace – multidimensional grid, PM trees, R trees and variants. 11. Spatial extension of SQL. SQL for vizualization of spatial data. 12. Oracle Spatial, MS SQL Server. 13. PostGIS

Conditions for subject completion

Full-time form (validity from: 2021/2022 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)		Min. number of pointsMax. počet pokusů
Credit and Examination Credit and Examination 100 (100) 51
        Credit Credit 33  17
        Examination Examination 67 (67) 18 3
                písemná zkouška Written examination 50  18
                ústní zkouška Oral examination 17  0
Mandatory attendence participation: Continuous check of processing tasks during exercises. Written and oral examination.

Show history

Conditions for subject completion and attendance at the exercises within ISP: Materials for an individual study are available at http://homel.vsb.cz/~hor10/Vyuka/ where you can find also topics for the exam. Consultations (both personal and online) with the lecturer are possible. The exercises are individual based on a semester project which has to be completed to the end of the exam period for the given semester. The exam is conducted only in person.

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2024/2025 (N0532A330039) Geoinformatics GIT K Czech Ostrava 1 Compulsory study plan
2024/2025 (N0532A330039) Geoinformatics GIT P Czech Ostrava 1 Compulsory study plan
2023/2024 (N0532A330039) Geoinformatics GIT K Czech Ostrava 1 Compulsory study plan
2023/2024 (N0532A330039) Geoinformatics GIT P Czech Ostrava 1 Compulsory study plan
2022/2023 (N0532A330039) Geoinformatics GIT P Czech Ostrava 1 Compulsory study plan
2022/2023 (N0532A330039) Geoinformatics GIT K Czech Ostrava 1 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction



2022/2023 Summer