Universidade Nova de Lisboa

Universidade Nova de Lisboa

NOVA Information Management School

Spatial Databases

Code

200009

Academic unit

NOVA Information Management School

Credits

7.5

Teacher in charge

Teaching language

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

Objectives

This course is an introductory approach to the concepts related to the design, development and management of spatial databases by providing a theoretical framework of reference and solving various practical exercises adapted to reality.
The main objectives of the course are:
1. Provide the fundamental concepts within the paradigm database, including the origins of this concept and its approach, its advantages and disadvantages, different data models currently available and generally followed phases in the design, implementation and management of a base data.
2. Enter the relational model, which is the most influential database model and more often used in current implementations.
3. Explain and illustrate the available methodologies for modeling and implementing a database, taking as practical reference the relational model. The approach includes a first part of the logical design of a database, including two techniques: Entity-Attribute-Relationship model and Standardization. The second part will focus on aspects of physical design.
4. Display the SQL (Structured Query Language) and its main instructions used in the creation, manipulation and interrogation of a relational database. To demonstrate the practical use of this language in Microsoft Access environment.
5. Enter the Spatial Data Bases taking into account their particularities, the way they fit in relation to previously developed targets and the latest developments in this field.
6. Addressing the ESRI geodatabase model and demonstrate the tasks associated with its creation, management and publishing in ArcGIS Desktop environment.
7. Provide a brief introduction to the relatively recent dynamics, spatial databases of open source (Open Source), through practical examples developed in PostgreSQL environment with spatial extension PostGIS, being also employed GIS software source code Quantum GIS open for access and viewing this type of spatial data storage medium

Prerequisites

None

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    

Bibliography

Powell, Gavin. (2006) Beginning Database Design, Wrox; Damas, Luis. (2005) Structured Query Language, 6ª Edição, FCA; Shekhar, Shashi; Chawla, Sanjay (2003) Spatial Databases: A Tour, Prentice Hall; Yeoung,A.; Brent Hall, G. (2007) Spatial Database Systems - Design, Implementation and Project Management, Springer; Arctur, David; Zeiler, Michael (2004) Designing Geodatabases - Case Studies in GIS Data Modeling, ESRI Press

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%

Courses