TR 6:30-8:00
| Grade | Description |
|---|---|
| A (4 pts) | Clear mastery of the material |
| A- (3 pts) | Mastery of the material |
| B (2 pts) | Sufficient understanding of the material |
| C+ (1 pt) | Insufficient understanding of the material |
| F (0 pts) | No understanding of the material |
The final grade in the class will be assigned as follows:
| Grade | Requirements |
|---|---|
| A | At least 14 points |
| A- | At least 11 points and no exam worth 0 points |
| B | At least 7 points and no more than 1 exam worth 0 points |
| C+ | At least 3 points |
| F | Less than 3 points |
| Class | Reading | Topics | Note | Slides |
|---|---|---|---|---|
| 7/13 | Section 2.6 | Syllabus Relational Algebra |
In person | Relational Algebra |
| 7/14 | Section 15.3 | Selection operator | Synchronous online | Pages Selection |
| 7/15 | Section 15.5 | Joins (Block Loop and Merge) | In person | Nested Loop Merge Join |
| 7/16 | Sections 15.4, 15.6 | Sorting, Duplicate Elimination, Projection | Asynchronous Online | Sort Duplicate Elimination Projection |
| 7/17 | Section 15.6 | Group By, Having, Aggregates | Asynchronous Online | Group By(Sorting) Group By(Hashing) Having |
| 7/20 | Section 15.6 | Set Operations (Union, Intersection, Difference) | In person | Mutiset operations Set operations |
| 7/21 | Sections 14.3-14.5 | Indexes - B+-Tree and Hash | Synchronous Online | B+-Tree Hash Index |
| 7/22 | In person - Exam 1 | |||
| 7/23 | Section 16.2 | Equivalent Expressions | Asynchronous online | Equivalent Expressions |
| 7/24 | Chapter 16 | Query Optimization | Asynchronous online | Query Optimization |
| 7/27 | Section 3.9 | Updates | In person | Buffer Manager Updates |
| 7/28 | Sections 17.1-17.6 | Transactions and ACID | Synchronous Online | Transactions |
| 7/29 | In person - Exam 2 | |||
| 7/30 | Section 18.1 | Two-phase locking | Synchronous online | Serializability 2PL |
| 7/31 | Section 19.4 | Recovery | In person | Recovery |
| 8/3 | Section 23.2 | Two-phase commit | In person | 2PC |
| 8/4 | Sections 21.2-21.4 | Fragmentation and replication | Synchronous online | Fragmentation and Replication |
| 8/5 | In person - Exam 3 | |||
| 8/6 | Section 22.9 | Distributed Query Processing | Synchronous online | Distributed Queries |
| 8/7 | Section 23.3 | Distributed Transaction Processing | In person | Distributed Transactions |
| 8/10 | Chapter 10 | Big Data | In person | HDFS MapReduce |
| 8/11 | Synchronous online - Review | |||
| 8/12 | In person - Exam 4 | |||
| 8/13 | Synchronous online - Last day |
Final Exam to be held on August 12