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 Aug 31 - Sep 4 |
L01 Introduction L02 ER Model |
No discussions | |
|
Week 2 Sep 7 - 11 |
L03 ER Model (cntd.) L04 Relational Model |
Project 1 Intro & ER Diagrams |
Sep 8: Project1 out; HW1 out
|
|
Week 3 Sep 14 - 18 |
L05 ER to Relational L06 Relational Algebra |
SQL | |
|
Week 4 Sep 21 - 25 |
L07 SQL L08 SQL (cntd.) |
Relational Algebra, Java |
Sep 22 Tue: HW1 due; HW2 out; Project1 due; Project2 out
|
|
Week 5 Sep 28 - Oct 2 |
L09 DB App Programming L10 Normalization |
More SQL, JDBC; Project 2 Intro | |
|
Week 6 Oct 5 - 9 |
L11 Normalization (cntd.) L12 No SQL databases |
Normalization |
Oct 8 Thu: Project2 due; HW2 due
|
|
Week 7 Oct 12 - 16 |
Midterm
Tue Oct 13, 7pm
|
No lab |
|
|
Week 8 Oct 19 - 23 |
No lecture - Fall Break No lecture |
No lab | |
|
Week 9 Oct 26 - 30 |
L13 Storage/Indexing L14 Tree-structured index |
Indexing |
Oct 27: Project3 out; HW3 out
|
|
Week 10 Nov 2 - 6 |
L15 Hash-based indexing L16 External Sort |
NoSQL, MapReduce; Hash Indexes, Project 3 Intro | |
|
Week 11 Nov 9 - 13 |
L17 Query Evaluation: Selection L18 Query Evaluation: Joins |
Sorting |
Nov 10: HW3 due; HW4 out
Nov 10: Project3 due; Projec4 out
|
|
Week 12 Nov 16 - 20 |
L19 Query Evaluation: Other Ops L20 Query Optimization |
Joins, Grace Hash Join, Project 4 intro | |
|
Week 13 Nov 23 - 27 |
L21 Transaction Management Overview L22 Concurrency Control |
Transactions |
Nov 26: HW4 due; HW5 out
|
|
Week 14 Nov 30 - Dec 4 |
L23 Concurrency Control (cntd.) L24 Logging and Recovery |
Logging and Recovery |
Dec 3: Project4 due
|
|
Week 15 Dec 7 - 11 |
No Lecture No Lecture |
Final Exam - Review |
Mnd Jun 2: HW5 due
|
| Exam Week |
Final Tue
Dec 15, 7pm |
Reach us at eecs484staff@umich.edu
jag@umich.edu
almomani@umich.edu