CSE 344 Autumn 2013 Course Calendar

CSE 344 Autumn 2013
Course Calendar

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

September

Monday Tuesday Wednesday Thursday Friday

23 24 25
09:30-10:20 Lecture
RAI 121
1. Introduction
Slides

10:30-11:20 OH (Daseul)
CSE 218
26
Section
1. Intro to SQLite -- Daseul
Slides sql code

11:30-12:20 OH (Priya)
CSE 218
27
09:30-10:20 Lecture
RAI 121
2. Data Models (2.1-2.3)
Sqlite notes

10:30-11:20 OH (Dan Suciu)
CSE 662

14:30-15:20 OH (Joseph)
CSE 218

30
09:30-10:20 Lecture
RAI 121
3. SQL (6.1, 6.2)
Sqlite notes (Sqlite supplement)

11:30-12:20 OH (Priya)
CSE 218
01
10:30-11:20 OH (Daseul)
CSE 218
02
09:30-10:20 Lecture
RAI 121
4. SQL - Aggregates (6.3, 6.4)
Slides, Sqlite notes, data

10:30-11:20 OH (Daseul)
CSE 218
03
Section
2. More SQL -- Daseul
Worksheet Solution airport.csv population.csv gdp.csv

11:30-12:20 OH (Priya)
CSE 218

23:59 WQ1: SQL (basic)
04
09:30-10:20 Lecture
RAI 121
5. SQL - Aggregates (6.3, 6.4)
same materials from last lecture

10:30-11:20 OH (Dan Suciu)
CSE 662

14:30-15:20 OH (Joseph)
CSE 218

23:00 HW1: sqlite

October

Monday Tuesday Wednesday Thursday Friday

07
09:30-10:20 Lecture
RAI 121
6. Basic Query Evaluation, Indexes (14.1)
Slides

11:30-12:20 OH (Priya)
CSE 218

23:59 WQ2: SQL (aggregates)
08
10:30-11:20 OH (Daseul)
CSE 218
09
09:30-10:20 Lecture
RAI 121
7. SQL - Nested Queries (6.3)
Slides Sqlite notes, Additional notes

10:30-11:20 OH (Daseul)
CSE 218
10
Section
3. Subqueries -- Priya
Worksheet

11:30-12:20 OH (Priya)
CSE 218
11
09:30-10:20 Lecture
RAI 121
8. SQL Wrap-up and RDBMs Architecture (6.3, 2.4)
Slides

10:30-11:20 OH (Dan Suciu)
CSE 662

14:30-15:20 OH (Joseph)
CSE 218

23:00 HW2: Basic SQL
Solution -- create tables
Solution -- create indexes

14
09:30-10:20 Lecture
RAI 121
9. Relational Algebra (2.4, 5.1) -- guest Lecturer Sudeepa Roy
Slides

11:30-12:20 OH (Priya)
CSE 218

23:59 WQ3: SQL (nested)
15
10:30-11:20 OH (Daseul)
CSE 218
16
09:30-10:20 Lecture
RAI 121
10. Relational Algebra Wrapu and Architectures
Slides

10:30-11:20 OH (Daseul)
CSE 218
17
Section
4. SQL Azure -- Daseul
Slides

11:30-12:20 OH (Priya)
CSE 218
18
09:30-10:20 Lecture
RAI 121
11. Datalog (5.3, 5.4)
Slides

10:30-11:20 OH (Dan Suciu)
CSE 662

14:30-15:20 OH (Joseph)
CSE 218

21
09:30-10:20 Lecture
RAI 121
12. Relational Calculus (5.3, 5.4)
Slides, Query Language Primer

11:30-12:20 OH (Priya)
CSE 218
22
10:30-11:20 OH (Daseul)
CSE 218
23
09:30-10:20 Lecture
RAI 121
13. XML, XPath (11.1-11.3, 12.1)
Slides XML XML with DTD

10:30-11:20 OH (Daseul)
CSE 218
24
Section
5. RA, RC, Datalog -- Priya
Worksheet

11:30-12:20 OH (Priya)
CSE 218

23:59 WQ4: RA, RC, Datalog
25
09:30-10:20 Lecture
RAI 121
14. XPath and XQuery (12.1 - 12.2)
Slides

10:30-11:20 OH (Dan Suciu)
CSE 662

