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 examination consists of an oral test that assesses the knowledge of the topics presented during the course and the ability to apply them to real problems in a project or to explore them in depth by analyzing scientific articles.

Lectures and lab sessions.

English

oral