Reading Assignments

All reviews are due before the beginning of the lecture. There are no late days.

Please do not repost or otherwise distribute the materials available from this website. Some material is available freely on the web, other is behind a paywall, other is private and we only have permission to use the material in class, not distribute.

Due date: Wednesday, January 10.
A Case Against SQL:w/ csenetid, w/ uwnetid. Submit here.

Explain briefly three peculiar behaviors of SQL

Due date: Friday, January 19..
What goes around Submit here.

Read sections 1-5 and 10. The other sections are not recommended and we will not discuss them in class.

Some suggested topics for discussion in your review:
- What is physical and logical data independence?
- Briefly discuss physical and logical data independence in IMS, Codasyl, and the relational model.
- Speculate what led to the decline of IMS / Codasyl and rise of the relational model.

Due date: Wednesday, January 31.
How good are they? Submit here.

Read the entire paper. We will discuss most of it in class.

Due date: ~~Monday, March 4~~ Sunday, March 10.
Snowflake. Submit here.

Read sections 1,2,3, skim over 4, and read Sec. 6. Suggestions for topics to address in your review:
- What is elasticity, why is it important, and how is it supported in Snowflake?
- How is data storage handled in Snowflake, and why? What would have been the alternatives?
- How are worker failures handled in Snowflake?
- How does snowflake handle semistructure data?