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.
.
| 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 |
The exam is made of a single written test.
Dispensa sulla teoria della normalizzazione
(pdf, it, 361 KB, 07/10/08)
Lucidi sul calcolo relazionale
(pdf, it, 939 KB, 05/11/08)
Lucidi sul data warehousing
(pdf, it, 258 KB, 17/11/08)
Lucidi sulle basi di dati attive
(pdf, it, 161 KB, 11/11/08)
© 2025 | Verona University
******** CSS e script comuni siti DOL - frase 9957 ********
