Spatial Databases
Objectives
This curricular unit aims to deliver an introductory perspective to the fundamental aspects related with the modeling, development, management and use of spatial databases. To achieve this goal, theoretical reference materials and several practical exercises regarding real-life implementations are provided to students. As such, its main objectives are:
1. To provide and discuss key concepts regarding the database approach to data processing, including the origins of the concept, its approach, strong and weak points, available data models and the main steps to follow in database design, implementation and management;
2. To introduce the Relational Model, the most influential and more frequently used database model in present-day database implementation;
3. To demonstrate, also through a practical example, the available methodologies to model and build a relational database, beginning with logical design, which encompasses two techniques: the EAR (Entity-Attribute-Relationship) Model, and Normalization. Physical database design is also discussed;
4. To present the Structured Query Language (SQL) and its main instructions used to create, manipulate and interrogate a relational database. The popular database software Microsoft Access will be used to demonstrate this language and its many uses;
5. To introduce Spatial Databases and its specificities, similarities and differences to the conventional (non-spatial) database designs previously discussed and to present briefly the latest developments in the field;
6. To provide a practical approach to the ESRI Geodatabase model, focused on creating, managing, editing and using ESRI Geodatabases in the ArcGIS Desktop environment;
7. To present Open-Source Spatial Databases, a relatively recent development. This approach is developed through several practical examples, implemented in PostgreSQL with its Spatial Extension PostGIS. The Open-Source GIS Software QGIS is also used for access and visualization purposes.
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