290187 PS Geodatenbanken (2024S)
Prüfungsimmanente Lehrveranstaltung
Labels
An/Abmeldung
Hinweis: Ihr Anmeldezeitpunkt innerhalb der Frist hat keine Auswirkungen auf die Platzvergabe (kein "first come, first served").
- Anmeldung von Mi 07.02.2024 08:00 bis Di 20.02.2024 08:00
- Anmeldung von Mi 21.02.2024 12:00 bis Mi 28.02.2024 08:00
- Abmeldung bis So 31.03.2024 23:59
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
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
- 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)
< 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)
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
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.