| Course Unit Code | 548-0140/01 |
|---|
| Number of ECTS Credits Allocated | 5 ECTS credits |
|---|
| Type of Course Unit * | Compulsory |
|---|
| Level of Course Unit * | Second Cycle |
|---|
| Year of Study * | First Year |
|---|
| Semester when the Course Unit is delivered | Summer Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | Czech |
|---|
| Prerequisites and Co-Requisites | Course succeeds to compulsory courses of previous semester |
|---|
| Name of Lecturer(s) | Personal ID | Name |
|---|
| HOR10 | prof. Ing. Jiří Horák, Dr. |
| 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. |
| Learning Outcomes of the Course Unit |
|---|
| The aim of the subject is to educate students how to create databases for spatial data and utilise DBMS, namely spatial extension of SQL for solving of different spatial tasks. Spatial operation are provided in the environment of large object-related database systems. |
| Course Contents |
|---|
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 |
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
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 |
HORÁK J: Prostorové databázové systémy. VŠB-TU Ostrava, 2020. 164 stran.
HORÁK J. Prostorové databázové systémy. Úvod do Oracle. 2020. Sada přednášek.
PELIKÁN J. Datové struktury pro prostorové vyhledávání. Praha, 2011. Dostupné na http://cgg.mff.cuni.cz/~pepca/
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. |
| Recommended Reading: |
|---|
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. |
LACKO L. Oracle. Správa, programování a použití databázového systému. ComputerPress, 2007. ISBN 978-80-251-1490-2
DOBEŠOVÁ Z. Prostorové databázové systémy. UP Olomouc, 2004.
MARQUEZ A. PostGIS Essentials. Packt Publishing, 2015. ISBN 978-1-78439-529-2
MANOLOPOULOS Y., PAPADOPOULOS, VASSILAKOPOULOS M. Spatial Databases: Technologies, Techniques, Trends. Idea Group Publishing. 340 stran, Hershey, 2005. ISBN 1-59140-387-1. |
| Planned learning activities and teaching methods |
|---|
| Lectures, Tutorials |
| Assesment methods and criteria |
|---|
| Task Title | Task Type | Maximum Number of Points
(Act. for Subtasks) | Minimum Number of Points for Task Passing |
|---|
| Credit and Examination | Credit and Examination | 100 (100) | 51 |
| Credit | Credit | 33 | 17 |
| Examination | Examination | 67 (67) | 18 |
| písemná zkouška | Written examination | 50 | 18 |
| ústní zkouška | Oral examination | 17 | 0 |