CSE 344 Winter 2013 Course Calendar

CSE 344 Winter 2013
Course Calendar

Subscribe to this calendar (google, iCal, etc.)

January

Monday Tuesday Wednesday Thursday Friday

07
09:30-10:20 Lecture
JHN 075
1. Introduction
Slides

13:30-14:20 OH (Dan Suciu)
CSE 662

15:00-15:50 OH (Tom Lehmann)
CSE 216
08
12:30-13:20 OH (Brendan Lee)
CSE 216

14:30-15:20 OH (Lee Lee Choo)
CSE 216
09
09:30-10:20 Lecture
JHN 075
2. Data Models (2.1-2.3)
Sqlite notes

12:30-13:20 OH (Vaspol Ruamviboonsuk)
CSE 216

15:00-15:50 OH (Tom Lehmann)
CSE 216
10
Section
1. Intro to SQLite
Slides

12:30-13:20 OH (Lee Lee Choo)
CSE 216

13:30-14:20 OH (Vaspol Ruamviboonsuk)
CSE 216
11
09:30-10:20 Lecture
JHN 075
3. SQL (6.1, 6.2)
Sqlite notes (Sqlite supplement)

12:30-13:20 OH (Brendan Lee)
CSE 216

13:30-14:20 OH (Dan Suciu)
CSE 662

23:59 WQ1: SQL (basic)

14
09:30-10:20 Lecture
JHN 075
4. SQL - Aggregates (6.3, 6.4)
Slides, Sqlite notes, data

13:30-14:20 OH (Dan Suciu)
CSE 662

15:00-15:50 OH (Tom Lehmann)
CSE 216
15
12:30-13:20 OH (Brendan Lee)
CSE 216

14:30-15:20 OH (Lee Lee Choo)
CSE 216
16
09:30-10:20 Lecture
JHN 075
5. SQL - Aggregates (6.3, 6.4)

12:30-13:20 OH (Vaspol Ruamviboonsuk)
CSE 216

15:00-15:50 OH (Tom Lehmann)
CSE 216

23:59 HW1: sqlite3
17
Section
2. More SQL
Worksheet

12:30-13:20 OH (Lee Lee Choo)
CSE 216

13:30-14:20 OH (Vaspol Ruamviboonsuk)
CSE 216
18
09:30-10:20 Lecture
JHN 075
6. Basic Query Evaluation, Indexes (14.1)
Slides

12:30-13:20 OH (Brendan Lee)
CSE 216

23:59 WQ2: SQL (aggregates)

21
Martin Luther King Day
22
12:30-13:20 OH (Brendan Lee)
CSE 216

14:30-15:20 OH (Lee Lee Choo)
CSE 216
23
09:30-10:20 Lecture
JHN 075
8. SQL - Nested Queries (6.3) (guest lecturer: Paris Koutris)
Slides Sqlite notes, Additional notes

12:30-13:20 OH (Vaspol Ruamviboonsuk)
CSE 216

15:00-15:50 OH (Tom Lehmann)
CSE 216

23:59 HW2: Basic SQL
24
Section
3. SQL Azure
Slides Worksheet

12:30-13:20 OH (Lee Lee Choo)
CSE 216

13:30-14:20 OH (Vaspol Ruamviboonsuk)
CSE 216
25
09:30-10:20 Lecture
JHN 075
9. SQL Wrap-up and RDBMs Architecture (6.3, 2.4)
Slides

12:30-13:20 OH (Brendan Lee)
CSE 216

13:30-14:20 OH (Dan Suciu)
CSE 662

28
09:30-10:20 Lecture
JHN 075
10. Relational Algebra (2.4, 5.1)
Slides

13:30-14:20 OH (Dan Suciu)
CSE 662

15:00-15:50 OH (Tom Lehmann)
CSE 216

23:59 WQ3: SQL (nested)
29
12:30-13:20 OH (Brendan Lee)
CSE 216

14:30-15:20 OH (Lee Lee Choo)
CSE 216
30
09:30-10:20 Lecture
JHN 075
11. Relational Algebra and Query Evaluation (2.4, 5.1)

12:30-13:20 OH (Vaspol Ruamviboonsuk)
CSE 216

15:00-15:50 OH (Tom Lehmann)
CSE 216
31
Section
4. Suqueries
Worksheet

12:30-13:20 OH (Lee Lee Choo)
CSE 216

13:30-14:20 OH (Vaspol Ruamviboonsuk)
CSE 216
01
09:30-10:20 Lecture
JHN 075
12. Datalog (5.3, 5.4)
Slides

