Geospatial Databases

Objectives

The Geospatial Databases curricular unit aims to provide an introductory perspective on concepts related to the design, development, management, and use of geospatial databases, through the provision of a theoretical reference body and the resolution of practical exercises based on scenarios grounded in reality.

General characterization

Code

200009

Credits

7.5

Responsible teacher

Miguel André Fouto Pinho de Oliveira

Hours

Weekly - Available soon

Total - Available soon

Teaching language

Portuguese. If there are Erasmus students, classes will be taught in English

Prerequisites

None

Bibliography

Teaching method

E-Learning component:

  • Synchronous tools - E-Learning Synchronous Sessions - Teacher/Class; Videoconference Sessions - Teacher/Student; Self-Evaluation Tests; Final Examination Test.
  • Asynchronous tools - Discussion Forum. Access to learning contents on the e-learning platform
Classroom component (can be replaced by videoconference):
  • Presentation and discussion of the Final Project  

Evaluation method

Final Project Report: 40%
Final Project Discussion: 40%
Final Examination: 20%

Subject matter

Module 1: Introduction
Module 2: Aspects of Database Theory
Module 3: Aspects of the Relational Model
Module 4: Database Modeling 
Module 5: SQL Tutorial
Module 6: Spatial Databases
Module 7: Creating, Managing and Editing ArcGIS Desktop Geodatabases
Module 8: Open-Source Spatial Databases