Spatial Databases


In general terms, this curricular unit aims to provide an introductory perspective towards concepts related to the design, development, management and use of spatial databases, through the provision of a theoretical reference body and the resolution of practical exercises based on scenarios grounded in reality.

General characterization





Responsible teacher

Miguel André Fouto Pinho de Oliveira


Weekly - Available soon

Total - Available soon

Teaching language

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




Modelação de Bases de Dados Relacionais:

Powell, Gavin. (2006).Beginning Database Design. Wrox

Linguagem SQL:

Damas, Luis. (2005). Structured Query Language, 6ª Edição, FCA.

Linguagem SQL (Websites):

Bases de Dados Espaciais em geral:

Stefanakis, E. (2014) Geographic Databases and Information Systems, CreateSpace Independent Publishing Platform

Yeoung,A.; Brent Hall, G.(2007).Spatial Database Systems - Design, Implementation and Project Management, Springer

Shekhar, Shashi; Chawla, Sanjay (2003). Spatial Databases: A Tour, Prentice Hall.

Bases de Dados Espaciais ESRI:

Arctur, David; Zeiler, Michael (2004). Designing Geodatabases - Case Studies in GIS Data Modeling, ESRI Press

Bases de Dados Espaciais ESRI (Websites):

Teaching method

1. 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.

2. Classroom component (can be replaced by videoconference): Presentation and discussion of the Final Project. 

Evaluation method

  • Self-assessment (only for progression between learning units);
  • Final exam - 20% of the curricular unit´s final classification;
  • Final project (group or individual):
    • Project report: 40% of the curricular unit´s final classification;
    • Project discussion and defense (individual): 40% of the curricular unit´s final classification.

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