E-mail Address:
![rap [at] cs [dot] ubc [dot] ca](/~rap/address.jpg)
Office Location: CICSR 345
Phone: (604)822-0436
Fax:(604)822-5485
Postal/Courier address:
The Department of Computer Science
University of British Columbia
201-2366 Main Mall
Vancouver, B.C. V6T 1Z4
Canada
| Week of: | Monday | Wednesday |
|---|---|---|
| September 7/9 | Labour day: no class |
Introduction & class outline - what data do you have?
slides in PDF Rachel presents and leads discussion |
| September 14/16 | 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) Preliminary slides for next two classes in PDF Rachel presents and leads discussion Homework 1 handed out: design a database for your data |
Introduction to databases: part 2
Rachel presents and leads discussion |
| September 21/23 | 40 years of data models: what
goes around comes around(slides)
Rachel presents and leads discussion Homework 1 due |
Relational Roots (slides)
Presentation: Fong Discussion: Noreen and Dibesh |
| September 28/30 | Query Optimization
Overview (Slides: System R and overview)
Presentation: Lin for overview, Peyman for System R Discussion: Wenhao |
Rachel out of town: no class |
| October 5/7 |
Two query
optimizers
(Slides: Volcano and Starburst)
Presentation: Charles and Nima Discussion: Lin Project: two page project proposal due |
Query Execution (slides)
Presentation: Long Discussion: Andrew and Val |
| October 12/14 | Thanksgiving Day: no class |
Transaction
Processing (slides)
Presentation: Dibesh Discussion: Alex |
| October 19/21 |
Answering Queries Using Views/Data
Integration (slides)
Presentation: Tianyu Discussion: Sapna and Kendric |
Adaptive Execution
(Slides: Tukwila, Eddies )
Presentation: Noreen Discussion: Long |
| October 26/28 |
Object-oriented and
Object-relational databases (Slides: Turmoil and Object Store)
Presentation: Sapna and Roland Discussion: Fong and Shervin |
Rachel sick: no class | November 2/4 |
XML (Slides: Querying XML, indexing XML)
Presentation: Alex and James Discussion: Cody and Roland Project: 4 page midterm status report due |
On Line Analytic Processing (OLAP)
(Slides: OLAP, cubes)
Presentation: Sophia and Andrew Discussion: Tianyu and James |
| November 9/11 |
Data Mining
(Slides: Apriori, BIRCH)
Presentation: Wenhao for Apriori, Kendric for BIRCH Discussion: Sophia |
Remembrance Day: no class |
| November 16/18 |
The Role of Theory
(slides)
Presentation: Val and Shervin Discussion: Shriram |
Advanced Topics/Student Request Potpourri: Distributed Databases (slides)
Presentation: Cody Discussion: Charles |
| November 23/25 |
Advanced Topics/Student Request Potpourri: Streaming data (slides)
Presentation: Shriram Discussion: Peyman and Nima |
Project Reports:
Fong and Kendric Peyman Cody and Shriram Roland |
| November 30/December 2 |
Project Reports: Val Noreen Dibesh Andrew, Charles, and Tianyu Lin and Wenhao |
Project Reports:
Nima and Shervin James Sapna Alex Long and Sophia |
|
|
||