Lectures: Tue: 14.00 to 15.00 (LIFS-LT3) Thu: 10.00 to 11.00 (SHER-LT1) Fri: 15.00 to 16.00 (SHER-LT1) Lab timetable: Mon: 12.00 - 13.00; 13.00 - 14.00 Tue: 10.00 - 11.00 Thu: 13.00 - 14.00; 15.00 - 16.00; 16.00 -17.00 Fri: 12.00 - 13.00; 13.00 - 14.00 Labs: One session per week in Lab 4, G. Holt Building, starting from week 3 (Week starting on October 10th).
Check your slot on Spider! Tutorials and labs: Tutorial 1 Tutorial 2 Tutorial 3 Tutorial 4 Tutorial 5 Assignments: Assignment 1 (Deadline 11/11/2011); Assignment 2 (Deadline 13/12/2011); Comp207-Tutorial1.htmlComp207-Tutorial2.htmlComp207-Tutorial3.htmlComp207-Tutorial4.htmlComp207-Tutorial5.htmlCOMP207-Assignment1.htmlCOMP207-Assignment2.htmlshapeimage_1_link_0shapeimage_1_link_1shapeimage_1_link_2shapeimage_1_link_3shapeimage_1_link_4shapeimage_1_link_5shapeimage_1_link_6

Learning resources

Lecture sets:

  1. •Lecture 1 (26/9/2011): Introduction

  2. •Lecture 2 (4/10/2011): Recap on last year

  3. •Lecture 3 (6/10/2011): Transaction management - 1

  4. •Lecture 4 (7/10/2011): Transaction management - 2

  5. •Lecture 5 (11/10/2011): Transaction management - 3

  6. •Lecture 6 (13/10/2011): Transaction management - 4

  7. •Lecture 7 (14/10/2011): Transaction management - 5

  8. •Lecture 8 (18/10/2011): Protocols for concurrency control -1

  9. •Lecture 9 (20/10/2011): Protocols for concurrency control -2

  10. •Lecture 10 (21/10/2011): Protocols for concurrency control -3

  11. •Lecture 11 (25/10/2011): Recoverability + Indexing mechanisms

  12. •Lecture 12 (27/10/2011): Indexing mechanisms + Query Processing

  13. •Lecture 13 (28/10/2011): Query Processing -1

  14. •Lecture 14 (1/11/2011): Query Processing -2

  15. •Lecture 15 (3/11/2011): Lecture postponed

  16. •Lecture 15 (4/11/2011): Query Optimisation -1

  17. •Lecture 16 (8/11/2011): Query Optimisation -2

  18. •Lecture 17 (10/11/2011): Query Optimisation - 3

  19. •Lecture 18 (11/11/2011): Query Optimisation - 4

  20. •Lecture 19 (15/11/2011): Distributed databases - 1

  21. •Lecture 20 (17/11/2011): Distributed databases - 2

  22. •Lecture 21 (18/11/2011): XML - 1

  23. •Lecture 22 (22/11/2011): XML - 2

  24. •Lecture 23 (24/11/2011): XML - 3

  25. •Lecture 24 (25/11/2011): XML - 4

  26. •Lecture 25 (29/11/2011): XPath

  27. •Lecture 26 (2/12/2011): Object relational DB -1

  28. •Lecture 27 (6/12/2011): Object relational DB - 2

  29. •Lecture 28 (8/12/2011): Data mining

  30. •Lecture 29 (9/12/2011): Data warehousing - Not exam material!

  31. •Lecture 30 (13/12/2011): Revision Lecture - 1

  32. •Lecture 31 (10/01/2011): Revision Lecture - 2 on VITAL


Class exercises with solutions:

Exercises presented on Fri 28/10

Tutorials with solutions:

Tutorial 1
Tutorial 2
Tutorial 3
Tutorial 4