Universität Wien

290187 PS Geodatenbanken (2024S)

3.50 ECTS (2.00 SWS), SPL 29 - Geographie
Prüfungsimmanente Lehrveranstaltung
Moodle

An/Abmeldung

Hinweis: Ihr Anmeldezeitpunkt innerhalb der Frist hat keine Auswirkungen auf die Platzvergabe (kein "first come, first served").

Details

max. 25 Teilnehmer*innen
Sprache: Englisch

Lehrende

Termine (iCal) - nächster Termin ist mit N markiert

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

Information

Ziele, Inhalte und Methode der Lehrveranstaltung

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.

Art der Leistungskontrolle und erlaubte Hilfsmittel

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

Mindestanforderungen und Beurteilungsmaßstab

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)

Prüfungsstoff

Provided via e-learning platform as well as documents from the course Geodatabases.

Literatur

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)

Zuordnung im Vorlesungsverzeichnis

(MK1-W1-PI)

Letzte Änderung: Di 19.03.2024 08:26