CSE 414 Spring 2013
Course Calendar

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

 Show color key

April
MondayTuesdayWednesdayThursdayFriday
01
13:30-14:20 Lecture
MGH 231
1. Introduction
Slides
02
18:30 webquiz 1 out
20:00 hw1 out
03
13:30-14:20 Lecture
MGH 231
2. Data Models (2.1-2.3)
Sqlite notes
04
Section
1. Intro to SQLite
Slides Worksheet sql code
05
13:30-14:20 Lecture
MGH 231
3. SQL (6.1, 6.2)
Sqlite notes (Sqlite supplement)
23:00 webquiz 1 due SUNDAY evening
08
13:30-14:20 Lecture
MGH 231
4. SQL - Aggregates (6.3, 6.4)
Slides Sqlite notes (data)
09
13:30 webquiz 2 out
16:30-17:30 OH (jx)
CSE 218
10
13:30-14:20 Lecture
MGH 231
5. SQL - Aggregates (6.3, 6.4)
16:30-17:30 OH (jx)
CSE 218
23:00 hw1 due (sqlite)
11
Section
2. More SQL
Slides Worksheet Solution airport.csv gdb.csv population.csv
09:00 hw2 out
12
13:30-14:20 Lecture
MGH 231
6. Basic Query Evaluation, Indexes (14.1)
Slides
16:30-17:30 OH (dl)
CSE 218
23:00 webquiz 2 due (Friday, not Sunday)
15
13:30-14:20 Lecture
MGH 231
7. Indexes
16:30-17:30 OH (hp)
CSE 548
16
16:30-17:30 OH (jx)
CSE 218
19:00 webquiz 3 out
17
13:30-14:20 Lecture
MGH 231
8. SQL - Nested Queries (6.3)
Slides Sqlite notes Additional sql notes
15:00 hw3 out
16:30-17:30 OH (jx)
CSE 218
23:00 hw2 due(basic SQL)
18
Section
3. SQL Azure
Slides, Worksheet, Solutions
19
13:30-14:20 Lecture
MGH 231
9. SQL Wrap-up (6.3, 2.4)
Slides
16:30-17:30 OH (dl)
CSE 218
23:00 webquiz 3 due
22
13:30-14:20 Lecture
MGH 231
10. DBMS Architecture; Relational Algebra (2.4, 5.1)
Slides
16:30-17:30 OH (hp)
CSE 548
23
16:30-17:30 OH (jx)
CSE 218
24
12:00 webquiz 4 out
13:30-14:20 Lecture
MGH 231
11. Relational Algebra (2.4, 5.1, 5.2)
16:30-17:30 OH (jx)
CSE 218
23:00 hw3 due (Advanced SQL)
25
Section
4. Relational algebra and query plans
Slides, Worksheet, Solutions
26
13:00 hw4 out
13:30-14:20 Lecture
MGH 231
12. Relational Algebra (concl.) (2.4, 5.1, 5.2)
16:30-17:30 OH (dl)
CSE 218
23:00 webquiz 4 due
29
13:30-14:20 Lecture
MGH 231
13. Query Implementation (15.2-15.6)
Slides
16:30-17:30 OH (hp)
CSE 548
30
16:30-17:30 OH (jx)
CSE 218
01
13:30-14:20 Lecture
MGH 231
14. Query Implementation (concl.) (15.2-15.6)
16:30-17:30 OH (jx)
CSE 218
23:00 hw4 due (relational algebra)
02
Section
5. Midterm review
Slides
03
13:30-14:20 Lecture
MGH 231
15. XML, XPath (11.1-11.3, 12.1)
Slides sample-xml.xml sample-xml-with-dtd.xml
16:30-17:30 OH (dl)
CSE 218

May
MondayTuesdayWednesdayThursdayFriday
06
13:30-14:20 Midterm exam (Review SUNDAY 2pm, LOW 101)
16:30-17:30 OH (hp)
CSE 548
07
16:30-17:30 OH (jx)
CSE 218
08
12:00 webquiz 5 out
13:00 hw5 out
13:30-14:20 Lecture
MGH 231
16. XPath and XQuery (12.1-12.2)
Slides
16:30-17:30 OH (jx)
CSE 218
09
Section
6. XML
Slides, Worksheet, Solutions
10
13:30-14:20 Lecture
MGH 231
16. XQuery (concl.)
16:30-17:30 OH (dl)
CSE 218
23:00 webquiz 5 due
13
13:30-14:20 Lecture
MGH 231
17. E/R Diagrams (4.1-4.6)
Slides
16:30-17:30 OH (hp)
CSE 548
14
16:30-17:30 OH (jx)
CSE 218
15
12:00 webquiz 6 out
13:00 hw6 out
13:30-14:20 Lecture
MGH 231
18. Constraints (7.1-7.2, 7.4)
Slides
16:30-17:30 OH (jx)
CSE 218
23:00 hw5 due (XML)
16
Section
7. Database design
Slides
17
13:30-14:20 Lecture
MGH 231
20. Design Theory (3.1-3.4)
Friday 5/17 lecture is in MEB 103
Slides
16:30-17:30 OH (dl)
CSE 218
20
0:01 webquiz 6 due SUNDAY 5/19 11 pm
13:30-14:20 Lecture
MGH 231
21. Views (8.1), 22. Intro to Transactions (6.6, 17.1.3-17.1.4)
Slides transactions.txt
16:30-17:30 OH (hp)
CSE 548
21
16:30-17:30 OH (jx)
CSE 218
22
13:30-14:20 Lecture
MGH 231
23. Transactions (18.1-18.3)
Slides
15:00 hw7 out
16:30-17:30 OH (jx)
CSE 218
23:00 hw6 due (conceptual design)
23
Section
8. Database application programming
Slides
24
13:30-14:20 Lecture
MGH 231
24. Transactions and locks (18.1-18.3)
25. Parallel Databases
Slides: Locks Parallel db
16:30-17:30 OH (dl)
CSE 218
18:00 webquiz 7 out
27
Memorial Day
28
16:30-17:30 OH (jx)
CSE 218
29
13:30-14:20 Lecture
MGH 231
26. Parallel database queries
Slides
15:00 hw8 out
16:30-17:30 OH (jx)
CSE 218
23:00 hw7 due (DB application)
30
Section
9. Hadoop / Pig Latin
Slides
31
13:30-14:20 Lecture
MGH 231
27. Parallel Databases - Map Reduce & Pig Latin (ch. 2 secs. 1-3 of Ullman MMDS)
Slides
16:30-17:30 OH (dl)
CSE 218
23:00 webquiz 7 due

June
MondayTuesdayWednesdayThursdayFriday
03
13:30-14:20 Lecture
MGH 231
28. Parallel Databases - wrapup
Slides
16:30-17:30 OH (hp)
CSE 548
04
16:30-17:30 OH (jx)
CSE 218
05
13:30-14:20 Lecture
MGH 231
29. nosql / data integration
Slides: nosql
data integration
16:30-17:30 OH (jx)
CSE 218
06
Section
10. Wrapup and review
Slides
07
13:30-14:20 Lecture
MGH 231
30. Course Wrapup
Slides
16:30-17:30 OH (dl)
CSE 218
23:00 hw8 due (Pig Latin) No late days
10
14:30-16:20 Final exam (Review SUNDAY 2 pm, LOW 101)
11 12 13 14