Skip to main content
Skip header

Spatial Database Systemy 1

* Exchange students do not have to consider this information when selecting suitable courses for an exchange stay.

Course Unit Code548-0128/01
Number of ECTS Credits Allocated6 ECTS credits
Type of Course Unit *Compulsory
Level of Course Unit *First Cycle
Year of Study *First Year
Semester when the Course Unit is deliveredSummer Semester
Mode of DeliveryFace-to-face
Language of InstructionCzech
Prerequisites and Co-Requisites Course succeeds to compulsory courses of previous semester
Name of Lecturer(s)Personal IDName
HOR10prof. Ing. Jiří Horák, Dr.
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.
Learning Outcomes of the Course Unit
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.
Course Contents
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
Recommended or Required Reading
Required Reading:
Revesz, P. Introduction to Databases: From Biological to Spatio-Temporal. 2010. Springer; ISBN 1447125339.
Churcher, Clare. Beginning Database Design. Berkeley, CA: Apress, 2007. ISBN 9781590597699.
Teorey T., Lightstone S., Nadeau T: Database modelling and design: Logical design. Elsevier. ISBN 978-0-12-685352-0
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.
Pokorný, J.,Valenta M.: Databázové systémy. ČVUT, 2020. ISBN 978-80-01-06696-6
Šarmanová J.: Teorie zpracování dat. Skripta VŠB-TUO. 159 stran. 2007.
Šarmanová J.: Databázové a informační systémy. VŠB-TUO. 122 stran. 2007. ISBN 978-80-248-1499-5
Manolopoulos Y., Papadopoulos, Vassilakopoulos M.: Spatial Databases: Technologies, Techniques, Trends. Idea Group Publishing. 340 stran, Hershey, 2005. ISBN 1-59140-387-1.
Recommended Reading:
Manolopoulos Y., Papadopoulos, Vassilakopoulos M.: Spatial Databases: Technologies, Techniques, Trends. Idea Group Publishing. 340 stran, Hershey, 2005. ISBN 1-59140-387-1.
Adam Nabil R., Gangopadhyay Aryya: Database Issues in Geographic Information Systems. Kluwer, 2.vydání, 1998.
Rigaux P., Scholl M., Voisard A.: Spatial Databases with Application to GIS. Kaufmann, San Francisco, 2002. ISBN 1-55860-588-6. 410 pages.
Rajaraman A., Ullman J., 2011. Mining of Massive Datasets. Cambridge University Press. ISBN 9781107015357.
Foster E.C, Godbole S.V. Database Systems. Apress, 2014. ISBN: 9781484208779
Dobešová Z: Prostorové databázové systémy. UP Olomouc, 2004.
Pokorný J.: Konstrukce databázových systémů. ČVUT Praha 1998.
Dohnal, Pour: Architektury informačních systémů. Ecopress 1997.
Planned learning activities and teaching methods
Lectures, Tutorials
Assesment methods and criteria
Task TitleTask TypeMaximum Number of Points
(Act. for Subtasks)
Minimum Number of Points for Task Passing
Credit and ExaminationCredit and Examination100 (100)51
        CreditCredit33 (33)17
                písemné testyWritten test12 0
                samostatný projektProject15 0
                Docházka a doplňkové úkolyOther task type6 0
        ExaminationExamination67 (67)18
                písemná zkouškaWritten examination50 18
                ústní zkouškaOral examination17 0