Skip to main content
Skip header

Spatial Database Systemy 1

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.

Literature

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.

Advised literature

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 .


Language of instruction čeština, angličtina
Code 548-0128
Abbreviation PDBS1
Course title Spatial Database Systemy 1
Coordinating department Department of Geoinformatics
Course coordinator prof. Ing. Jiří Horák, Dr.