Teaching code

4S004549

Credits

12

Coordinator

Carlo Combi

Language

English

Also offered in courses:

• Data management and machine intelligence - DATA MANAGEMENT SYSTEMS - Theory of the course Master's Degree in Computer Engineering for Intelligent Systems
• Data management and machine intelligence - DATA MANAGEMENT SYSTEMS - Laboratory of the course Master's Degree in Computer Engineering for Intelligent Systems

Scientific Disciplinary Sector (SSD)

INF/01 - INFORMATICS

Courses Single

Authorized

Moodle Seminars 0

The teaching is organized as follows:

Learning objectives

Knowledge and understanding: The goal of this course is to provide the student with the knowledge and understanding of the theoretical, methodological and technological main concepts related to database systems and their use for the management of biomedical and bioinformatics data and information. Applying knowledge and understanding: The student will be able to a) define through a formal model the structure and the features of complex data collections; b) specify queries on complex data through different query languages; c) understand the advanced requirements for the management of biomedical information. Making judgements: The student will acquire the capability of autonomously evaluate different design options for complex systems, and of autonomously propose effective solutions in the application domain related to biomedicine and bioinformatics. Communication: The student will be also able to interact with different stakeholders in multidisciplinary teams, having different skills and backgrounds in biomedicine and bioinformatics. Lifelong learning skills: The student will acquire the capability of learning new methodologies and technologies related to data management and applying them in the biomedical/bioinformatics domain.

Prerequisites and basic notions

Basic concepts of database systems

Program

** Fundamentals of database systems
- The relational model: relational calculus, functional dependencies, normal forms, and decompositions.
- Conceptual data design in UML (non-relational data modeling).
- Object-oriented and object-relational databases: data modeling and querying in SQL 3, conceptual modeling with UML, and translation of UML schemas into SQL 3.
- Temporal databases: basic concepts, advanced models, temporal functional dependencies, and query languages (TSQL2 and SQL:2011).
- SQL 3 tutorials in PostgreSQL.
** Biomedical and bioinformatics data management
- Medical records and medical record management systems
- Querying semi-structured biomedical data
- Information retrieval techniques (outline)

Didactic methods

Lectures and exercises (with laboratory)

Learning assessment procedures

* Fundamentals of Database Systems Theory
The exam for this part consists of a written test lasting approximately 2.5 hours. The exam contains: (i) exercises on query specification and database design using the various models covered in the program, and (ii) open-ended questions on theory. A midterm exam on the part of the program regarding the relational model is scheduled during the year, on a date to be agreed upon with students.
** Biomedical and Bioinformatics Data Management
This part has an oral exam, which includes questions on the more theoretical parts as well as short exercises on the more applied aspects.

Evaluation criteria

- Clarity and completeness of answers to questions on the course topics. - Correctness of the solution to the proposed database query exercise.

Criteria for the composition of the final grade

Average of the results obtained in the written and oral parts.

Exam language

Inglese