Teaching code

4S004549

Credits

12

Coordinator

Carlo Combi

Language

English

Location

VERONA

Also offered in courses:

• Advanced Data Base Systems of the course Master's degree in Computer Science and Engineering

Scientific Disciplinary Sector (SSD)

ING-INF/05 - INFORMATION PROCESSING SYSTEMS

Moodle Seminars 0

The teaching is organized as follows:

Learning outcomes

This course provides students with the knowledge about the basic concepts of database systems and their application in the modeling and management of biomedical data and information. Students will be able to understand the needs related to the management of biomedical information and will be able to autonomously propose suitable solutions for these complex biomedical domains. Students will be able to interact with different stakeholders, within a multidisciplinary community. He will also be able to acquire and use knowledge about all the future advances both in methodologies and technologies for the management of data and their application in the biomedical domain.
------------------------
MM: Fundamentals of database systems
------------------------
This module of the course provides the student with the main theoretical concepts of the relational data model, of object and object-relational data models, and of temporal and spatio-temporal data models. Related query languages will be introduced and some related technical issues will be discussed.
------------------------
MM: Biomedical and bioinformatic data management
------------------------
The main aim of this course is introducing the students to manage biomedical and bioinformatics databases. In particular, object-oriented modeling techniques for clinical databases will be considered, together with the management of semistructured data (e.g., XML). Attention will be paid to information retrieval techniques.

Program

------------------------
MM: Fundamentals of database systems
------------------------
* The relational data model: relational calculus, functional dependencies, normal forms and decompositions.
* Conceptual data modeling in UML
* Object and object-relational databases: data model and query language of SQL 3, UML for modeling object oriented databases.
* Temporal and Spatio-Temporal databases: basic concepts, data models, query languages (TSQL2, Simple Feature Specification for SQL OGC).
------------------------
MM: Biomedical and bioinformatics data management
------------------------
* Electronic Medical Record systems
* Temporal Clinical Databases
* Querying biomedical XML data: XML, DTD, XML Schema, Xpath and Xquery
* Information retrieval techniques (a survey)

Bibliography

Examination Methods

The final score of the exam is the average of the scores obtained in the exams related to the modules.
------------------------
MM: Fundamentals of database systems
------------------------
The exam for this module consists of a written test of about 2.5 hours containing: (i) some exercises requiring the specification of queries and database design using one of the database models included in the program and (ii) open questions about the theory. During the semester, in a date to be decided with the students, an intermediate test will be proposed on the part of the program regarding: the relational calculus, the functional dependencies and the normalization.
------------------------
MM: Biomedical and bioinformatics data management
------------------------
The exam consists of an oral examinations with exercises and questions related to the different parts of the module, with the goal of verifying whether the student is aware of the theoretical content of the module and is able to apply it in real-world contexts.