|
Module Titles |
|
|
Actual: |
Advanced Database |
|
Administrative: |
Advanced Database (BSc) L6 |
|
Module Information |
|
It is of Level 6 ,Size 1
and is worth 10 Credit Points. |
|
Module Ownership |
|
The Module Tutor is Akhtar
Ali |
Synopsis of Module:
A brief overview of aims, contents, methods and assessment
The module builds on the students understanding
of relational databases and extends it with formal as well
as practical concepts nested-/object-relational models and how these extensions are implemented in a
modern DBMS (e.g. Oracle). The students will also be introduced to object
orientation in databases through the ODMG standard and a compliant DBMS. The
module introduces the underlying concepts of Query Processing and Optimization.
The module is delivered by means of lectures and seminar/practical
sessions, and is assessed a 3 hour open-book examination. Open-book means that
you can take with you into the examination, any lecture notes, handouts and
text books that you like, and use them to help you in the exam. The exam will assess
the students understanding of the principles, techniques, and skills learnt and
obtained in lectures and practical seminars. In addition, the students would be
expected to explain and discuss comparative and critical analysis of the
techniques and concepts introduced in the module.
Prerequisite(s):
Any Module which must already have been taken at a lower level, or any stipulated level of prior
knowledge required.
CM503 - Data Structures, Algorithms and Database programming
or
other adequate module at level 4 / 5.
Aims of Module:
Learning Outcomes:
Specified in terms of performance capability to be shown on completion of the Module.
On completion of this module, the student should be able to:
Ø Critically assess the limitations of relational databases;
Ø Assess different ways of extending the relational model (i.e. in terms of
nested/object-relational extensions);
Ø Explain, discuss, and evaluate Object-Oriented databases;
Ø Compare and contrast the relational data model with object-relational and
object-oriented data models;
Ø Critically evaluate query optimisation techniques and compare alternative
ways of storing data in order to improve the performance of a database system;
Outline Syllabus:
The content of the Module, identified in a component listing.
Relational Algebra
Programming
Extensions to SQL (15%)
- PLSQL
- Triggers
Extending the Relational Data Model (25 %)
- Nested-Relational data model
- Object-Relational data model
- Oracle Object-Relational Extensions and SQL-1999 Standard
Object-Oriented Databases (25 %)
- Object-oriented data models
- Supporting object modelling in database systems
- Database programming and querying in object-oriented databases
- Object-oriented database standards, systems, languages (e.g. ODMG, ODL, OQL,)
Query Optimization (25 %)
- Query Processing
- Implementation of Relational Algebraic Operators
- Logical and Physical Query Optimization
Learning, Teaching And Assessment Strategy:
Teaching and learning will take the form of a series of lectures supported by
practical seminar sessions and discussions. Students will be expected to
undertake a programme of directed and independent study to support the taught
sessions. The seminar sessions will draw upon the students’ studies and
directed learning. Small case studies will be used where appropriate to
reinforce the theories being taught.
Assessment will be by 3 hours open-book exam. Open-book means that you can take
with you into the examination, any lecture notes, handouts and text books that
you like, and use them to help you in the exam. However you should plan to use
anything taken into the exam with you purely as a memory-jogger; time spent
looking through that material is exam time spent on something other than doing
the exam.
Distance Learning
Delivery:
None
Indicative Reading List
or Other Learning Resources:
(Note: all references to be given as per Harvard System)
Main Text:
Ø Connolly/Begg, 'Database Systems: A Practical Approach to Design,
Implementation, and Management', Addison-Wesley, 4rd Edition, 2005
Ø Elmasri/Navathe, ‘Fundamentals of Database Systems’, Addison-Wesley, 4th
Edition, 2004.
Ø Oracle Concepts, Oracle Corporation.
Ø Oracle Application Developer's Guide – Object-Relational Features
Supplementary Text:
Ø Douglas K. Barry. ‘Object Database Standard: ODMG 3.0’. Morgan Kaufmann
Publishers, Inc. 2000.
Ø Özsu/Valduriez, ‘Principles of Distributed Database Systems’, Prentice Hall,
2nd Edition, 1999.
Ø Ramakrishnan/Gehrke, ‘Database Management Systems’, McGraw Hill, 2nd Edition,
2000.
Further Reading:
Ø Michael Stonebraker, et al, 'Object-Relational DBMSs: Tracking the Next Great
Wave', Morgan Kaufmann, 1998.
Ø Paul Brown, 'Object-Relational Database Development', Prentice Hall, 2001.
Module Delivery Details - Notional Student Workload (Hours)
|
Mode
and Location |
Lectures |
Seminars |
Tutorials |
Lab Work |
Directed Learning |
Independent Learning |
Formal Assessment |
Other |
Total |
|
Full Time
at City Campus |
12 |
0 |
0 |
9 |
26 |
50 |
3 |
0 |
100 |
|
Full Time
at Franchised |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
100 |
100 |
|
Part Time
at City Campus |
12 |
0 |
0 |
9 |
26 |
50 |
3 |
0 |
100 |
Module Summative Assessment
|
Assessment A |
This assessment is Open book examination (3 hours) |