Digital Teaching
The course is planned digitally in WS 21/22.
Lehrinhalte
Introduction to databases and database management systems: development, terms & definitions, architecture and layer models
Data modelling and abstract database design (ERM, UML)
Implementation of database designs using the example of the relational database model: tables, views, keys, relationships, relational algebra
Database languages using the example of SQL: database definition, data query, data modification
Advanced aspects of relational databases: Integrity, data protection, indexing
Introduction to object-oriented and object-relational database models
Concepts of spatial databases: introduction to geodata, geodata models: geometry (vector&raster, hybrid, simple features), topology, factual dataImplementations of spatial databases: spatial data types, spatial indexing and spatial query functions (examples with PostgreSQL and SQLite)
Online-Angebote
Moodle
The course is planned digitally in WS 21/22.
Lehrinhalte
Introduction to databases and database management systems: development, terms & definitions, architecture and layer models
Data modelling and abstract database design (ERM, UML)
Implementation of database designs using the example of the relational database model: tables, views, keys, relationships, relational algebra
Database languages using the example of SQL: database definition, data query, data modification
Advanced aspects of relational databases: Integrity, data protection, indexing
Introduction to object-oriented and object-relational database models
Concepts of spatial databases: introduction to geodata, geodata models: geometry (vector&raster, hybrid, simple features), topology, factual dataImplementations of spatial databases: spatial data types, spatial indexing and spatial query functions (examples with PostgreSQL and SQLite)
Online-Angebote
Moodle
- Lehrende: Andreas Eichhorn
- Lehrende: Christian Hickel
- Lehrende: Vivien Volland
Semester: WT 2021/22