Advanced Data Base Systems (2013/2014)

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
Location
VERONA
Period
II semestre dal Mar 3, 2014 al Jun 13, 2014.

Lesson timetable

II semestre
Day Time Type Place Note
Tuesday 2:30 PM - 4:30 PM optional practice session Lecture Hall I from Mar 5, 2014  to Jun 13, 2014
Tuesday 4:30 PM - 6:30 PM lesson Lecture Hall I from Mar 5, 2014  to Jun 13, 2014
Wednesday 4:30 PM - 6:30 PM lesson Lecture Hall D from Mar 5, 2014  to Jun 13, 2014
Thursday 4:30 PM - 6:30 PM lesson Lecture Hall C from Mar 5, 2014  to Jun 13, 2014

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.