| T, April 4 |
Introduction (PDF)
Architecture (PDF)
Chapter 1 of the textbook; read chapters 2 and 3 as a review of
concepts underlying relational databases and networks; we also start
with an introduction to DDBMS architectures |
| R, April 6 | Design (PDF) Issues in distribution
design |
| T, April 11 | Continue with Distributed
Database Design (primary horizontal fragmentation) |
| R, April 13 |
Continue with Distributed Database Design (Vertical Fragmentation) |
| T, April 18 |
Continue with Distributed Database Design (Fragment Alloacation) |
| R, April 20 |
Semantic Data Control(PDF)
Overview of Query Processing(PDF) |
| T, April 25 | Continue with introduction to
query processing (Chapter 7) |
| R, April 27 | Query decomposition and data
localization (Chapter 8) |
| T, May 2 | Query Optimization Aspects;
Centralized Query Optimization, Sections 9.1 and 9.2 |
| R, May 4 | Distributed
Query Optimization, Sections 9.3 and 9.4 |
| T, May 9 | Finish Distributed
Query Optimization, Section 9.4; Start with Distributed Transaction Management (PDF), Chapter 10 |
| R, May 11 | Introduction to Transaction Management, Chapter 10, Concurrency control, Chapter 11 |
| T, May 16 | Concurrency Control, Chapter 11 |
| T, May 18 | Reliability, Chapter 12 |
| R, May 23 |
Parallel Database Systems, Chapter 13,(PDF) |
Handouts, which summarize sections of the book, can be obtained from
this site. Note that the
handouts don't include examples that I present in class. So just having
the handouts isn't
sufficient for succeeding in this class! Occasionally,
I will also hand out extra material, such
as research papers, overview etc.
Interesting Papers on the Role of Database Systems, Future Research
Directions etc.