12:30-13:20 OH (Brendan Lee)
CSE 216

13:30-14:20 OH (Dan Suciu)
CSE 662

February

Monday Tuesday Wednesday Thursday Friday

04
09:30-10:20 Lecture
JHN 075
13. Relational Calculus (5.3, 5.4)
Slides, Query Language Primer

13:30-14:20 OH (Dan Suciu)
CSE 662

15:00-15:50 OH (Tom Lehmann)
CSE 216

23:59 WQ4: RA, RC, Datalog
05
12:30-13:20 OH (Brendan Lee)
CSE 216

14:30-15:20 OH (Lee Lee Choo)
CSE 216
06
09:30-10:20 Lecture
JHN 075
14. XML, XPath (11.1-11.3, 12.1)
Slides XML XML with DTD

12:30-13:20 OH (Vaspol Ruamviboonsuk)
CSE 216

15:00-15:50 OH (Tom Lehmann)
CSE 216

23:59 HW3: Advanced SQL
07
Section
5. RA, RC, Datalog
Worksheet

12:30-13:20 OH (Lee Lee Choo)
CSE 216

13:30-14:20 OH (Vaspol Ruamviboonsuk)
CSE 216
08
09:30-10:20 Midterm exam

12:30-13:20 OH (Brendan Lee)
CSE 216

13:30-14:20 OH (Dan Suciu)
CSE 662

11
09:30-10:20 Lecture
JHN 075
16. XPath and XQuery (12.1 - 12.2)
Slides

13:30-14:20 OH (Dan Suciu)
CSE 662

15:00-15:50 OH (Tom Lehmann)
CSE 216
12
12:30-13:20 OH (Brendan Lee)
CSE 216

14:30-15:20 OH (Lee Lee Choo)
CSE 216
13
09:30-10:20 Lecture
JHN 075
17. E/R Diagrams (4.1-4.6)
Slides

12:30-13:20 OH (Vaspol Ruamviboonsuk)
CSE 216

15:00-15:50 OH (Tom Lehmann)
CSE 216

23:59 HW4: Relational Algebra/Calculus, Datalog
14
Section
6. XML
Worksheet

12:30-13:20 OH (Lee Lee Choo)
CSE 216

13:30-14:20 OH (Vaspol Ruamviboonsuk)
CSE 216
15
09:30-10:20 Lecture
JHN 075
18. Constraints (7.1, 7.2, 7.4)
Slides

12:30-13:20 OH (Brendan Lee)
CSE 216

13:30-14:20 OH (Dan Suciu)
CSE 662

23:59 WQ6: XML

18
Presidents Day
19
12:30-13:20 OH (Brendan Lee)
CSE 216

14:30-15:20 OH (Lee Lee Choo)
CSE 216
20
09:30-10:20 Lecture
JHN 075
20. Design Theory (3.1-3.4)
Slides

12:30-13:20 OH (Vaspol Ruamviboonsuk)
CSE 216

15:00-15:50 OH (Tom Lehmann)
CSE 216

23:59 HW5: XML
21
Section
7. Conceptual Design
Solution

12:30-13:20 OH (Lee Lee Choo)
CSE 216

13:30-14:20 OH (Vaspol Ruamviboonsuk)
CSE 216
22
09:30-10:20 Lecture
JHN 075
21. Views
Slides

12:30-13:20 OH (Brendan Lee)
CSE 216

13:30-14:20 OH (Dan Suciu)
CSE 662

25
09:30-10:20 Lecture
JHN 075
22. Transactions
Slides

13:30-14:20 OH (Dan Suciu)
CSE 662

15:00-15:50 OH (Tom Lehmann)
CSE 216

23:59 WQ7: Conceptual Design
26
12:30-13:20 OH (Brendan Lee)
CSE 216

14:30-15:20 OH (Lee Lee Choo)
CSE 216
27
09:30-10:20 Lecture
JHN 075
23. Transactions
Slides

12:30-13:20 OH (Vaspol Ruamviboonsuk)
CSE 216

15:00-15:50 OH (Tom Lehmann)
CSE 216

23:59 HW6: Conceptual Design
28
Section
8. SQL in Java, Transactions
Solution

12:30-13:20 OH (Lee Lee Choo)
CSE 216

13:30-14:20 OH (Vaspol Ruamviboonsuk)
CSE 216
01
09:30-10:20 Lecture
JHN 075
24. Transactions
Slides

