Syllabus2017

Lecture Notes (Fall 2017)

Introduction

• 00-Welcome.pptx
• 01-Introduction.pptx

Distributed Database Design

• 02. Distributed Database Design-1.ppt
• 02. Distributed Database Design-2.pptx

Query Processing

• Overview of Query Processing

• Query Decomposition and Localization

• Query Optimization (1/3)

• Query Optimization (2/3)

• Query Optimization (3/3)

04. Transaction Management

• Transaction Management

05. Distributed Concurrency Control

• Seralization Theory
• Pessimistic Approaches
• Optimistic Approaches

06. Distributed DBMS Reliability

• Local Reliability Protocols
• 2PC with Site Failure

Course Project

• Project Kick-off
• Example Benchmark
• Evaluation Form
• Mid-term reports:
  • Group 1 (Team Leader: Chuanwen Li): report
  • Group 2 (Team Leader: Guodong Jin): report
• Project Reports from Tsinghua Univ: here
• Sample Data:
  • ASG (eno char(20), jno char(20), resp char(20) not null, dur int not null) sample
  • EMP (eno char(20) primary key, ename char(100) not null, title char(100)) sample
  • JOB (jno char(20) primary key, jname char(20) not null, budget float not null, loc char(20) not null) sample
  • SAL (title char(100) primary key, sal float not null) sample

Course Project Evaluation

• Evaluation Document
• Evaluation Data
• Evaluation Form

Reading List

Distributed Database Design

• S. Kadambi, J. Chen, B.F. Cooper, D. Lomax, R. Ramakrishnan, A. Silberstein, E. Tam, H. Garcia-Molina. Where in the World Is My Data? Proc. of the VLDB Endowment, 2011 [PDF]