Lecture 4: Data Models and Data Normalization

Paper to review

1. Michael Stonebraker and Joseph Hellerstein. What Goes Around Comes Around. In “Readings in Database Systems” (aka the Red Book). 4th ed.

While reading this paper, try to focus on the following questions:

2. Alon Halevy: Query answering using views: a survey. Only Sections 1, 2, and 3 are mandatory. The remaining are optional. Main idea: all data models can be traslated to relational, and can be recovered by using views.

Lecture notes

Lecture04.pptx

Lecture04.pdf