COMP3062: Advanced Databases
(4 points) Group C
Second semester
Twenty lectures (1 hr), six tutorial/laboratory
sessions (2 hr)
Prerequisites:
Either INFS2051 or INFS3055; 16cp of 2000-series COMP
or INFS units including COMP2030 or
COMP2038;
and 8cp of 2000-series mathematics or mathematical statistics units.
Syllabus:
This unit involves the study of concepts underlying object-oriented
database technology and related research issues.
It covers the threefold functions of object-oriented database
systems: semantic data modelling, object identity and operational
semantics. The concept of persistent objects in object-oriented
programming languages will be discussed as well as object control
concepts and physical object-base design. The state-of-the-art
object-oriented database management systems are studied in relation to
these aspects. The unit includes practical experience of such
systems.
The following topics
are addressed:
- semantic data modelling,
- extended relational database systems,
- object-oriented database systems,
- object-oriented programming languages,
- object control concepts and physical object-base design.
- object relational database systems.
Textbooks and References
There is a required textbook in this course:
- Michael Stonebraker and Paul Brown with Dorothy Moore:
``Object-Relational DBMSs'' (second edition),
The Morgan Kaufmann Series in Data management Systems,
Jim Gray, Series Editor, Morgan Kaufmann, ISBN: 1-55860-452-9, 1998
You need to purchase
- ``The Readings for Advanced Databases
(COMP3062)'' which includes some chapters from the reference
book ``Object-Oriented Database Management: Applications in
Engineering and Computer Science'' and chapters from ONTOS DB 3.1
documents.
The reference books are:
- A. Kemper and G. Morekotte:
``Object-Oriented Database Management: Applications in Engineering
and Computer Science'', Prentice Hall, 1994.
- Setrag Khoshafian: ``Object-Oriented Databases'',
John Willey, 1993.
- Bjarne Stroustrup: ``The C++ Progarmming Language,'' Third
Edition, Addison-Wesley, 1997.
Lectures and Laboratories
The course has twenty lectures and six laboratories in total. The
following table shows you the lecture and laboratory arrangement.
| Week No. |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
| Lectures |
3 |
3 |
3 |
3 |
3 |
3 |
- |
- |
- |
- |
- |
- |
- |
| Laboratories |
|
|
|
1 |
|
1 |
1 |
|
1 |
1 |
1 |
|
|
The are three time slots for lectures. The times and places of these slots
are as follows:
- Monday 11:00-12:00, ENGN T.
- Wednesday 11:00-12:00, CHEM T1.
- Thursday 11:00-12:00, ENGN T.
In the first six weeks, 18 lectures will be given. The time for the
remaining two lectures will be announced later on.
Assessment
- The assignments take 50% of the assessment with the following
details:
- The three-hour final examination takes the remaining 50% of the
assessment.
Past papers: 1997 [Postscript][PDF], 1998 [Postscript][PDF]
- You have to pass or be very close to pass the two
assignments.
- As a departmental rule, no one can pass the course if
his or her score of final examination is substantially below 40 points
(out of 100 points).
Lecture Notes
Read teach.comp3062 for the latest notices!
Handouts
- General Information (Postscript,PDF)
- Laboratory-1, week 4: C++ (Postscript,PDF)
- Laboratory-2, week 6: C++ and ONTOS (Postscript,PDF) - Task 15 solution (badly formatted)
- Laboratory-3, week 7: ONTOS(2) (Postscript,PDF)
- Laboratory-4, week 9: ONTOS(3) (Postscript,PDF)
- Laboratory-5, week 10: ONTOS(4) (Postscript,PDF)
- Laboratory-6, week 11: ONTOS(5) (Postscript,PDF)
Last Modified: October 26, 1999