14:30-15:20 OH (Joseph)
CSE 218

23:00 HW3: Advanced SQL
Solution

28
09:30-10:20 Lecture
RAI 121
15. E/R Diagrams (4.1-4.6)
Slides

11:30-12:20 OH (Priya)
CSE 218
29
10:30-11:20 OH (Daseul)
CSE 218
30
09:30-10:20 Lecture
RAI 121
16. Constraints (7.1, 7.2, 7.4)
Slides

10:30-11:20 OH (Daseul)
CSE 218
31
Section
6. XML -- Joseph
Slides Worksheet code

11:30-12:20 OH (Priya)
CSE 218

23:59 WQ6: XML
01
09:30-10:20 Lecture
RAI 121
17. Design Theory (3.1-3.4)
Slides

10:30-11:20 OH (Dan Suciu)
CSE 662

14:30-15:20 OH (Joseph)
CSE 218

23:00 HW4: Relational Algebra/Calculus, Datalog
Solution

November

Monday Tuesday Wednesday Thursday Friday

04
09:30-10:20 Midterm exam

11:30-12:20 OH (Priya)
CSE 218
05
10:30-11:20 OH (Daseul)
CSE 218
06
09:30-10:20 Lecture
RAI 121
19. Midterm Discussion, Design Theory Wrap-up, Views
Slides

10:30-11:20 OH (Daseul)
CSE 218
07
Section
7. Conceptual Design -- Joseph
Slides Supplementary materials

11:30-12:20 OH (Priya)
CSE 218

23:59 WQ7: Conceptual Design
08
09:30-10:20 Lecture
RAI 121
20. Views (continue lecture from last week)

10:30-11:20 OH (Dan Suciu)
CSE 662

14:30-15:20 OH (Joseph)
CSE 218

23:00 HW5: XML
Solution

11
Veterans' Day
12
10:30-11:20 OH (Daseul)
CSE 218
13
09:30-10:20 Lecture
RAI 121
21. Transactions
Sqlite Notes

10:30-11:20 OH (Daseul)
CSE 218
14
Section
8. SQL in Java, Transactions -- Priya
Slides

11:30-12:20 OH (Priya)
CSE 218
15
09:30-10:20 Lecture
RAI 121
22. Transactions
Slides

10:30-11:20 OH (Dan Suciu)
CSE 662

14:30-15:20 OH (Joseph)
CSE 218

23:00 HW6: Conceptual Design
Solution

18
09:30-10:20 Lecture
RAI 121
23. Transactions
Slides

11:30-12:20 OH (Priya)
CSE 218

23:59 WQ8: Transactions
19
10:30-11:20 OH (Daseul)
CSE 218
20
09:30-10:20 Lecture
RAI 121
24. Parallel Databases
Slides

10:30-11:20 OH (Daseul)
CSE 218
21
Section
9. AWS, MapReduce -- Daseul
Slides

11:30-12:20 OH (Priya)
CSE 218
22
09:30-10:20 Lecture
RAI 121
25. Parallel Databases

10:30-11:20 OH (Dan Suciu)
CSE 662

14:30-15:20 OH (Joseph)
CSE 218

25
09:30-10:20 Lecture
RAI 121
26. Parallel Databases - MapReduce
Slides

11:30-12:20 OH (Priya)
CSE 218
26
10:30-11:20 OH (Daseul)
CSE 218
27
09:30-10:20 Lecture
RAI 121
27. Parallel Databases - MapReduce

10:30-11:20 OH (Daseul)
CSE 218

23:00 HW7: Application on a DB
Solution -- Query.java
Solution -- setup.sql
28
Thanksgiving
29
Day after Thanksgiving

December

Monday Tuesday Wednesday Thursday Friday

02
09:30-10:20 Lecture
RAI 121
28. Parallel Databases - MapReduce, PigLatin
Slides

11:30-12:20 OH (Priya)
CSE 218
03
10:30-11:20 OH (Daseul)
CSE 218
04
09:30-10:20 Lecture
RAI 121
29. Parallel Databases - Wrapup
Slides

10:30-11:20 OH (Daseul)
CSE 218
05
Section
10. Final Review -- Priya
Worksheet Solution

11:30-12:20 OH (Priya)
CSE 218
06
09:30-10:20 Lecture
RAI 121
30. Final Review
Slides

