Universität Wien

290187 PS Geodatabases (2024S)

3.50 ECTS (2.00 SWS), SPL 29 - Geographie
Continuous assessment of course work
Moodle

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).

Details

max. 25 participants
Language: English

Lecturers

Classes (iCal) - next class is marked with N

  • Thursday 07.03. 13:30 - 17:00 Multimedia Mapping-Labor, NIG 1.Stock C0110
  • Thursday 14.03. 13:30 - 17:00 Multimedia Mapping-Labor, NIG 1.Stock C0110
  • Thursday 11.04. 13:30 - 17:00 Multimedia Mapping-Labor, NIG 1.Stock C0110
  • Thursday 18.04. 13:30 - 17:00 Multimedia Mapping-Labor, NIG 1.Stock C0110
  • Thursday 25.04. 13:30 - 17:00 Multimedia Mapping-Labor, NIG 1.Stock C0110

Information

Aims, contents and method of the course

This course aims at providing an in-depth understanding and practical expertise in the realm of spatial databases. Focusing on the design, management, and application of geodatabases, the course will give students comprehensive knowledge and understanding of spatial database structures and functionalities.
The course will begin with an introduction into data modeling with UML (Unified Modeling Language), and Entity-Relation (ER) models. It will then cover the basics of relational algebra, and operations used for accessing and selecting the data from relational tables. A significant emphasis will be placed on database normalization and the use of Database Management Systems (DBMS) in managing spatial data. The course provides an in-depth look into the various aspects of spatial databases, including understanding different spatial data types and their unique properties. Students will learn about the complexities of spatial data operations, gaining insights into topological, spatial, and distance calculations and their practical applications in real-world scenarios. One of the topics of this course will be the spatial and non-spatial joins, along with data indexing which are used to optimize and speed up such operations. The course will also explore the diverse application areas of spatial databases, and some advanced and more recent topics in this area.
In addition to theoretical knowledge, the course will also focus on practical skills. Students will engage in hands-on activities such as connecting to and managing existing spatial databases and designing and setting up new databases. They will also learn to write SQL code to address complex spatial and non-spatial problems, a skill that is highly sought after in many professional fields.
Teaching methods include a blend of lectures and practical workshops. Each session will start with theoretical instruction provided through lectures, and the second part will be reserved for practical exercises and hands-on work with spatial databases and SQL.

Assessment and permitted materials

There will be three assessment items in this course:
- a short midterm exam,
- a group project for which you will need to submit a report and give a presentation, and
- a final exam

Minimum requirements and assessment criteria

The grade is composed of in-class participation (10%), a midterm exam (20%), a final exam (40%), and a group project including a short presentation (30%). A positive completion requires an overall score of 51%.
< 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

Paul Bolstad (2019): GIS Fundamentals.
Duckham M., Sun Q., Worboys, M. F. (2024): GIS - A computing perspective.
Obe R. & Hsu L. (2021): PostGIS in Action. - Shelter Island, NY, USA.
Zurbaran M. (2018): PostGIS Cookbook. - Packt Publishing.
Elmasri R. & Navathe S. (2016): Fundamentals of Database Systems. – Pearson.
Coronel C. & Morris S. (2018). Database systems: Design, implementation, and management. - Boston, MA, USA.
Bailis P., Hellerstein J.M., Stonebraker M. (2015): Readings in Database Systems (free ebook)

Association in the course directory

(MK1-W1-PI)

Last modified: Tu 19.03.2024 08:26