ADVANCED MODELS FOR DATA MANAGEMENT

Degree course: 
Corso di First cycle degree in COMPUTER SCIENCE
Academic year when starting the degree: 
2018/2019
Year: 
2
Academic year in which the course will be held: 
2019/2020
Course type: 
Supplementary compulsory subjects
Credits: 
6
Period: 
Second semester
Standard lectures hours: 
48
Detail of lecture’s hours: 
Lesson (48 hours)
Requirements: 

The student knows about of the topics presented in an introductory course on Relational Databases. Therefore, the student knows the relational data model, the relational algebra, the SQL query language, the conceptual and logical design of a relational database.
An understanding of the English language is required, as part of the teaching material consists of extracts from scientific publications written in that language.

Final written test: The test assigns a final grade - expressed in thirtieths - based on the student's knowledge and comprehension skills, relative to the topics contained in the course program. The written test consists of 4 questions, 2 of a theoretical nature and 2 exercises.
The written test is considered passed with a grade equal to or greater than 18/30.

Assessment: 
Voto Finale

The student will acquire:
1- knowledge related to advanced aspects of data management regarding extensions of the relational model (in particular, the object-relational data model).
2- knowledge to manage data using other models, such as xml and graph-based semi-structured data models, based on rdf and on the conceptual graph data model. The related query languages will also be presented.

Therefore, the student:
3- will develop the ability to identify a problem related to modeling and / or query data according to the presented topics and to solve it in a professional way.
4- will be able to judge the quality of the design of a database developed in one of the above models.
5- will be able to design a database using the data models presented in the course and to use the related query languages, depending on the design requirements.

The first part of the course deals with the object-relational data model:
1. complex data types in SQL: 1999 (5 hours),
2. structured types and inheritance in SQL (3 hours),
3. nested relationships (3 hours),
4. collection types (3 hours).
The second part of the course deals with semi-structured data models based on XML:
1. XML data, SGML and HTML (2 hours),
2. DTD (3 hours),
3. XML Schema, simple types and complex types (4 hours),
4. XML InfoSet and Document Object Model (3 hours),
5. introduction to the data model used by XQuery (2 hours),
6. XPath (2 hours),
7. XQuery (3 hours).
The last part of the course deals with the database graphs:
1. describe resources in RDF (2 hours),
2. RDFS, RDF / XML (3 hours),
3. inference rules for RDF / RDFS (1 hour),
4. triplestores (1 hour),
5. Sparql (2 hours),
6. Graph databases. Cipher and Gremlin (6 hours)

Lecture notes provided by the instructor, available on the University's e-learning site.

Convenzionale

The learning objectives of the course will be achieved through lectures for a total of 48 hours.

Meeting with the instructor by appointment via email to alberto.trombetta@uninsubria.it. The professor replies only to signed emails coming from the domain studenti.uninsubria.it.