FOU Geo-DatabasesModule description #60201 / Version 2
- 6 CP
- Oral exam
- Graded
- Winter semester
- English
This module description is not valid in the current semester (Winter semester 2026/27).
| Module / Version | #60201 / #2 |
|---|---|
| Validity | SS 2016 – WS 2016/17 |
| Available language(s) | English |
| Credit points | 6 |
| Person responsible for the module | Kada, Martin |
| Grading | Graded |
| Exam format | Oral 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 | lecturer@gis.tu-berlin.de |
| Website | Not specified |
Learning outcomes
Students will learn methods for object-oriented spatial data modeling in the field of geoinformation sciences and how to map the models to a relational database schema. They gain experience in both data modeling and database querying languages such as UML and SQL. They understand advanced theoretic concepts and operations of spatial database systems and are able to apply methods for data integrity and geometric-topological relations. During hands-on-exercises the students set up and manage a real world spatial database environment. They apply the acquired knowledge, e.g. on spatial index structures and performance optimised queries, in order to guarantee efficient data retrieval.
Content
Geo-Databases [VL 3633 L 203], [UE 3633 L 204]
Content
- Database management systems
- Relational data model
- Normalisation
- Queries in SQL
- Data integrity
- Data base design, modelling with UML
- Mapping the model onto a relational schema
- Management of spatial data using spatial database management systems (e.g. Oracle)
- Use of reference systems in spatial database systems
- Geometric and topologic relations with geo-databases
- Spatial index structures
- Query strategies for performance enhancement (spatial filter etc.)
Didactic concept
- Lecture (50 %)
- Hands-on exercises (50 %)
Content
- Database management systems
- Relational data model
- Normalisation
- Queries in SQL
- Data integrity
- Data base design, modelling with UML
- Mapping the model onto a relational schema
- Management of spatial data using spatial database management systems (e.g. Oracle)
- Use of reference systems in spatial database systems
- Geometric and topologic relations with geo-databases
- Spatial index structures
- Query strategies for performance enhancement (spatial filter etc.)
Didactic concept
- Lecture (50 %)
- Hands-on exercises (50 %)
Module components
Compulsory area
The following courses are mandatory for this module:
Workload and credit points
Geo-Databases (Lecture)
| Workload description | Multiplier | Hours | Total |
|---|---|---|---|
| Overall attendance | 15 | 2 h | 30 h |
| Preparation and post - processing | 15 | 2 h | 30 h |
| 60 h | |||
Geo-Databases (Exercise)
| Workload description | Multiplier | Hours | Total |
|---|---|---|---|
| Overall attendance | 15 | 2 h | 30 h |
| Preparation and post - processing | 15 | 2 h | 30 h |
| 60 h | |||
Course-independent workload
| Workload description | Multiplier | Hours | Total |
|---|---|---|---|
| Examination preparation | 1 | 60 h | 60 h |
| 60 h | |||
The workload of the module adds up to 180 hours. The module therefore comprises 6 credit points.
Description of teaching and learning methods
-Lecture (50%)
-Hands-on exercises (50%)
-Hands-on 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 | Oral exam |
| Language | English |
| Duration/Extent | 30 Minuten |
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
unavailable
Recommended literature
- Hector Garcia-Molina, Jeffrey D. Ullman, Database Systems: The Complete Book, 2nd Ed., Pearson International, 2008
- Ramez Elmasri, Shamkant B. Navathe, Fundamentals of Database Systems, 5th Ed., Addison Wesley, 2006
- Ravikanth V. Kothuri, Albert Godfrind , Euro Beinat: Pro Oracle Spatial: From Professional to Expert, Apress, 2004 (based on Oracle 10g)
- Thomas Brinkhoff: Geodatenbanksysteme in Theorie und Praxis: Einführung in objektrelationale Geodatenbanken unter besonderer Berücksichtigung von Oracle Spatial, Wichmann; Auflage: 2nd ed., 2008)
Assigned programs
This module is not used in any program.
Miscellaneous
Not specified