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)
Literature
Brinkhoff, Thomas: Geodatenbanksysteme in Theorie und Praxis, Wichmann Verlag
Obe, Regina: PostGIS in Action, Manning Publications
Online-Angebote
Moodle
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)
Literature
Brinkhoff, Thomas: Geodatenbanksysteme in Theorie und Praxis, Wichmann Verlag
Obe, Regina: PostGIS in Action, Manning Publications
Online-Angebote
Moodle
- Lehrende: Andreas Eichhorn
- Lehrende: Christian Hickel
Semester: Inverno 2022/23