CSE 344 Winter 2016
Course Calendar

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

 Show color key

January
SundayMondayTuesdayWednesdayThursdayFridaySaturday
03 04
13:30-14:20 Laurel Or
CSE 218
14:30-15:20 Lecture
MUE 153
1. Introduction
Slides large and small
05
14:30-15:20 Yiwei Pi
CSE 220
06
14:30-15:20 Lecture
MUE 153
2. Data Models (2.1-2.3)
SQL queries
15:30-16:20 Dan Suciu
CSE 662
07
Section
SQLite Basics
Slides and SQL Queries
11:30-12:20 Yiwei Pi
CSE 218
08
13:30-14:20 Jay Garlapati
CSE 218
14:30-15:20 Lecture
MUE 153
3. SQL Basics (6.1, 6.2)
SQL queries
09
10
23:00 WQ1 due: sql (basic)
11
13:30-14:20 Laurel Or
CSE 218
14:30-15:20 Lecture
MUE 153
4. SQL Aggregates (6.3, 6.4)
Slides large Slides small SQL queries Data
12
14:30-15:20 Yiwei Pi
CSE 220
23:00 HW1 due: sqlite
13
14:30-15:20 Lecture
MUE 153
5. More SQL Aggregates (6.3, 6.4)
Slides large Slides small SQL queries Data
15:30-16:20 Dan Suciu
CSE 662
14
Section
More SQL
Slides Problems Solution Data
11:30-12:20 Yiwei Pi
CSE 218
15
13:30-14:20 Jay Garlapati
CSE 218
14:30-15:20 Lecture
MUE 153
6. SQL Subqueries (6.3)
Slides large Slides small
16
17
23:00 WQ2 due: sql (aggregates)
18
Martin Luther King Day
19
14:30-15:20 Yiwei Pi
CSE 220
23:00 HW2 due: Basic SQL
20
14:30-15:20 Lecture
MUE 153
7. SQL Wrapup
Slides large Slides small
15:30-16:20 Dan Suciu
CSE 662
21
Section
Microsoft Azure
Slides
11:30-12:20 Yiwei Pi
CSE 218
22
13:30-14:20 Jay Garlapati
CSE 218
14:30-15:20 Lecture
MUE 153
8. Relational Algebra
Slides large Slides small
23
24
23:00 WQ3 due: sql (nested)
25
13:30-14:20 Laurel Or
CSE 218
14:30-15:20 Lecture
MUE 153
9. Relational Algebra (cont) and Query Evaluation (guest lecturer)
Slides large Slides small SQL queries
26
14:30-15:20 Yiwei Pi
CSE 220
27
14:30-15:20 Lecture
MUE 153
10. Basics of Data Storage and Indexing (14.1)
Slides large Slides small
15:30-16:20 Dan Suciu
CSE 662
28
Section
Relational algebra
Slides Problems Solutions
11:30-12:20 Yiwei Pi
CSE 218
29
13:30-14:20 Jay Garlapati
CSE 218
14:30-15:20 Lecture
MUE 153
11. Basics of Query Optimization and Query Cost Estimation
Slides large Slides small
30
31 01
13:30-14:20 Laurel Or
CSE 218
14:30-15:20 Lecture
MUE 153
12. Relational calculus
Slides large Slides small
02
14:30-15:20 Yiwei Pi
CSE 220
23:00 HW3 due: Advanced SQL
03
14:30-15:20 Lecture
MUE 153
13. Datalog (guest lecturer)
Slides large Slides small
04
Section
Datalog
Slides Problems Solutions
11:30-12:20 Yiwei Pi
CSE 218
05
13:30-14:20 Jay Garlapati
CSE 218
14:30-15:20 Lecture
MUE 153
Midterm Review (guest lecturer)
06
23:00 WQ4 due: RA, RC, Datalog

February
SundayMondayTuesdayWednesdayThursdayFridaySaturday
07 08
13:30-14:20 Laurel Or
CSE 218
14:30-15:20 Midterm
09
14:30-15:20 Yiwei Pi
CSE 220
10
14:30-15:20 Lecture
MUE 153
15. Data Formats and Semistructured Data
Slides large Slides small
15:30-16:20 Dan Suciu
CSE 662
23:00 HW4 due: Relational Algebra / Calculus & Datalog
11
Section
JSON
11:30-12:20 Yiwei Pi
CSE 218
12
13:30-14:20 Jay Garlapati
CSE 218
14:30-15:20 Lecture
MUE 153
16. NoSQL
Slides large Slides small
13
14 15
Presidents Day
16
14:30-15:20 Yiwei Pi
CSE 220
17
14:30-15:20 Lecture
MUE 153
17. E/R Diagrams & Constraints (Reading: 12.1-12.2, 4.1-4.6, 7.1, 7.2, 7.4)
Slides large Slides small
15:30-16:20 Dan Suciu
CSE 662
18
Section
N1QL
N1QL Queries Data
11:30-12:20 Yiwei Pi
CSE 218
19
13:30-14:20 Jay Garlapati
CSE 218
14:30-15:20 Lecture
MUE 153
18. Design theory (Reading: 3.1-3.4)
Slides large Slides small
23:00 HW5 due: JSON/NoSQL/CouchDB
20
21 22
13:30-14:20 Laurel Or
CSE 218
14:30-15:20 Lecture
MUE 153
19. Design theory continued
23
14:30-15:20 Yiwei Pi
CSE 220
24
14:30-15:20 Lecture
MUE 153
20. Intro to transactions (Reading: 18.1)
Slides large Slides small Sqlite demo
15:30-16:20 Dan Suciu
CSE 662
23:00 WQ6 due: Conceptual Design
25
Section
BCNF and Functional Dependencies
Slides
11:30-12:20 Yiwei Pi
CSE 218
26
13:30-14:20 Jay Garlapati
CSE 218
14:30-15:20 Lecture
MUE 153
21. More transactions (Reading: 18.1-3)
Slides large Slides small
23:00 HW6 due: Conceptual Design
27
28 29
13:30-14:20 Laurel Or
CSE 218
14:30-15:20 Lecture
MUE 153
22. Transaction implementations (Reading: 18.3)
Slides large Slides small
01
14:30-15:20 Yiwei Pi
CSE 220
02
14:30-15:20 Lecture
MUE 153
23. Parallel databases (Reading: 20-20.1.3)
Slides large Slides small
15:30-16:20 Dan Suciu
CSE 662
23:00 WQ7 due: Transactions
03
Section
Transactions
Slides
11:30-12:20 Yiwei Pi
CSE 218
04
13:30-14:20 Jay Garlapati
CSE 218
14:30-15:20 Lecture
MUE 153
24. Parallel databases (continued)
05

March
SundayMondayTuesdayWednesdayThursdayFridaySaturday
06 07
13:30-14:20 Laurel Or
CSE 218
14:30-15:20 Lecture
MUE 153
25. MapReduce
Slides large Slides small
23:00 HW7 due: DB Application
08
14:30-15:20 Yiwei Pi
CSE 220
09
14:30-15:20 Lecture
MUE 153
26. Spark
Slides large Slides small
15:30-16:20 Dan Suciu
CSE 662
10
Section
AWS and Spark
11:30-12:20 Yiwei Pi
CSE 218
11
13:30-14:20 Jay Garlapati
CSE 218
14:30-15:20 Lecture
MUE 153
27. Final Review
12
13
23:00 HW8 due: Distributed Query Processing
14 15
14:30-16:20 Final exam
16 17 18 19