12:30-13:20 OH (Brendan Lee)
CSE 216

13:30-14:20 OH (Dan Suciu)
CSE 662

March

Monday Tuesday Wednesday Thursday Friday

04
09:30-10:20 Lecture
JHN 075
25. Parallel Databases
Slides

13:30-14:20 OH (Dan Suciu)
CSE 662

15:00-15:50 OH (Tom Lehmann)
CSE 216

23:59 WQ8: Transactions
05
12:30-13:20 OH (Brendan Lee)
CSE 216

14:30-15:20 OH (Lee Lee Choo)
CSE 216
06
09:30-10:20 Lecture
JHN 075
26. Parallel Databases - MapReduce
Slides

12:30-13:20 OH (Vaspol Ruamviboonsuk)
CSE 216

15:00-15:50 OH (Tom Lehmann)
CSE 216

23:59 HW7: Application on a DB
07
Section
9. AWS, MapReduce
Solution

12:30-13:20 OH (Lee Lee Choo)
CSE 216

13:30-14:20 OH (Vaspol Ruamviboonsuk)
CSE 216
08
09:30-10:20 Lecture
JHN 075
27. Parallel Databases - Pig Latin
Slides

12:30-13:20 OH (Brendan Lee)
CSE 216

13:30-14:20 OH (Dan Suciu)
CSE 662

11
09:30-10:20 Lecture
JHN 075
28. Parallel Databases - Wrap Up
Slides

13:30-14:20 OH (Dan Suciu)
CSE 662

15:00-15:50 OH (Tom Lehmann)
CSE 216
12
12:30-13:20 OH (Brendan Lee)
CSE 216

14:30-15:20 OH (Lee Lee Choo)
CSE 216
13
09:30-10:20 Lecture
JHN 075
29. Parallel Databases - Wrap Up
Slides

12:30-13:20 OH (Vaspol Ruamviboonsuk)
CSE 216

15:00-15:50 OH (Tom Lehmann)
CSE 216
14
Section
10. Final Review
Solution

12:30-13:20 OH (Lee Lee Choo)
CSE 216

13:30-14:20 OH (Vaspol Ruamviboonsuk)
CSE 216
15
09:30-10:20 Lecture
JHN 075
30. Final Review
Slides

12:30-13:20 OH (Brendan Lee)
CSE 216

13:30-14:20 OH (Dan Suciu)
CSE 662

23:59 HW8: Pig Latin No late days!

18 19 20
08:30-10:20 Final exam
21 22

