Geographical Informational Systems (2007/2008)

Course partially running

Course code
4S00076
Name of lecturer
Alberto Belussi
Number of ECTS credits allocated
5
Academic sector
ING-INF/05 - INFORMATION PROCESSING SYSTEMS
Language of instruction
Italian
Period
1° Q dal Oct 3, 2007 al Dec 4, 2007.

Lesson timetable

1° Q
Day Time Type Place Note
Monday 9:30 AM - 11:30 AM lesson Lecture Hall L from Oct 15, 2007  to Dec 4, 2007
Tuesday 11:30 AM - 12:30 PM lesson Lecture Hall L from Oct 17, 2007  to Dec 4, 2007
Wednesday 11:30 AM - 1:30 PM lesson Lecture Hall A  

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

Documents