Distributed Data Management
Organization
Lecturer: | Dr. Eike Schallehn |
Lecture: | LSF-Entry |
Exercise: | LSF-Entry |
Exam requirements
- The exam will take place as a written exam. Registration using the LSF/HISQUIS system is required according to the general procedures.
- Participation in the lecture and in the exercise is required.
News
- Exercises will start in on Nov 6th and Nov 8th
- The lecture starts in the first week of the teaching period.
Content
- Overview and classification of distributed data management (distributed DBMS, parallel DBMS, fedrated DBMS, P2P)
- Distributed DBMS: architecture, distribution design, distributed query processing and optimization, distributed transactions, and transactional replication
- Parallel DBMS: fundamentals of parallel processing, types of parallelization in DBMS, parallel query processing.
Lecture
Lecture handouts will be made available here over the course of the lecture.
- Handout Part 1: Introduction
- Handout Part 2: DDBS Foundations and Design
- Handout Part 3: DDBS Query Processing
- Handout Part 4: Distributed Transaction Processing
As an alternative, the actual lecture slides can be found here: slides.ddm.pdf
Excercises
Exercise sheets will be made available here over the course of the lecture.
- 01_exercise: Recapitulation
- 02_exercise: Multi-Processor DBMS
- 03_exercise: Foundations
- 04_exercise: Fragmentation
- 05_exercise: Optimal Fragmentation
- 06_exercise: Allocation and Replication
- 07_exercise: Query Processing I
- 08_exercise: Query Processing II
- 09_exercise: Cost-based Optimization
- 10_exercise: TXN Processing I
- 11_exercise: TXN Processing II
Old exams
As an orientation for future exams, an old exam sheet can be found here: ddm_exam_wise1516.pdf
Literature
Literature references and recommended readings are listed in the lecture handouts.