January
Monday	Tuesday	Wednesday	Thursday	Friday
07 09:30-10:20 Lecture JHN 075 1. Introduction Slides 13:30-14:20 OH (Dan Suciu) CSE 662 15:00-15:50 OH (Tom Lehmann) CSE 216	08 12:30-13:20 OH (Brendan Lee) CSE 216 14:30-15:20 OH (Lee Lee Choo) CSE 216	09 09:30-10:20 Lecture JHN 075 2. Data Models (2.1-2.3) Sqlite notes 12:30-13:20 OH (Vaspol Ruamviboonsuk) CSE 216 15:00-15:50 OH (Tom Lehmann) CSE 216	10 Section 1. Intro to SQLite Slides 12:30-13:20 OH (Lee Lee Choo) CSE 216 13:30-14:20 OH (Vaspol Ruamviboonsuk) CSE 216	11 09:30-10:20 Lecture JHN 075 3. SQL (6.1, 6.2) Sqlite notes (Sqlite supplement) 12:30-13:20 OH (Brendan Lee) CSE 216 13:30-14:20 OH (Dan Suciu) CSE 662 23:59 WQ1: SQL (basic)
14 09:30-10:20 Lecture JHN 075 4. SQL - Aggregates (6.3, 6.4) Slides, Sqlite notes, data 13:30-14:20 OH (Dan Suciu) CSE 662 15:00-15:50 OH (Tom Lehmann) CSE 216	15 12:30-13:20 OH (Brendan Lee) CSE 216 14:30-15:20 OH (Lee Lee Choo) CSE 216	16 09:30-10:20 Lecture JHN 075 5. SQL - Aggregates (6.3, 6.4) 12:30-13:20 OH (Vaspol Ruamviboonsuk) CSE 216 15:00-15:50 OH (Tom Lehmann) CSE 216 23:59 HW1: sqlite3	17 Section 2. More SQL Worksheet 12:30-13:20 OH (Lee Lee Choo) CSE 216 13:30-14:20 OH (Vaspol Ruamviboonsuk) CSE 216	18 09:30-10:20 Lecture JHN 075 6. Basic Query Evaluation, Indexes (14.1) Slides 12:30-13:20 OH (Brendan Lee) CSE 216 23:59 WQ2: SQL (aggregates)
21 Martin Luther King Day	22 12:30-13:20 OH (Brendan Lee) CSE 216 14:30-15:20 OH (Lee Lee Choo) CSE 216	23 09:30-10:20 Lecture JHN 075 8. SQL - Nested Queries (6.3) (guest lecturer: Paris Koutris) Slides Sqlite notes, Additional notes 12:30-13:20 OH (Vaspol Ruamviboonsuk) CSE 216 15:00-15:50 OH (Tom Lehmann) CSE 216 23:59 HW2: Basic SQL	24 Section 3. SQL Azure Slides Worksheet 12:30-13:20 OH (Lee Lee Choo) CSE 216 13:30-14:20 OH (Vaspol Ruamviboonsuk) CSE 216	25 09:30-10:20 Lecture JHN 075 9. SQL Wrap-up and RDBMs Architecture (6.3, 2.4) Slides 12:30-13:20 OH (Brendan Lee) CSE 216 13:30-14:20 OH (Dan Suciu) CSE 662
28 09:30-10:20 Lecture JHN 075 10. Relational Algebra (2.4, 5.1) Slides 13:30-14:20 OH (Dan Suciu) CSE 662 15:00-15:50 OH (Tom Lehmann) CSE 216 23:59 WQ3: SQL (nested)	29 12:30-13:20 OH (Brendan Lee) CSE 216 14:30-15:20 OH (Lee Lee Choo) CSE 216	30 09:30-10:20 Lecture JHN 075 11. Relational Algebra and Query Evaluation (2.4, 5.1) 12:30-13:20 OH (Vaspol Ruamviboonsuk) CSE 216 15:00-15:50 OH (Tom Lehmann) CSE 216	31 Section 4. Suqueries Worksheet 12:30-13:20 OH (Lee Lee Choo) CSE 216 13:30-14:20 OH (Vaspol Ruamviboonsuk) CSE 216	01 09:30-10:20 Lecture JHN 075 12. Datalog (5.3, 5.4) Slides 12:30-13:20 OH (Brendan Lee) CSE 216 13:30-14:20 OH (Dan Suciu) CSE 662

