06-02525 Databases 2

Alan Sexton 10 credits in Semester 1

menu

Aims

Learning Outcomes

On completion of this module, the student should be able to:

Prerequisites and Corequisites

06-02381 Databases 1 (or equivalent)

Teaching Methods

2 hours per week throughout the semester. Conventional lectures

Assessment

2 hr examination (80%), continuously assessed problem assignments (20%)

Recommended Books

Title Author(s) Publisher Comments
Database Management Systems,
2nd or 3rd Edition
Raghu Ramakrishnan and Johannes Gehrke

McGraw Hill 2000

(3rd Ed. is 2003)

ISBN: 0-07-116898-2
(3rd Ed. is 0-07-246563-8 or
0-07-115110-9 (International Student Ed.)
)
Required text. The main part of this course is based directly on this text. Its coverage of implementation technology is very good without becoming buried under a mass of detail. It also includes a number of chapters on some advanced topics.
Transaction Processing: Concepts and Techniques Jim Gray and Andreas Reuter Morgan Kaufmann 1993 This tome gives all the detail of the lower third of a DBMS architecture. It is required reading for anyone serious about implementing a DBMS but goes far beyond what is necessary for this course. Nonetheless, it is very readable and may provide an insight into many issues left open by Ramakrishnan's book
Database System Implementation H. Garcia-Molina, J. Ullman and J. Widom Prentice Hall 2000 This book is entirely about implementation technology and goes into more depth than Ramakrishnan.

Detailed Syllabus

  1. DBMS Architecture
  2. Buffering
  3. Indexing
  4. Algorithms for Relational Operators
  5. Query Execution
  6. Query Optimisation
  7. Transactions

A number of advanced topics in databases will be presented. The choice of topics will vary from year to year but is likely to include some topics from:

Seminars on some topics may be given by guest lecturers who are researchers working in those areas.

Relevant Links


menu

Degree Regulations Aims Outcomes Prerequisites Teaching Methods Assessment Recommended Books Detailed Syllabus Relevant Links

Maintained by: Alan Sexton, School of Computer Science, The University of Birmingham
Last update: 7 October 2003