Advanced Data Base Systems (2014/2015)

Course code
4S001162
Name of lecturer
Alberto Belussi
Coordinator
Alberto Belussi
Number of ECTS credits allocated
6
Academic sector
INF/01 - INFORMATICS
Language of instruction
Italian
Period
II sem. dal Mar 2, 2015 al Jun 12, 2015.

Lesson timetable

II sem.
Day Time Type Place Note
Monday 4:30 PM - 6:30 PM lesson Lecture Hall C  
Friday 10:30 AM - 1:30 PM lesson Not defined from Mar 10, 2015  to Mar 12, 2015
Friday 3:30 PM - 6:30 PM lesson Lecture Hall C from Mar 19, 2015  to Jun 12, 2015

Learning outcomes

This course provides the student with the main theoretical concepts of the relational data model, of object and object-relational data models, and of the semistructured and XML data models. Related query languages will be introduced and some related technical issues will be discussed.

Syllabus

The relational data model: relational calculus, functional dependencies, normal forms and decompositions.

Object and object-relational databases: data models and query languages.

Semistructured databases: basic concepts, XML, XML Schema, XPath, and Xquery.

Spatio-Temporal databases: basic concepts, data models, query languages, and technological issues.

Reference books
Author Title Publisher Year ISBN Note
R. Elmasri, S. B. Navathe Fundamentals of Database Systems (Edizione 1) Addison-Wesley 1994 0805317481
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 final exam is an oral examination (with a previous written test), with questions and exercises on the considered topics.

Statistics about transparency requirements (Attuazione Art. 2 del D.M. 31/10/2007, n. 544)

Statistics
Outcomes Exams Outcomes Percentages Average Standard Deviation
Positive 66.66% 27 1
Rejected 8.33%
Absent 16.66%
Ritirati 8.33%
Canceled --
Distribuzione degli esiti positivi
18 19 20 21 22 23 24 25 26 27 28 29 30 30 e Lode
0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 12.5% 0.0% 37.5% 25.0% 0.0% 0.0% 12.5% 12.5%

Data from AA 2014/2015 based on 12 students. I valori in percentuale sono arrotondati al numero intero più vicino.