February
Monday	Tuesday	Wednesday	Thursday	Friday
04 09:30-10:20 Lecture JHN 075 13. Relational Calculus (5.3, 5.4) Slides, Query Language Primer 13:30-14:20 OH (Dan Suciu) CSE 662 15:00-15:50 OH (Tom Lehmann) CSE 216 23:59 WQ4: RA, RC, Datalog	05 12:30-13:20 OH (Brendan Lee) CSE 216 14:30-15:20 OH (Lee Lee Choo) CSE 216	06 09:30-10:20 Lecture JHN 075 14. XML, XPath (11.1-11.3, 12.1) Slides XML XML with DTD 12:30-13:20 OH (Vaspol Ruamviboonsuk) CSE 216 15:00-15:50 OH (Tom Lehmann) CSE 216 23:59 HW3: Advanced SQL	07 Section 5. RA, RC, Datalog Worksheet 12:30-13:20 OH (Lee Lee Choo) CSE 216 13:30-14:20 OH (Vaspol Ruamviboonsuk) CSE 216	08 09:30-10:20 Midterm exam 12:30-13:20 OH (Brendan Lee) CSE 216 13:30-14:20 OH (Dan Suciu) CSE 662
11 09:30-10:20 Lecture JHN 075 16. XPath and XQuery (12.1 - 12.2) Slides 13:30-14:20 OH (Dan Suciu) CSE 662 15:00-15:50 OH (Tom Lehmann) CSE 216	12 12:30-13:20 OH (Brendan Lee) CSE 216 14:30-15:20 OH (Lee Lee Choo) CSE 216	13 09:30-10:20 Lecture JHN 075 17. E/R Diagrams (4.1-4.6) Slides 12:30-13:20 OH (Vaspol Ruamviboonsuk) CSE 216 15:00-15:50 OH (Tom Lehmann) CSE 216 23:59 HW4: Relational Algebra/Calculus, Datalog	14 Section 6. XML Worksheet 12:30-13:20 OH (Lee Lee Choo) CSE 216 13:30-14:20 OH (Vaspol Ruamviboonsuk) CSE 216	15 09:30-10:20 Lecture JHN 075 18. Constraints (7.1, 7.2, 7.4) Slides 12:30-13:20 OH (Brendan Lee) CSE 216 13:30-14:20 OH (Dan Suciu) CSE 662 23:59 WQ6: XML
18 Presidents Day	19 12:30-13:20 OH (Brendan Lee) CSE 216 14:30-15:20 OH (Lee Lee Choo) CSE 216	20 09:30-10:20 Lecture JHN 075 20. Design Theory (3.1-3.4) Slides 12:30-13:20 OH (Vaspol Ruamviboonsuk) CSE 216 15:00-15:50 OH (Tom Lehmann) CSE 216 23:59 HW5: XML	21 Section 7. Conceptual Design Solution 12:30-13:20 OH (Lee Lee Choo) CSE 216 13:30-14:20 OH (Vaspol Ruamviboonsuk) CSE 216	22 09:30-10:20 Lecture JHN 075 21. Views Slides 12:30-13:20 OH (Brendan Lee) CSE 216 13:30-14:20 OH (Dan Suciu) CSE 662
25 09:30-10:20 Lecture JHN 075 22. Transactions Slides 13:30-14:20 OH (Dan Suciu) CSE 662 15:00-15:50 OH (Tom Lehmann) CSE 216 23:59 WQ7: Conceptual Design	26 12:30-13:20 OH (Brendan Lee) CSE 216 14:30-15:20 OH (Lee Lee Choo) CSE 216	27 09:30-10:20 Lecture JHN 075 23. Transactions Slides 12:30-13:20 OH (Vaspol Ruamviboonsuk) CSE 216 15:00-15:50 OH (Tom Lehmann) CSE 216 23:59 HW6: Conceptual Design	28 Section 8. SQL in Java, Transactions Solution 12:30-13:20 OH (Lee Lee Choo) CSE 216 13:30-14:20 OH (Vaspol Ruamviboonsuk) CSE 216	01 09:30-10:20 Lecture JHN 075 24. Transactions Slides 12:30-13:20 OH (Brendan Lee) CSE 216 13:30-14:20 OH (Dan Suciu) CSE 662

March
Monday	Tuesday	Wednesday	Thursday	Friday
04 09:30-10:20 Lecture JHN 075 25. Parallel Databases Slides 13:30-14:20 OH (Dan Suciu) CSE 662 15:00-15:50 OH (Tom Lehmann) CSE 216 23:59 WQ8: Transactions	05 12:30-13:20 OH (Brendan Lee) CSE 216 14:30-15:20 OH (Lee Lee Choo) CSE 216	06 09:30-10:20 Lecture JHN 075 26. Parallel Databases - MapReduce Slides 12:30-13:20 OH (Vaspol Ruamviboonsuk) CSE 216 15:00-15:50 OH (Tom Lehmann) CSE 216 23:59 HW7: Application on a DB	07 Section 9. AWS, MapReduce Solution 12:30-13:20 OH (Lee Lee Choo) CSE 216 13:30-14:20 OH (Vaspol Ruamviboonsuk) CSE 216	08 09:30-10:20 Lecture JHN 075 27. Parallel Databases - Pig Latin Slides 12:30-13:20 OH (Brendan Lee) CSE 216 13:30-14:20 OH (Dan Suciu) CSE 662
11 09:30-10:20 Lecture JHN 075 28. Parallel Databases - Wrap Up Slides 13:30-14:20 OH (Dan Suciu) CSE 662 15:00-15:50 OH (Tom Lehmann) CSE 216	12 12:30-13:20 OH (Brendan Lee) CSE 216 14:30-15:20 OH (Lee Lee Choo) CSE 216	13 09:30-10:20 Lecture JHN 075 29. Parallel Databases - Wrap Up Slides 12:30-13:20 OH (Vaspol Ruamviboonsuk) CSE 216 15:00-15:50 OH (Tom Lehmann) CSE 216	14 Section 10. Final Review Solution 12:30-13:20 OH (Lee Lee Choo) CSE 216 13:30-14:20 OH (Vaspol Ruamviboonsuk) CSE 216	15 09:30-10:20 Lecture JHN 075 30. Final Review Slides 12:30-13:20 OH (Brendan Lee) CSE 216 13:30-14:20 OH (Dan Suciu) CSE 662 23:59 HW8: Pig Latin No late days!
18	19	20 08:30-10:20 Final exam	21	22