ID:
SCV0321
Duration (hours):
48
CFU:
6
SSD:
INFORMATICA
Year:
2025
Overview
Date/time interval
Secondo Semestre (23/02/2026 - 29/05/2026)
Syllabus
Course Objectives
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.
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.
Course Prerequisites
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.
An understanding of the English language is required, as part of the teaching material consists of extracts from scientific publications written in that language.
Teaching Methods
The learning objectives of the course will be achieved through lectures for a total of 48 hours
Assessment Methods
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.
Contents
The first part of the course deals with the object-relational data model:
1. complex data types in SQL: 1999 (5 hours, objective 1),
2. structured types and inheritance in SQL (3 hours, objective 1),
3. nested relationships (3 hours, objective 1),
4. collection types (3 hours, objective 1).
The second part of the course deals with semi-structured data models based on XML:
1. XML data, SGML and HTML (2 hours, objective 2),
2. DTD (3 hours, objective 2),
3. XML Schema, simple types and complex types (4 hours, objective 2),
4. XML InfoSet and Document Object Model (3 hours, objective 2),
5. introduction to the data model used by XQuery (2 hours, objective 2),
6. XPath (2 hours, objective 2),
7. XQuery (3 hours, objective 2).
The last part of the course deals with the database graphs:
1. describe resources in RDF (2 hours, objective 2),
2. RDFS, RDF / XML (3 hours, objective 2),
3. inference rules for RDF / RDFS (1 hour, objective 2),
4. triplestores (1 hour, objective 2),
5. Sparql (2 hours, objective 4),
6. Graph databases. Cipher and Gremlin (6 hours, objective 2)
1. complex data types in SQL: 1999 (5 hours, objective 1),
2. structured types and inheritance in SQL (3 hours, objective 1),
3. nested relationships (3 hours, objective 1),
4. collection types (3 hours, objective 1).
The second part of the course deals with semi-structured data models based on XML:
1. XML data, SGML and HTML (2 hours, objective 2),
2. DTD (3 hours, objective 2),
3. XML Schema, simple types and complex types (4 hours, objective 2),
4. XML InfoSet and Document Object Model (3 hours, objective 2),
5. introduction to the data model used by XQuery (2 hours, objective 2),
6. XPath (2 hours, objective 2),
7. XQuery (3 hours, objective 2).
The last part of the course deals with the database graphs:
1. describe resources in RDF (2 hours, objective 2),
2. RDFS, RDF / XML (3 hours, objective 2),
3. inference rules for RDF / RDFS (1 hour, objective 2),
4. triplestores (1 hour, objective 2),
5. Sparql (2 hours, objective 4),
6. Graph databases. Cipher and Gremlin (6 hours, objective 2)
Course Language
italian
More information
Lecture notes provided by the teacher, available on the University's e-learning site. Meeting with the instructor by appointment via email to name.surname@uninsubria.it. The professor replies only to signed emails coming from the domain studenti.uninsubria.it.
Degrees
Degrees
COMPUTER SCIENCE
Bachelor’s Degree
3 years
No Results Found
People
People
Docenti di ruolo di IIa fascia
No Results Found