Objectives
The course presents the principles of database technology both in a distributed and in a parallel environment. The course covers the classical topics concerning Database Management Systems (DBMS) both in a distributed and in a parallel environment: architecture, design, query processing, transaction management.

Syllabus
1) Distributed DBMS architecture
2) Distributed database design
a. Fragmentation design
b. Allocation design
3) Distributed query processing
a. Query decomposition
b. Optimization of access strategies
4) Distributed transaction management
a. Atomicity
b. Concurrency control
c. Reliability
5) Parallel database systems
a. Shared nothing architecure and data partitioning
b. Parallel agorithms for relational operations
c. Parallel query optimization

The examination consists of an oral exam