10:30-11:20 OH (Dan Suciu)
CSE 662

14:30-15:20 OH (Joseph)
CSE 218

23:00 HW8: Pig Latin No late days!

09 10 11
08:30-10:20 Final exam
12 13

September
Monday	Tuesday	Wednesday	Thursday	Friday
23	24	25 09:30-10:20 Lecture RAI 121 1. Introduction Slides 10:30-11:20 OH (Daseul) CSE 218	26 Section 1. Intro to SQLite -- Daseul Slides sql code 11:30-12:20 OH (Priya) CSE 218	27 09:30-10:20 Lecture RAI 121 2. Data Models (2.1-2.3) Sqlite notes 10:30-11:20 OH (Dan Suciu) CSE 662 14:30-15:20 OH (Joseph) CSE 218
30 09:30-10:20 Lecture RAI 121 3. SQL (6.1, 6.2) Sqlite notes (Sqlite supplement) 11:30-12:20 OH (Priya) CSE 218	01 10:30-11:20 OH (Daseul) CSE 218	02 09:30-10:20 Lecture RAI 121 4. SQL - Aggregates (6.3, 6.4) Slides, Sqlite notes, data 10:30-11:20 OH (Daseul) CSE 218	03 Section 2. More SQL -- Daseul Worksheet Solution airport.csv population.csv gdp.csv 11:30-12:20 OH (Priya) CSE 218 23:59 WQ1: SQL (basic)	04 09:30-10:20 Lecture RAI 121 5. SQL - Aggregates (6.3, 6.4) same materials from last lecture 10:30-11:20 OH (Dan Suciu) CSE 662 14:30-15:20 OH (Joseph) CSE 218 23:00 HW1: sqlite

October
Monday	Tuesday	Wednesday	Thursday	Friday
07 09:30-10:20 Lecture RAI 121 6. Basic Query Evaluation, Indexes (14.1) Slides 11:30-12:20 OH (Priya) CSE 218 23:59 WQ2: SQL (aggregates)	08 10:30-11:20 OH (Daseul) CSE 218	09 09:30-10:20 Lecture RAI 121 7. SQL - Nested Queries (6.3) Slides Sqlite notes, Additional notes 10:30-11:20 OH (Daseul) CSE 218	10 Section 3. Subqueries -- Priya Worksheet 11:30-12:20 OH (Priya) CSE 218	11 09:30-10:20 Lecture RAI 121 8. SQL Wrap-up and RDBMs Architecture (6.3, 2.4) Slides 10:30-11:20 OH (Dan Suciu) CSE 662 14:30-15:20 OH (Joseph) CSE 218 23:00 HW2: Basic SQL Solution -- create tables Solution -- create indexes
14 09:30-10:20 Lecture RAI 121 9. Relational Algebra (2.4, 5.1) -- guest Lecturer Sudeepa Roy Slides 11:30-12:20 OH (Priya) CSE 218 23:59 WQ3: SQL (nested)	15 10:30-11:20 OH (Daseul) CSE 218	16 09:30-10:20 Lecture RAI 121 10. Relational Algebra Wrapu and Architectures Slides 10:30-11:20 OH (Daseul) CSE 218	17 Section 4. SQL Azure -- Daseul Slides 11:30-12:20 OH (Priya) CSE 218	18 09:30-10:20 Lecture RAI 121 11. Datalog (5.3, 5.4) Slides 10:30-11:20 OH (Dan Suciu) CSE 662 14:30-15:20 OH (Joseph) CSE 218
21 09:30-10:20 Lecture RAI 121 12. Relational Calculus (5.3, 5.4) Slides, Query Language Primer 11:30-12:20 OH (Priya) CSE 218	22 10:30-11:20 OH (Daseul) CSE 218	23 09:30-10:20 Lecture RAI 121 13. XML, XPath (11.1-11.3, 12.1) Slides XML XML with DTD 10:30-11:20 OH (Daseul) CSE 218	24 Section 5. RA, RC, Datalog -- Priya Worksheet 11:30-12:20 OH (Priya) CSE 218 23:59 WQ4: RA, RC, Datalog	25 09:30-10:20 Lecture RAI 121 14. XPath and XQuery (12.1 - 12.2) Slides 10:30-11:20 OH (Dan Suciu) CSE 662 14:30-15:20 OH (Joseph) CSE 218 23:00 HW3: Advanced SQL Solution
28 09:30-10:20 Lecture RAI 121 15. E/R Diagrams (4.1-4.6) Slides 11:30-12:20 OH (Priya) CSE 218	29 10:30-11:20 OH (Daseul) CSE 218	30 09:30-10:20 Lecture RAI 121 16. Constraints (7.1, 7.2, 7.4) Slides 10:30-11:20 OH (Daseul) CSE 218	31 Section 6. XML -- Joseph Slides Worksheet code 11:30-12:20 OH (Priya) CSE 218 23:59 WQ6: XML	01 09:30-10:20 Lecture RAI 121 17. Design Theory (3.1-3.4) Slides 10:30-11:20 OH (Dan Suciu) CSE 662 14:30-15:20 OH (Joseph) CSE 218 23:00 HW4: Relational Algebra/Calculus, Datalog Solution

