Course pages 2012–13

Databases

Lecture Slides:

• Lectures 1-8, 10
  • One-slide per page: db_2013.pdf
  • Two-slides per page: db_2013_2up.pdf (large file)
• Lecture 9: Guest lecture. Grant Allen (Google). Slides avialable later in term.
• Lectures 11, 12: Beyond the ACID/Relational model.
  • One-slide per page: db2013_L11_L12.pdf
  • Two-slides per page: db2013_L11_L12_2up.pdf (large file)

Some open source database systems :

• Postgres : http://www.postgresql.org/
• MySQL : http://www.mysql.com/
• SQLite : http://www.sqlite.org/

iMDB data:

• Raw iMDb data files
• Handy Python package for manipulating iMDB raw data http://imdbpy.sourceforge.net/

Of interest:

• Guest lecture from Lent 2012 on schema migration in the NHS cancer database.
• Dr. Jean Bacon asks What is a key?

Primary sources:

• Tarkski's 1941 paper "On the Calculus of Relations".
• A short biography of Alfred Tarski http://en.wikipedia.org/wiki/Alfred_Tarski.
• Codd's original 1970 paper describing the relational model (reprinted here in 1983).
• A short biography of Edgar Codd http://en.wikipedia.org/wiki/Edgar_F._Codd.
• Chen's original 1976 paper on Enitity-Relationship models.
• A short biography of Peter Chen http://en.wikipedia.org/wiki/Peter_Chen.
• Fagin's definition of multivalued dependencies.

Counter Culture :

• NoSQL Movement : http://en.wikipedia.org/wiki/NoSQL_(concept)
• Berkeley DB : http://en.wikipedia.org/wiki/Berkeley_DB
• Graph Databases : http://en.wikipedia.org/wiki/Graph_database

But never forget to ask What problem am I solving?