ADVANCED DATA MANAGEMENT

Academic year
2017/2018 Syllabus of previous years
Official course title
ADVANCED DATA MANAGEMENT
Course code
CM0520 (AF:255814 AR:142478)
Modality
On campus classes
ECTS credits
6
Degree level
Master's Degree Programme (DM270)
Educational sector code
INF/01
Period
1st Semester
Course year
1
Where
VENEZIA
Moodle
Go to Moodle page
The aim of the course is to present the advanced concepts of relational databases and the architecture and implementation techniques of database management systems. The DBMS modules will be studied in detail. The objective is to enhance the comprehension and the advanced use of these systems by database administrators and database application's programmers. An introduction to Data warehouses and to the main concepts of Business Intelligence will be presented.
Databases: conceptual and relational data modelling. The query language SQL and the relational algebra
1. DBMS Architecture
2. Persistent memory and buffer management
3. File structures in secondary memory
4. Access methods management in DBMSs
5. Transaction management
6. Concurrency in DBMSs
7. Physical operators for relational DBMSs
8. Query optimization techniques
9. Physical Design, Tuning and Maintenance of relational databases
10. Introduction to business intelligence
11. Main concepts of datawarehousing
12. Introduction to Analytic SQL
A. Albano, D. Colazzo, G. Ghelli, R. Orsini. DBMS Internals, pag. 1-229, forthcoming book.
written
The verification of the learning of the subjects of the course is through a written exam. The exam consists in a set of open-ended questions and exercises that verify the knowledge of the theory presented in the course and the capacity of applying that knowledge to practical problems. During the exam books and notes cannot be used, only the material given for the exam is allowed.
English
  • Lecture notes, material for reference or for self-assessment available online or as e-book
  • E-learning, moodle platforms
  • Use of open-source software
Last update of the programme: 27/07/2017