290187 PS Geodatabases (2022S)
Continuous assessment of course work
Labels
Registration/Deregistration
Note: The time of your registration within the registration period has no effect on the allocation of places (no first come, first served).
- Registration is open from We 09.02.2022 08:00 to Th 24.02.2022 10:00
- Deregistration possible until Th 31.03.2022 23:59
Details
max. 25 participants
Language: German
Lecturers
Classes
Wednesday, 2.3.2022 - 16:00-19:00
Wednesday, 9.3.2022 - 16:00-19:00
Wednesday, 23.3.2022 - 16:00-19:00
Wednesday, 6.4.2022 - 16:00-19:00
Wednesday, 4.5.2022 - 16:00-19:00
Wednesday, 18.5.2022 - 16:00-19:00 (Alternative Date)
Wednesday, 1.6.2022 - 16:00-20:00 (Presentations)
Wednesday, 15.6.2022 - 16:00-18:00 (Exam)
Information
Aims, contents and method of the course
Assessment and permitted materials
There is an intermediate test on the basics of SQL and relational databases. The final exam deals exclusively with problems in the area of geodatabases. Both exams consist of SC, MC and true/false questions and take place via Moodle. During the exams, the database server will be available so SQL queries can be tested. Other aids are not permitted.
The group project consists of 2 presentations (topic introduction in 2-3 minutes and a final presentation in 15 minutes) and a summary paper. A group size of 3 people is aimed for. The paper and the final presentation must be submitted by June 30, 2022.
The group project consists of 2 presentations (topic introduction in 2-3 minutes and a final presentation in 15 minutes) and a summary paper. A group size of 3 people is aimed for. The paper and the final presentation must be submitted by June 30, 2022.
Minimum requirements and assessment criteria
The grade is composed of participation (5%), an intermediate test (20%), a final exam (40%), and a group project including a short presentation (35%). A positive completion requires an overall grade of at least 51%.
A maximum of 2 units may be missed.
< 50%: Nicht genügend (5)
>50 - 60%: Genügend (4)
>60 - 72,5%: Befriedigend (3)
>72,5 - 85%: Gut (2)
> 85 - 100%: Sehr gut (1)
A maximum of 2 units may be missed.
< 50%: Nicht genügend (5)
>50 - 60%: Genügend (4)
>60 - 72,5%: Befriedigend (3)
>72,5 - 85%: Gut (2)
> 85 - 100%: Sehr gut (1)
Examination topics
Provided via e-learning platform as well as documents from the course Geodatabases.
Reading list
Obe R. & Hsu L. (2021): PostGIS in Action. - Shelter Island, NY, USA.
Zurbaran M. (2018): PostGIS Cookbook. - Packt Publishing.
Connolly T. & Begg C. (2015): Database Systems: A Practical Approach to Design, Implementation, and Management, Global Edition. - London.
Elmasri R. & Navathe S. (2016): Fundamentals of Database Systems. – Pearson.
Coronel C. & Morris S. (2018). Database systems: Design, implementation, and management. - Boston, MA, USA.
Winand M. (2012): SQL Performance Explained: Everything Developers Need to Know about SQL Performance. - Wien
Zurbaran M. (2018): PostGIS Cookbook. - Packt Publishing.
Connolly T. & Begg C. (2015): Database Systems: A Practical Approach to Design, Implementation, and Management, Global Edition. - London.
Elmasri R. & Navathe S. (2016): Fundamentals of Database Systems. – Pearson.
Coronel C. & Morris S. (2018). Database systems: Design, implementation, and management. - Boston, MA, USA.
Winand M. (2012): SQL Performance Explained: Everything Developers Need to Know about SQL Performance. - Wien
Association in the course directory
(MK1-W1-PI)
Last modified: Th 21.07.2022 10:09
- Introduction
o Review of the basics of relational databases and SQL
Working environment and relational model
Tables, views, relations, data types, indexes and normalization
Functions, procedures and queries
o Spatial databases
Introduction to GIS ecosystem, consisting of GIS clients and databases
Database 'tooling
Notes on the set-up of PostGIS
Connection of PostGIS and GIS client
Presentation of the demo databases that will accompany the course throughout the semester
- Working in PostGIS
o Spatial data types and indices
Geometry, Geography, Raster and Topology
Types and uses of spatial indices: GIST, BRIN and SP-GIST
o Spatial Functions: Core
Creation of spatial database objects in the database
Transfer to another reference system
Measurement functions
Decomposition and simplification functions
o Spatial functions: Topological
Creation and use of enveloping boxes (bounding boxes)
Difference spatial and geometric equality
Relations (intersection, overlap, within, etc.)
Spatial links
Special functions: Difference and division
- Connection to GIS client (ArcPro and QGIS)
o Setting up the connections
o Control of the effects in the client, with change in the data base
o Explaining the advantages and disadvantages between GIS client and working in the databaseMethods
At the beginning of each unit, the students learn the basics of the respective topic in interactive lessons. Afterwards, the practical application of the newly learned knowledge with special software begins.Targets
Students are familiar with the basics of geodatabases and know the current methods and procedures for data storage and management of spatial data. They are able to design geodatabases and to use the data they contain as information with different software applications.