Universität Wien

290187 PS Geodatabases (2023S)

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: German

Lecturers

Classes (iCal) - next class is marked with N

The course on April 26th, 2023 is planned as an alternative date if one of the previous dates should not take place.

  • Wednesday 08.03. 16:00 - 19:00 Multimedia Mapping-Labor, NIG 1.Stock C0110
  • Wednesday 15.03. 16:00 - 19:00 Multimedia Mapping-Labor, NIG 1.Stock C0110
  • Wednesday 29.03. 16:00 - 19:00 Multimedia Mapping-Labor, NIG 1.Stock C0110
  • Wednesday 19.04. 16:00 - 19:00 Multimedia Mapping-Labor, NIG 1.Stock C0110
  • Wednesday 26.04. 16:00 - 19:00 Multimedia Mapping-Labor, NIG 1.Stock C0110
  • Wednesday 10.05. 16:00 - 19:00 Multimedia Mapping-Labor, NIG 1.Stock C0110
  • Wednesday 31.05. 16:00 - 19:00 Multimedia Mapping-Labor, NIG 1.Stock C0110
  • Wednesday 14.06. 16:00 - 19:00 Multimedia Mapping-Labor, NIG 1.Stock C0110

Information

Aims, contents and method of the course

The content of the course is divided into the following topics:
-) Introduction to relational database systems
Starting with a review and refresher on relational databases and why they endure today. Explanation of the working environment and the relational model. Definition of technical terms such as tables, views, relations, data types, indices and normalization. This processing is always done with the practical help of SQL within a PostgreSQL environment. Above all, SQL queries form the essential basis in this block of topics, but also in all the following ones. Optionally, functions and procedures in a database environment still need to be clarified.
-) Spatial databases
Presentation of the GIS ecosystem in which, in addition to GIS clients, databases also have a fixed place. The following are instructions for setting up a DBMS in general, as well as with regard to spatial expansion. The hands-on exercises on spatial queries all take place in PostGIS. A demo database will accompany us throughout the semester, which should help to understand working with PostGIS and is also available for connection to a GIS client. In this context, the advantages and disadvantages of running spatial queries in a GIS client versus a DB client and vice versa are discussed.
-) Spatial data types and indices
The usable data types in a spatial database system are geometry, geography, raster, and topology. It is necessary to work out their distinction and different applications. With regard to spatial indexes, GIST, BRIN and SP-GIST are available in PostGIS.
-) Spatial Functions: Core and Topological
Starting with the creation of spatial database objects in the database, through to the transfer to another reference system, measurement functions, and functions that can be used for decomposition and simplification.
Explanation of the use and the concept of envelopes (bounding boxes), distinction between spatial and geometric equality, relations (intersection, overlap, inside, etc.), spatial links and special functions such as difference and division.

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

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.

Minimum requirements and assessment criteria

The grade is composed of participation (5%), an intermediate test (15%), a final exam (40%), and a group project including a short presentation (40%). 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)

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

Association in the course directory

(MK1-W1-PI)

Last modified: Mo 27.02.2023 19:09