https://homel.vsb.cz/~hor10/Vyuka/Spatial%20Databases/PDBS2024.pdf
https://homel.vsb.cz/~hor10/Vyuka/Spatial%20Databases/SDBS2023.pdf
https://homel.vsb.cz/~hor10/Vyuka/Spatial%20Databases/SDS72020text.pdf
Spatial Database Systems 2
| Type of study | Follow-up Master |
|---|---|
| Language of instruction | Czech |
| Code | 548-0140/01 |
| Abbreviation | PDBS2 |
| Course title | Spatial Database Systems 2 |
| Credits | 5 |
| Coordinating department | Department of Geoinformatics |
| Course coordinator | prof. Ing. Jiří Horák, Dr. |
Subject syllabus
1. Object-relational DBMS. Client-server architecture. Introducion to Oracle. Logical a physical database structure
2. User, role, profile. Locking, data protection, transaction.
3. Data types and integrity constraints in Oracle. SQL DDL, DML
4. PL/SQL, procedure, trigger, XML, Oracle text
5. Principles of spatial data storage and geometry in databases
6. Spatial represenation of objects (mainly SQL/MM:1999, OGC Simple Feature Specification)
7. Integrity of spatial data and spatial integrity constraints, multiple representation
8. Conceptual modelling of spatial objects (MADS, Perceptory)
9. Spatial indeces – quadtree, , K-d tree, range tree, BSP and variants
10. Prostorové indexace – multidimensional grid, PM trees, R trees and variants.
11. Spatial extension of SQL. SQL for vizualization of spatial data.
12. Oracle Spatial, MS SQL Server.
13. PostGIS
2. User, role, profile. Locking, data protection, transaction.
3. Data types and integrity constraints in Oracle. SQL DDL, DML
4. PL/SQL, procedure, trigger, XML, Oracle text
5. Principles of spatial data storage and geometry in databases
6. Spatial represenation of objects (mainly SQL/MM:1999, OGC Simple Feature Specification)
7. Integrity of spatial data and spatial integrity constraints, multiple representation
8. Conceptual modelling of spatial objects (MADS, Perceptory)
9. Spatial indeces – quadtree, , K-d tree, range tree, BSP and variants
10. Prostorové indexace – multidimensional grid, PM trees, R trees and variants.
11. Spatial extension of SQL. SQL for vizualization of spatial data.
12. Oracle Spatial, MS SQL Server.
13. PostGIS
E-learning
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
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
Advised literature
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.
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.