Spatial Databases
Objectives
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
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):
- 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