Module 02525 (2004)
Syllabus page 2004/2005
06-02525
Databases 2
Level 3/H
Links | Outline | Aims | Outcomes | Prerequisites | Teaching | Assessment | Books | Detailed Syllabus
The Module Description is a strict subset of this Syllabus Page. (The University module description has not yet been checked against the School's.)
Relevant Links
Outline
The module begins with a large section on database implementation technology. Some of this is covered in lectures, some by directed reading. The technology covered is then applied to problems of performance tuning and physical data design. Finally a section on how relational databases fit in large scale web applications is presented.
Aims
The aims of this module are to:
- Present the key concepts and algorithms in relational database management system implementation technology.
- Introduce issues of and techniques for physical database design and performance tuning.
- Introduce modern database-backed web application architectures.
Learning Outcomes
| On successful completion of this module, the student should be able to: | Assessed by: | |
| 1 | Explain the architectural components and major algorithms in a relational database management system. | Examination and problem assignments |
| 2 | Apply implementation technology understanding to solve physical database design and performance tuning problems. | Examination and problem assignments |
| 3 | Describe and discuss modern approaches to scalable database-backed web applications. | Examination |
Restrictions, Prerequisites and Corequisites
Restrictions:
None
Prerequisites:
06-02381 (Databases 1)
Co-requisites:
None
Teaching
Teaching Methods:
2 lectures per week during term plus revision lectures. Conventional lectures and tutorial sheets.
Contact Hours:
Assessment
- Supplementary (where allowed): As the sessional assessment
- The continuous assessment consists of problem assignments.
Recommended Books
| Title | Author(s) | Publisher, Date |
| Database Management Systems (2nd ed.) | R Ramakrishnan & J Gehrke | McGraw Hill, 2000 |
| Database System Implementation | Hector Garcia-Molina, Jeffrey D. Ullman & Jennifer Widom | Prentice Hall, 2000 |
| Transaction Processing | Jim Gray & Andreas Reuter | Morgan Kaufman, 1993 |
Detailed Syllabus
-
RDBMS implementation technology
- RDBMS Architecture
- Buffering
- Indexing
- Algorithms for Relational Operators
- Query Execution
- Query Optimisation
- Transactions
- Physical database design and performance tuning
- Web Database Applications
Last updated: 2 July 2003
Source file: /internal/modules/COMSCI/2004/xml/02525.xml
Links | Outline | Aims | Outcomes | Prerequisites | Teaching | Assessment | Books | Detailed Syllabus