1. Home
  2. NOVA Information Management School
  3. Master of Geographic Information Systems and Science
  4. Spatial Databases

Spatial Databases

Objectives

The Spatial Databases 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

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

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):

http://www.techonthenet.com/index.php 
http://www.w3schools.com/sql/default.asp

 

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):
https://desktop.arcgis.com/en/desktop/latest/manage-data/geodatabases/an-overview-ofgeodatabase-design.htm

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) - 80% of the curricular unit´s final classification;

 

  • 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 Modelling  

 

Module 5: SQL Tutorial 

 

Module 6: Spatial Databases 

 

Module 7: Creating, Managing and Editing ArcGIS Desktop Geodatabases 

 

Module 8: Open-Source Spatial Databases