Spatial Databases

Type of study	Doctoral
Language of instruction	Czech
Code	548-0921/04
Abbreviation	PDB
Course title	Spatial Databases
Credits	10
Coordinating department	Department of Geoinformatics
Course coordinator	prof. Ing. Jiří Horák, Dr.

Subject syllabus

Concepts of storage methods for spatial objects and geometries in databases
Standards of spatial object representation (OGC Simple Feature Specification and others)
Integrity of spatial data and integrity constraints
Spatial indexation
Spatial querying and spatial extension of SQL
Storage of raster data, TIN and lidar data in databases
Object-relational databases. Oracle Spatial, MS SQL Server, PostGIS.
NoSQL databases. Graph, cloud, multidimensional, XML databases, spatio-temporal databases, stream databases. Gephi, Hadoop, MongoDB.
Storage and spatial indexation of multidimensional trajectories.
Data mining of spatial data.

E-learning

https://homel.vsb.cz/~hor10/Vyuka/Spatial%20Databases/

Literature

YEUNG A.K.W, HALL G.B: Spatial Database Systems. Desing, Implementation and Project Management. Springer, Dordrecht, 2007. 553 p. ISBN 10-1-4020-5393-2.
MANOLOPOULOS Y., PAPADOPOULOS, VASSILAKOPOULOS M. Spatial Databases: Technologies, Techniques, Trends. Idea Group Publishing. 340 stran, Hershey, 2005. ISBN 1-59140-387-1
OBE R., HSU L. PostGIS in Action. Manning Publications, 2011.
SULLIVAN, D., 2015. NoSQL for mere mortals. Addison-Wesley, Hoboken, NJ. 510 s.

Advised literature

MARQUEZ A. PostGIS Essentials. Packt Publishing, 2015.
SAMET H. Foundations of Multidimensional and Metric Data Structures, Morgan Kaufmann, 2006.
PostGIS 3.0dev Manual. Available at https://postgis.net/docs/
BEINAT, E., GODFRIND, A., KOTHURI, R. Pro Oracle Spatial for Oracle Database 11g. Springer, 2007, 787 p. .
RIGAUX P., SCHOLL M., VOISARD A. Spatial Databases with Application to GIS. Kaufmann, San Francisco, 2002. ISBN 1-55860-588-6. 410 pages.

back to search page