|
Lecturer(s)
|
-
Janečka Karel, Doc. Ing. Ph.D.
-
Jedlička Karel, Ing. Ph.D.
|
|
Course content
|
1. Introduction to spatial databases. Definition of the main terms. 2. Spatial data representation formats. 3. Query language for spatial data. 4. Modelling of spatial data with constraints. 5. Algorithms of spatial databases. 6. Data structures for spatial data indexing. 7. Spatial queries and spatial join. 8. Commercial and open source solutions for spatial data handling.
|
|
Learning activities and teaching methods
|
- Contact hours
- 39 hours per semester
- Individual project (40)
- 40 hours per semester
- Preparation for an examination (30-60)
- 30 hours per semester
- Presentation preparation (report) (1-10)
- 1 hour per semester
|
| prerequisite |
|---|
| Knowledge |
|---|
| to describe the possibilities of representations of geographical data in the digital form |
| to describe the basic database objects of relational databases |
| to describe the differences between a conceptual, a logical and a physical data model |
| Skills |
|---|
| to write a simple SQL DML query |
| to propose a conceptual, a logical and a physical data model of the relational database |
| Competences |
|---|
| N/A |
| learning outcomes |
|---|
| Knowledge |
|---|
| to describe the basic differences between a relational- and a spatial- database |
| to characterise the basic properties of a data model for spatial data according to the ISO 19125 |
| to explain the principles of selected data structures for spatial data indexing |
| to propose a usage of an appropriate algorithm for selected task from the field of spatial databases |
| to explain the principles of a spatial join |
| Skills |
|---|
| to propose a conceptual and a logical data model for storage of spatial data |
| to describe the proposed data model by the means of UML |
| to propose the suitable spatial data types for a physical data model |
| to implement the physical data model in selected database managament system with a spatial option (Oracle Spatial, PostGIS, ESRI Geodatabase) |
| Competences |
|---|
| N/A |
| teaching methods |
|---|
| Knowledge |
|---|
| Lecture supplemented with a discussion |
| Task-based study method |
| Skills demonstration |
| Collaborative instruction |
| Individual study |
| Students' portfolio |
| One-to-One tutorial |
| Discussion |
| Skills |
|---|
| Lecture |
| Lecture with visual aids |
| Practicum |
| Task-based study method |
| Textual studies |
| Skills demonstration |
| Students' portfolio |
| Collaborative instruction |
| One-to-One tutorial |
| Discussion |
| Individual study |
| Competences |
|---|
| Textual studies |
| Task-based study method |
| Individual study |
| Students' portfolio |
| Discussion |
| assessment methods |
|---|
| Knowledge |
|---|
| Seminar work |
| Individual presentation at a seminar |
| Written exam |
| Practical exam |
| Oral exam |
| Skills |
|---|
| Seminar work |
| Individual presentation at a seminar |
| Oral exam |
| Written exam |
| Practical exam |
| Competences |
|---|
| Seminar work |
| Individual presentation at a seminar |
| Written exam |
| Practical exam |
| Oral exam |
|
Recommended literature
|
-
Beinat, Euro; Godfrind, Albert; Kothuri V, Ravikanth. Pro Oracle Spatial. Apress, 2004. ISBN 1-59059-383-9.
-
Rigaux, Philippe; Scholl, Michel; Voisard, Agn?s. Spatial databases : with applications to GIS. San Francisco : Morgan Kaufmann Publishers, 2002. ISBN 1-55860-588-6.
-
Shekhar, Shashi; Chawla, Sanjay. Spatial databases : a tour. Upper Saddle River : Prentice Hall, 2003. ISBN 0-13-017480-7.
-
Tuček, Ján. Geografické informační systémy : pricipy a praxe. 1. vyd. Praha : Computer Press, 1998. ISBN 80-7226-091-X.
|