Lecture
An introduction to database management systems, with emphasis on relational databases, query processing, database design, transactions, concurrency control, and large-scale data management. Syllabus
| Day | Lecture | Lab | Deadline |
|---|---|---|---|
|
Week 1 May 4 - 5 |
L01 Introduction |
No discussions | |
|
Week 2 May 6 - 7 |
L02 ER Model L03 ER Model (cntd.) |
Project 1 Intro & ER Diagrams |
May 6: Project1 out; HW1 out
|
|
Week 3 May 11 - 12 |
L04 Relational Model L05 ER to Relational |
SQL | |
|
Week 4 May 13 - 14 |
L06 Relational Algebra L07 SQL |
Relational Algebra, Java |
May 13 Wed: HW1 due; HW2 out
May 14 Thu: Project1 due; Project2 out
|
|
Week 5 May 18 - 19 |
L08 SQL (cntd.) L09 DB App Programming |
More SQL, JDBC; Project 2 Intro | |
|
Week 6 May 20 - 21 |
L10 Normalization L11 Normalization (cntd.) |
Normalization | |
|
Week 7 May 25 - 26 |
Memorial Day (holiday) L12 No SQL databases |
Midterm review |
May 26 Tue: Project2 due; HW2 due
|
|
Week 8 May 27 - 28 |
No lecture |
No lab |
Midterm
Thu May 28, 5pm
|
|
Week 9 Jun 1 - 2 |
L13 Storage/Indexing L14 Tree-structured index |
Indexing |
Jun 1: Project3 out; HW3 out
|
|
Week 10 Jun 3 - 4 |
L15 Hash-based indexing L16 External Sort |
NoSQL, MapReduce; Hash Indexes, Project 3 Intro |
Jun 3 Wend: HW3 due; HW4 out
|
|
Week 11 Jun 8 - 9 |
L17 Query Evaluation: Selection L18 Query Evaluation: Joins |
Sorting |
Jun 7 Mnd: Project3 due; Projec4 out
|
|
Week 12 Jun 10 - 11 |
L19 Query Evaluation: Other Ops L20 Query Optimization |
Joins, Grace Hash Join, Project 4 intro |
Wend Jun 10: HW4 due; HW5 out
|
|
Week 13 Jun 15 - 16 |
L21 Transaction Management Overview L22 Concurrency Control |
Transactions | |
|
Week 14 Jun 17 - 18 |
L23 Concurrency Control (cntd.) L24 Logging and Recovery |
Logging and Recovery |
Tue Jun 18: Project4 due
|
|
Week 15 Jun 22 - 23 |
Final Exam Review |
Final Exam - Review | |
| Exam Week |
Final Thu
June 25, 8am |
Reach us at eecs484staff@umich.edu
almomani@umich.edu
chnyilin@umich.edu