Geographical Informational Systems (2008/2009)

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 2, 2008 al Dec 19, 2008.

Lesson timetable

1° Q
Day Time Type Place Note
Monday 3:30 PM - 5:30 PM lesson Lecture Hall A from Oct 28, 2008  to Dec 19, 2008
Tuesday 10:30 AM - 11:30 AM lesson Lecture Hall I  
Wednesday 11:30 AM - 1:30 PM lesson Lecture Hall E  

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.

Syllabus

.

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