Geographic and Multimedia information systems (2014/2015)

Course code
Name of lecturer
Alberto Belussi
Alberto Belussi
Number of ECTS credits allocated
Academic sector
Language of instruction
I sem. dal Oct 1, 2014 al Jan 30, 2015.

Lesson timetable

Learning outcomes

This course has the aim to provide students with the concepts and methodologies for the design and implementation of geographical and multimedia databases. In particular:
- A methodology for the conceptual modelling of a geographical database in GeoUML will be presented. GeoUML is a conceptual model for the design of spatial databases compatible with the ISO standards 19100.
- The mappings of a GeoUML conceptual schema onto geo-relational databases will be illustrated. Moreover, an extended version of the relational algebra for querying a geo-relational database will be analyzed.


The program includes:
- object oriented databases: ODMG, ODL and OQL standards
- conceptual modelling of an object oriented databases in UML and mapping a UML class diagram to ODL
- multimedia databases: representation, management and querying multimedia datasets
- geographical databases: spatial data characteristics and spatial relations
- conceptual modelling of geographical databases: the GeoUML model.
- logical modelling of geographical databases: mapping rules from GeoUML towards geo-relational models (Simple Feature Specification of OGC)
- query languages for geographical databases: a geo-relational algebra.

Reference books
Author Title Publisher Year ISBN Note
P. Atzeni, S. Ceri, P. Fraternali, S. Paraboschi, R. Torlone Basi di dati (Edizione 4) McGraw-Hill 2014 978-88-386-6587-5
Lynne Dunckley Multimedia Databases:An Object Relational Approach Addison-Wesley 2002 0201788993
P. Rigaux, M. Scholl and A. Voisard Spatial Databases with Application to GIS Morgan Kaufmann  
R. G. G. Cattell The Object Data Standard: ODMG 3.0 Morgan Kaufmann 2000 1-55860-64

Assessment methods and criteria

The exam is composed of a single written test and eventually with a project to be implemented in the context GIS technology.