Advanced Data Base Systems (2012/2013)

Course code
4S001162
Name of lecturer
Carlo Combi
Coordinator
Carlo Combi
Number of ECTS credits allocated
6
Academic sector
INF/01 - INFORMATICS
Language of instruction
Italian
Period
II semestre dal Mar 4, 2013 al Jun 14, 2013.

Lesson timetable

II semestre
Day Time Type Place Note
Tuesday 2:30 PM - 4:30 PM lesson Lecture Hall D  
Tuesday 4:30 PM - 6:30 PM lesson Lecture Hall I  
Thursday 4:30 PM - 6:30 PM lesson Lecture Hall I  
Friday 4:30 PM - 6:30 PM lesson Lecture Hall I  

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.

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

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

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

Assessment methods and criteria

The final exam is an oral examination, with questions and exercises on the considered topics.