GeodatabasesModule description #61432 / Version 3
- 6 CP
- Written exam
- Graded
- Winter semester
- English
| Module / Version | #61432 / #3 |
|---|---|
| Validity | Since Winter semester 2026/27 |
| Available language(s) | English |
| Credit points | 6 |
| Person responsible for the module | Kada, Martin |
| Grading | Graded |
| Exam format | Written exam |
| Language(s) of instruction | English |
Affiliation
| Faculty | Fakultät VI |
|---|---|
| Institute | Institut für Geodäsie und Geoinformationstechnik (IGG) |
| Academic chair | 36331100 FG Methodik der Geoinformationstechnik |
Contact
| Office | H 12 |
|---|---|
| Contact person | Not specified |
| E-mail address | martin.kada@tu-berlin.de |
| Website | Not specified |
Learning outcomes
Students understand advanced concepts of object-relational database systems, including abstract data types as well as spatial and temporal database extensions, and are able to assess their applicability in the management of geospatial information. They can design, implement, manage, and query geodatabases for different geospatial data models, including vector, raster, network, and point cloud data, enabling efficient storage, retrieval, and analysis of spatial information. Students are familiar with object-oriented data modelling approaches in geographic information science and can translate conceptual models into relational and object-relational database schemas. They are proficient in using spatial query languages and database management tools to access and analyse geospatial data. Furthermore, they understand and apply international standards for geographic information to ensure data quality, consistency, and interoperability.
Content
Database management systems, relational and object-relational data models, database normalization, data integrity and transaction management, database design and implementation, object-oriented data modelling and mapping to relational schemas, query languages (SQL) and spatial extensions, geodatabase concepts and extensions for vector, raster, network, and point cloud data, geometric operations, spatial reference systems, spatial indexing methods, spatial and topological relationships, spatial joins and query processing, international standards for geographic information and geospatial interoperability.
Module components
Compulsory area
The following courses are mandatory for this module:
| Courses | Type | Number | Frequency | Language | Hours per week | Course catalog |
|---|---|---|---|---|---|---|
| Spatial Data Modeling and Management | Lecture | Winter semester | [en] | 2 | WS 2026/27 (1) ISIS | |
| Spatial Schema Design and Querying | Integrated course | Winter semester | [en] | 2 | WS 2026/27 (2) ISIS |
Courses in the course catalog
Courses created from the teaching units of this module.
Winter semester 2026/27 (3)
Spatial Data Modeling and Management (Lecture) 1
- Spatial Data Modeling and Management (Vorlesung) Termingruppe 1
Spatial Schema Design and Querying (Integrated course) 2
- Spatial Schema Design and Querying (Integrierte Veranstaltung) Termingruppe 1
- Spatial Schema Design and Querying (Integrierte Veranstaltung) Termingruppe 2
Workload and credit points
Spatial Data Modeling and Management (Lecture)
| Workload description | Multiplier | Hours | Total |
|---|---|---|---|
| Attendance | 15 | 2 h | 30 h |
| Pre/post processing | 15 | 4 h | 60 h |
| 90 h | |||
Spatial Schema Design and Querying (Integrated course)
| Workload description | Multiplier | Hours | Total |
|---|---|---|---|
| Attendance | 15 | 2 h | 30 h |
| Pre/post processing | 15 | 4 h | 60 h |
| 90 h | |||
The workload of the module adds up to 180 hours. The module therefore comprises 6 credit points.
Description of teaching and learning methods
Lectures (50%) and exercises (50%).
Requirements for participation and examination
Desirable prerequisites for participation in the courses:
Computer literacy.
Mandatory requirements for the module examination registration:
This module has no examination requirements.
Completion of the module
| Grading | Graded |
|---|---|
| Exam format | Written exam |
| Language | English |
| Duration/Extent | 120 Minutes |
Duration of the module
The following number of semesters is estimated for taking and completing the module: 1 semester(s).
This module can be started in the following semesters: Winter semester.
Maximum number of participants
This module is not limited to a number of students.
Registration procedures
No information.
Recommended reading, lecture notes
Lecture notes
unavailable
Electronic lecture notes
available
Recommended literature
No recommended literature given
Assigned programs
This module version is used in the following programs:
| Program / program version | Semester(s) | Curriculum component |
|---|---|---|
| Geodesy and Geoinformation Science StuPO 2007 (21.03.2007) | WS 2026/27 | 1. Foundation subjects › 1. Basisbereich |
Miscellaneous
Not specified