Skip to content
Technische Universität Berlin Deutsch
Course catalog and module transfer system

FOU Geo-DatabasesModule description #60201 / Version 1

← Module page Deutsche Fassung
This module description is not valid in the current semester (Winter semester 2026/27).
Module / Version#60201 / #1
ValiditySS 2014 – WS 2015/16
Available language(s)English
Credit points6
Person responsible for the moduleNeitzel, Frank
GradingGraded
Exam formatOral exam
Language(s) of instructionEnglish

Affiliation

FacultyFakultät VI
InstituteInstitut für Geodäsie und Geoinformationstechnik (IGG)
Academic chair36331100 FG Methodik der Geoinformationstechnik

Contact

OfficeH 12
Contact personNot specified
E-mail addresslecturer@gis.tu-berlin.de
WebsiteNot 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 %)

Module components

Compulsory area

The following courses are mandatory for this module:

CoursesTypeNumberFrequencyLanguageHours per weekCourse catalog
Geo-DatabasesLecture3633 L 203 Winter semester–2 ISIS
Geo-DatabasesExercise3633 L 204 Winter semester–2 ISIS

Workload and credit points

Geo-Databases (Lecture)

Workload descriptionMultiplierHoursTotal
Overall attendance152 h30 h
Preparation and post - processing152 h30 h
60 h

Geo-Databases (Exercise)

Workload descriptionMultiplierHoursTotal
Overall attendance152 h30 h
Preparation and post - processing152 h30 h
60 h

Course-independent workload

Workload descriptionMultiplierHoursTotal
Examination preparation160 h60 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%)

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

GradingGraded
Exam formatOral exam
LanguageEnglish

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