Students acquire competencies related to

• Subject matter expertise: Students are able to apply techniques for storing, management, and retrieval of (spatiotemporal) data. They can describe and discuss the issues of large data sets and complex queries, and give an overview of the state of the art and current challenges in the field of databases.
• Method and action competence: Students are able to independently design innovative systems for data management from scratch as well as to select existing systems according to requirements and use them professionally.
• Competence of judgement: Students can assess systems for data management regarding their possibilities and limitations for specific requirements.

None

This course serves as an introduction to the basic topics of modern database systems and covers the following topics:

• Overview of current database systems
• Conceptual database design (ER modeling)
• Object relational data model and relational algebra
• Logical database design
• Data definition and data manipulation with SQL
• Transactions and multi-user operations
• Formal database design (normalization theory)
• Introduction OGC compliant spatial data types and extensions
• Introduction to standard temporal data types and extensions
• Exercises with PostgreSQL and PostGIS

Atzeni P., et al.: Database Systems: Concepts, Languages, Architectures. McGraw-Hill. 1999
Beaulieu A.: Learning SQL: Generate, Manipulate, and Retrieve Data. 3. Edition. O'Reilly Media. 2020
Hsu L., Obe R.: PostGIS in Action. 3. Edition. Manning. 2021

Lecture, practical lab exercises with PostgreSQL and PostGIS, presentation(s), problem-based learning

Integrated module examination
Immanent examination character:
Final exam, active participation in-class, short tests, lab assignments, presentation(s)