Traditional Database Architecture |
Date |
Topic |
Notes |
08/28 |
Introduction |
08/30 |
Database Internals |
Read Sections 1-3 |
09/06 |
System R |
Requires a UMD IP for access. Read up to page 122 (i.e. up to the section entitled "transaction management"). |
09/11 |
Introduction to Transaction Processing |
Read pages 1-22 (and the first 2 lines of page 23). Skip section 2.2 (pages 10-14) |
09/13 |
Optimistic Concurrency Control |
Read entire paper |
09/18 |
MVCC |
Read section 27.4 until (and including) 27.4.1.4 |
09/20 |
Catch-up |
09/25 |
Memory Management |
Requires a UMD IP for access. Read pages 311-319. |
09/27 |
Storage Management |
Read Section 5; We will also continue the discussion of the paper from the previous class. |
10/02 |
Introduction to Logging and Recovery |
Read Section 2.2 (pages 10-14). |
10/04 |
Catch-up |
10/09 |
ARIES |
Requires a UMD IP for access. Pages 1-35 except Section 5.3. This is a long and difficult paper; we may need more than one lecture discussing it. Focus on understanding the core recovery protocol. |
10/11 |
Join Algorithms |
Requires a UMD IP for access. Read Sections 1-4, but focus on the first 2. |
10/16 |
Catch-up |
10/18 |
Catch-up |
Distributed Database Systems |
Date |
Topic |
Notes |
10/23 |
Introduction to Distributed Database Systems and 2PC |
May require UMD IP to access |
10/25 |
Mid-term Exam |
Large Scale Transactional Databases |
Date |
Topic |
Notes |
10/30 |
Go over exam answers and finish discussing the intro to distributed database systems reading from last week |
No new reading |
11/01 |
Calvin |
|
11/06 |
Dynamo |
|
11/08 |
Bigtable |
11/13 |
Spanner |
|
11/15 |
Silo |
|
Parallel Databases and Analytical Data Processing |
Date |
Topic |
Notes |
11/20 |
Introduction to parallel/scalable database systems |
No new reading for this class |
11/27 |
C-Store |
11/29 |
MapReduce |
|
12/04 |
Spark |
Final Project Presentations |
12/06 |
Project Presentations |
12/11 |
Project Presentations |