ADVANCED DATA MANAGEMENT

The aim of the course is to present the internals of database management systems and to describe the principal DBMS families. The goal is to enhance the comprehension and the advanced use of these systems by database administrators and database application's programmers.

Ability to choose the most suitable type of DBMS to meet the application requirements and to discuss the effects of architectural, modeling, and configuration choices. Ability to read and understand scientific literature regarding algorithms used in DBMS.

Databases: conceptual and relational data modelling. The query language SQL and the relational algebra

0. Persistent memory and buffer management; File structures in secondary memory; Access methods management in DBMSs; Transaction management; Concurrency in DBMSs; DBMS implementations based on Physical operators.
1. Relational DBMS architectures: Physical operators; Query optimization techniques; Physical design, tuning, and maintenance.
2. Not Only SQL: Graph Databases; XML Databases; Key-Value Stores; Document Databases; Column Stores; Extensible Record Stores; Data Stream Management.
3. Key-value store architectures and support for graphs and documents.
4. Native graph DBMS architectures.
5. Distributed Database Systems: Data Fragmentation, Replication and Synchronization, Consistency
6. Other technologies: Linked Data and SPARQL, Data Stream Management, Geographic Information Systems, In-Memory Databases, NewSQL.

A. Albano, D. Colazzo, G. Ghelli, R. Orsini. DBMS Internals, pag. 1-229, forthcoming book.
L. Wiese. Advanced Data Management for SQL, NOSQL, Cloud and Distributed Databases. 2015. De Gruyter Oldenbourg. ISBN: 978-3-11-044140-6.
Additional paper in Moodle.

The verification of the learning of the subjects of the course is through a written and oral exam. The written exam consists of a set of open-ended questions that verify the knowledge of the theory presented in the course and the capacity to apply that knowledge to practical problems. The oral test also includes the presentation of a project or an investigation on a research topic.

Lectures and lab practicals.

English

written and oral