Skip to main content
Skip header

Spatial Database Systems 2

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.

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

Doporučená literatura

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.


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