Geographical Informational Systems (2007/2008)

Course partially running

Course code
Name of lecturer
Alberto Belussi
Number of ECTS credits allocated
Academic sector
Language of instruction
1° Q dal Oct 3, 2007 al Dec 4, 2007.

Lesson timetable

Learning outcomes

This course has the objective to provide the students with the concepts and methodologies for the design and implementation of spatial databases. In particular:
- A methodology for the conceptual modelling of a geographical database in GeoUML will be presented.
- The possible mappings of a conceptual schema to a geo-relational database will be illustrated.
- A geo-relational algebra for quering a geo-relational database will be proposed.

Moreover, some advanced arguments concerning the theory of the relational databases will be illustrated: functional dependecies, normal forms, relational calculus, active databases and data warehausing.

Reference books
Author Title Publisher Year ISBN Note
P. Atzeni, S. Ceri, P. Fraternali, S. Paraboschi, R. Torlone Basi di dati. Architetture e linee di evoluzione McGraw-Hill 2003 88-386-603
M. F. Worboys GIS: A Computing Perspective (Edizione 1) Taylor & Francis 1995 0748400656
J. D. Ullman Principles of Database and Knowledge-base Systems Computer Science Press  
P. Rigaux, M. Scholl and A. Voisard Spatial Databases with Application to GIS Morgan Kaufmann  

Assessment methods and criteria

The exam is made of a single written test.

Teaching aids