November
Monday	Tuesday	Wednesday	Thursday	Friday
04 09:30-10:20 Midterm exam 11:30-12:20 OH (Priya) CSE 218	05 10:30-11:20 OH (Daseul) CSE 218	06 09:30-10:20 Lecture RAI 121 19. Midterm Discussion, Design Theory Wrap-up, Views Slides 10:30-11:20 OH (Daseul) CSE 218	07 Section 7. Conceptual Design -- Joseph Slides Supplementary materials 11:30-12:20 OH (Priya) CSE 218 23:59 WQ7: Conceptual Design	08 09:30-10:20 Lecture RAI 121 20. Views (continue lecture from last week) 10:30-11:20 OH (Dan Suciu) CSE 662 14:30-15:20 OH (Joseph) CSE 218 23:00 HW5: XML Solution
11 Veterans' Day	12 10:30-11:20 OH (Daseul) CSE 218	13 09:30-10:20 Lecture RAI 121 21. Transactions Sqlite Notes 10:30-11:20 OH (Daseul) CSE 218	14 Section 8. SQL in Java, Transactions -- Priya Slides 11:30-12:20 OH (Priya) CSE 218	15 09:30-10:20 Lecture RAI 121 22. Transactions Slides 10:30-11:20 OH (Dan Suciu) CSE 662 14:30-15:20 OH (Joseph) CSE 218 23:00 HW6: Conceptual Design Solution
18 09:30-10:20 Lecture RAI 121 23. Transactions Slides 11:30-12:20 OH (Priya) CSE 218 23:59 WQ8: Transactions	19 10:30-11:20 OH (Daseul) CSE 218	20 09:30-10:20 Lecture RAI 121 24. Parallel Databases Slides 10:30-11:20 OH (Daseul) CSE 218	21 Section 9. AWS, MapReduce -- Daseul Slides 11:30-12:20 OH (Priya) CSE 218	22 09:30-10:20 Lecture RAI 121 25. Parallel Databases 10:30-11:20 OH (Dan Suciu) CSE 662 14:30-15:20 OH (Joseph) CSE 218
25 09:30-10:20 Lecture RAI 121 26. Parallel Databases - MapReduce Slides 11:30-12:20 OH (Priya) CSE 218	26 10:30-11:20 OH (Daseul) CSE 218	27 09:30-10:20 Lecture RAI 121 27. Parallel Databases - MapReduce 10:30-11:20 OH (Daseul) CSE 218 23:00 HW7: Application on a DB Solution -- Query.java Solution -- setup.sql	28 Thanksgiving	29 Day after Thanksgiving

December
Monday	Tuesday	Wednesday	Thursday	Friday
02 09:30-10:20 Lecture RAI 121 28. Parallel Databases - MapReduce, PigLatin Slides 11:30-12:20 OH (Priya) CSE 218	03 10:30-11:20 OH (Daseul) CSE 218	04 09:30-10:20 Lecture RAI 121 29. Parallel Databases - Wrapup Slides 10:30-11:20 OH (Daseul) CSE 218	05 Section 10. Final Review -- Priya Worksheet Solution 11:30-12:20 OH (Priya) CSE 218	06 09:30-10:20 Lecture RAI 121 30. Final Review Slides 10:30-11:20 OH (Dan Suciu) CSE 662 14:30-15:20 OH (Joseph) CSE 218 23:00 HW8: Pig Latin No late days!
09	10	11 08:30-10:20 Final exam	12	13