548-0128/01 – Spatial Database Systemy 1 (PDBS1)
| Gurantor department | Department of Geoinformatics | Credits | 6 |
| 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 | 2020/2021 | Year of cancellation | |
| Intended for the faculties | HGF | Intended for study types | Bachelor |
Subject aims expressed by acquired skills and competences
The aim of the subject is to educate students basic concepts of data modelling, data design and application of databases, focused on spatial databases, enable them to independently design spatial databases and utilize them for solving of different tasks.
Teaching methods
Lectures
Tutorials
Summary
The course will deliver basic knowledge about database systems focused on spatial data and spatial database systems. After explanation of basic concepts of automated data processing and principles of database processing, data modelling principles are read focused on ERA and UML diagrams. Variants and approaches of internal data storage are presented. The important part of lessons are dedicated to relational databases and understanding of basic concepts of their applications. A key role is given to SQL. After explanation of object-oriented databases systems, NoSQL databases are introduced with review of their types. Finally, main approaches for storing spatial data into databases are explained, as well as spatial querying, spatial operators and architectures of spatial database systems.
Compulsory literature:
Recommended literature:
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. They also work on individual tasks and must pass writing and oral exam.
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) Reality modelling, data processing. Advantages of DB technology.
2) Information system. Classification of information systems.
3) Database system. DBMS and its role.
4) Conceptual scheme. ERA diagram. UML class diagram.
5) Review of data types. Internal forms of data storage.
6) Relational data model. RDBMS and requirements.
7) Keys, integrity constraints. Functional dependency. Normalisation process.
8) Querying in RDBMS. Relational algebra. SQL. QBE.
9) SQL. QBE.
10) Object-oriented DBMS. NoSQL databases
11) Concepts of storage spatial data in databases.
12) Spatial querying, spatial operators according to OGC.
13) Architecture of spatial DBS. Application of spatial databases
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction