Lecturer: Prof. Dr. Andreas Oberweis

Description

The application of distributed database technology in the Internet provides the fundamental concepts for efficient and reliable data management in electronic business and electronic commerce. This course is designed to give an overview of the theory and the central methods of distributed database management systems. The course starts with a discussion of the main requirements related to data management in networked environments. Different architectural models for distributed database management systems are presented. Important aspects such as database design, data allocation, query optimization, integrity enforcement, recovery, concurrency control and data security are considered. It is shown how distributed databases can be integrated into the World Wide Web. Specific problems related with mobile applications are discussed and new solutions are presented. In addition to relational database systems, object-relational systems and database systems with XML support are discussed.

Outline

1. Introduction (week 1)
2. Architectures of distributed database management systems (weeks 2-3)
3. Design of data distribution (weeks 3-4)
4. Transaction Management (weeks 5-6)
5. Data security and privacy issues (week 7)
6. Concurrency control (weeks 8-9)
7. Distributed query processing (weeks 10-12)
8. Recovery (weeks 13-14)
9. Outlook (week 15)

Literature

Oezsu, T., Valduriez, P.: Principles of Distributed Databases, 2nd Edition, Prentice Hall 1999.

Learning Objectives

This course aims to provide students with in-depth knowledge of the theory and central methods of distributed database management systems. Upon successfully completing the course, students will:

1. know relevant architectures for distributed database management systems,

2. be familiar with basic techniques of data fragmentation and allocation,

3. understand how distributed transactions are processed and how the 2-phase-commit protocol is applied,

4. be aware of the problems related with data security and privacy in distributed environments,

5. know the basic optimization techniques for distributed query processing,

6. be able to explain and apply recovery techniques in the case of a distributed database failure

Method of teaching

This course is a hypermedia course (type 2). Each lesson includes structured hypertext parts linked to other multimedia material, for example research papers and web resources regarding software products in the area of distributed database management systems.
In the accompanying exercises, applications of the models and methods taught in the lessons are shown based on case studies.

Requirements

The course requires basic knowledge of database management systems and the relational data model (see MBI course "Data Management").

Credits

6.0 credit points