548-0140/01 – Spatial Database Systems 2 (PDBS2)
Gurantor department | Department of Geoinformatics | Credits | 5 |
Subject guarantor | prof. Ing. Jiří Horák, Dr. | Subject version guarantor | prof. Ing. Jiří Horák, Dr. |
Study level | undergraduate or graduate | Requirement | Compulsory |
Year | 1 | Semester | summer |
| | Study language | Czech |
Year of introduction | 2021/2022 | Year of cancellation | |
Intended for the faculties | HGF | Intended for study types | Follow-up Master |
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:
Recommended literature:
Additional study materials
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
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction