Day | Topic | Notes | Last Updated | Readings |
---|---|---|---|---|
Mar 11 | Logistics, Introduction, Overview | ppt | Mar 11 | Chapter 11.1 |
Mar 13 - 17 | Data Storage | ppt | Mar 17 | Chapter 11 |
Mar 14 | Project Statement | Mar 11 | ||
Mar 18 - Mar 24 | Page and Record Formats | ppt | Mar 18 | Chapter 12 |
Mar 25 - Apr 1 | Index Structures | ppt ppt | Mar 27 | Chapter 13, 14.3.1, 14.3.2 |
Apr 2 - Apr 8 | Query Processing | Overview; Example Plans | Apr 8 | Chapter 16.1, 16.3 |
Apr 4, FRIDAY | Mid Term | |||
Apr 10 - Apr 14 | Query Optimization | Size Estimation; Operator Algms; Clustered .vs. Unclustered index; | Apr 14 | Chapter 16.4, 15 (Except 15.9) |
Apr 17 - Apr 18 | Rewriting, Costing | Logical Plan Rewriting Cost-based Optimization | Apr 18 | Chapter 16.2, 16.5, 16.6, 16.7 |
Apr 21 - Apr 22 | Logging, Concurrency Control | ppt | Apr 21 | Chapters 17 |
Apr 22 - Apr 24 | Concurrency Control | ppt | Apr 24 | Chapters 18 |
Apr 24 - Apr 28 | Transaction Mgmt | ppt | Apr 25 | Chapter 19 |
Apr 29, TUESDAY | Final Exam |