Madhavan Mukund

Databases

August-December, 2010

Assignments

• Assignment 1: 16 August 2010, due 30 August, 2010.
  
  Load the relevant data for Assignment 1 from the dump file, available compressed in gzip and zip formats.
  • MySql dump of railways data, gzipped
  • MySql dump of railways data, zipped

• Assignment 2: 12 September 2010, due 20 September, 2010.
  
  Submit your solutions via Moodle.
• Assignment 3: 17 November 2010, due 26 November, 2010.
  
  Submit your solutions via Moodle.

Reading material

Distributed Databases

• Dale Skeen: Nonblocking Commit Protocols, ACM SIGMOD 1981, 133--142

• Edgar Knapp: Deadlock Detection in Distributed Databases, ACM Computing Surveys 19(4), 1987, 303-328

• Don P. Mitchell, Michael Merritt: A Distributed Algorithm for Deadlock Detection and Resolution, ACM PODC 1984, 282-284.

Semistructured data

• Notes on semistructured data.

Using MySQL

• How to load data from a MySql dump
• Online reference manual