The presentation will be over a paper in either the 2007 SIGMOD conference or the 2007 PODS conference. These two conferences are held at the same time, and are generally considered the best conferences on database research. I will make an example presentation over the paper "Data Currency in Replicated DBTs" by Akbarinia, Pacitti and Valduriez. Presentations will be 20 minutes and will be scheduled according to the syllabus. There will be two presentations per class. Papers will be granted on a "first-come first-serve" basis. Students will be randomly selected for each presentation date.
| Student | Paper | Slides | |
|---|---|---|---|
| 1. | Flaming, Christopher Jeff | Genome-scale disk-based suffix tree indexing | Genome-scale Suffix Trees |
| 2. | Homan, Christopher B | Design of flash-based DBMS: an in-page logging approach | Flash Database |
| 3. | Kallina, Deborah Anne | Effective keyword-based selection of relational databases | Keyword Searches |
| 4. | Roberts, Nathan Vanderkooy | Map-reduce-merge: simplified relational data processing on large clusters | Map-Reduce-Merge |
| 5. | Shrestha, Sweta | Threats to privacy in the forensic analysis of database systems | Forensic Slides |
| 6. | Sun, Wuliang | Schema Advisor for Hybrid Relational-XML DBMSM | Hybrid XML RDBMS |
| 7. | Thapa, Vidhi | Privacy preserving schema and data matching | Privacy |
| 8. | Yin, Bing | Compiling mappings to bridge applications and databases | Mapping apps to DBs |
| Time | Topics | Reading | Assignments | Notes |
|---|---|---|---|---|
| Week 1 | Transactions | Chapter 15 | ||
| Week 2 | Concurrency Control | Chapter 16 | ||
| Week 3 | Recovery | Chapter 17 | ||
| Week 4 | Distributed Databases | Chapter 22 | Read Chapter 20 on your own These slides may help. | |
| Week 5 | Advanced Transaction Processing | Chapter 25 Slides | ||
| Week 6 | Normalization Theory | Chapter 7 | ||
| Week 7 | Advanced Normalization Theory | Simple Conditions for Guaranteeing Higher Normal Forms in Relational Databases | ||
| Week 8 | File Storage | Chapter 11 | MID TERM EXAM Oct. 9 2007 |
|
| Week 9 | Reed-Solomon Codes Relational Algebra |
Online Handout Chapter 2 |
||
| Week 10 | Indexing and Hashing | Chapter 12 | ||
| Week 11 | Query Processing | Chapter 13 | PROJECT DUE October 30 | |
| Week 12 | Query Optimization | Chapter 14 | PAPER SELECTION DEADLINE | Example Presentation Slides (when available) |
| Week 13 | Advanced Database Development | Chapters 23 & 24 TPC Benchmarks | ||
| Week 14 | Student Presentations Tue: Alex Yin, Peter Sun, Nate Roberts | Thanksgiving - Tuesday class only | ||
| Week 15 | Student Presentations Tue:Chris Flaming, Chris Homan, Sweta Shrestha Thr. , Vidhi Thapa, Deborah Kallina | |||
| Final Exam | Thursday, December 6, 2007 2:00-4:00 |