Syllabus with Reading Assignments
and Lecture Notes
|
|
COP 5725 Database Systems
Syllabus with Reading Assignments and Lecture Notes |
| Lecture Notes and Reading Assignments | Homeworks | |||
|---|---|---|---|---|
| Week | Monday | Wednesday | Homeworks | Outside Reading |
| Section 1: Course Introduction and Skills Enhancement | ||||
| August 29 | Introduction to Course Chapter 1 Introductory Lecture Notes Riccardi's Annotation Lecture Notes |
Chapter 5:
SQL: Queries, Constraints, Triggers
SQL Slides |
Homework 1
Due Wednesday, September 7 , in class |
Elmasri and Navathe: Chapter 3
Date: Chapters 3, 4 and 9 |
| Section 2: Data Representation and Query Processing | ||||
| September 5 | No class, Labor Day Chapter 8: Overview of Storage and Indexing Chapter 9: Storing Data: Disks and Files Indexing and hashing slides //td> |
Chapter 10:
Tree-Based Indexes
Chapter 11: Hash-Based Indexes Homework 1 due in class |
Homework 2
Due Monday, September 12 |
Riccardi: Chapters 12 and 13
Elmasri and Navathe: Chapter 13 Date: Chapter 17 |
| September 12 |
Chapter 12:
Overview of Query Evaluation
Homework 2 due in class |
Chapter 13: External Sorting | Homework 3
Due Monday, September 19 |
|
| September 19 |
Chapter 14: Evaluation of Relational Operators
Chapter 14, Part A (Joins) Chapter 14, Part B (Other operators) Homework 3 due in class |
Chapter 15: A Typical Relational Query Optimizer | Homework 4
Due Monday, September 26 |
|
| September 26 |
Review and catchup of query evaluation and optimization
Homework 4 due in class |
Midterm Exam 1 | ||
| Section 3: Transactions, Concurrency Control and Recovery | ||||
| October 3 | Chapter 16: Transaction Management Overview | Chapter 17: Concurrency Control |
Homework 5
Due Monday, October 10 |
|
| October 10 |
Chapter 17:
Concurrency Control
Homework 5 due in class |
Chapter 18: Recovery | Homework 6
Due Monday, October 17 |
|
|
Section 4: Database Tuning and Security
Homework 6 due in class |
||||
| October 17 |
Chapter 20:
Physical Database Design
Homework 6 due in class |
Chapter 20: Physical Database Design | Homework 7
Due Monday, October 24 |
|
| October 24 |
Chapter 21:
Security and Authorization
Homework 7 due in class |
Chapter 21: Security and Authorization | Homework 8
Due Monday, October 31 |
|
| Section 4: Advanced Topics in Database Systems | ||||
| October 31 | Chapter 22, Sections 22.6-22.15: Distributed Database Systems |
Chapter 22, Sections 22.6-22.15:
Distributed Database Systems
Homework 8 due in class |
||
| November 7 | Midterm Exam 2, part A | Midterm Exam 2, part B | ||
| November 14 | Chapter 24: Deductive Databases | Chapter 24: Deductive Databases | ||
| November 21 | Chapter 25, Sections 1-7: Data Warehousing and Decision Support | Chapter 25, Sections 8-11: View Materialization and Maintenance | ||
| November 28 | Chapter 26: Data Mining | Chapter 26: Data Mining | ||
| December 5 | Catch Up | Semester Review | ||
| December 12 | Final Exam Thursday, December 15 3:30-5:00 pm |
|||