Note that accessing many of these papers may require being logged into the VPN
| Week of: | Wednesday | Friday |
|---|---|---|
| Jan. 2/4 |
Introduction & class outline - what data do you have?
slides in PDF |
Introduction to databases: part 1
Optional reading (note: no need to turn in a review - the next one will be the one I will tell you what you would have gotten if I were grading, but will not actually grade) Lightly debugged slides for next two classes in PDF. Additional relational algebra slides Rachel presents and leads discussion |
| January 9/11 |
Introduction to databases: part 2
Rachel presents and leads discussion Additional Datalog slides |
Relational Roots(slides)
Rachel presents and leads discussion |
| January 16/18 | Query Optimization
Overview (Slides: System R and overview)
Homework due: design a database for your data Presentation: Sarah Discussion: Nick |
Two query
optimizers
(Slides: Volcano and Starburst)
Presentation: Nick Discussion: Sarah |
| January 23/25 |
Query Execution
Presentation: Felix Discussion: Haoran Project: one page project proposal due |
Transaction
Processing (slides)
Presentation: Rachel Discussion: Rachel |
| January 30/Feb 1 |
Answering Queries Using Views/Data
Integration (slides)
Presentation: Rachel Discussion: Rachel |
Rachel sick: class was cancelled |
| February 6/8 | Adaptive Execution
Presentation: Haoran Discussion: Rachel |
Rachel out of town: no class |
| February 13/15 |
Object-oriented and
Object-relational databases
Presentation: Winston Discussion: Ethan |
XML
Presentation: May Discussion: Lucas |
| February 20/22 | Reading week: no class | Feb 27/Mar 1 | 40 years of data models: what
goes around comes around(slides)
Presentation: Rachel Discussion: Rachel Project: 4 page midterm status report due |
On Line Analytic Processing (OLAP)
(Slides: OLAP, cubes)
Presentation: Rachel Discussion: May |
| March 6/8 |
Parallel Databases and No SQL
(Slides: Gamma, Map Reduce)
Presentation: Leo Discussion: Jimmy |
Critiquing No SQL
Presentation: Ethan (slides) Discussion: Winston |
| March 13/15 |
New-SQL
Presentation: Lucas Discussion: Felix |
Data Mining
(slides: Apriori, Hypdb)
Presentation: Jimmy Discussion: Leo |
| March 20/22 |
The Role of Theory
Presentation: Rachel Discussion: Rachel |
Advanced Topics/Student Request Potpourri: Auto-tuning and usability
Presentation: Rachel Discussion: Rachel |
| March 27/29 |
Future of DBMS research
Presentation: Rachel Discussion: Rachel |
Project Reports: Ethan Haoran Winston |
| April 3/5 |
Project Reports: Felix, Lucas, and Nick Jimmy and Leo May and Sarah |
Term is over: No class |
|
|
||
![rap [at] cs [dot] ubc [dot] ca](/~rap/address.jpg)