| Module Titles | |
| Actual: | Advanced Database Technologies |
| Administrative: | Advanced Database Technologies |
|
Module Information |
| It is of Level M ,Size 1.5 and is worth
15 Credit Points. This Module is not a Year Long Taught Module and was not evolved. It is not currently obsolete. |
|
Module Ownership |
| The Module Tutor is Akhtar Ali, Neil
Eliot, Vassil Vassilev In the Division of Information Systems Engineering In the School of Informatics |
| Module External Information |
| The Cost Centre is Computer Software
Engineering and the price group is B The HESA Subject is COMPUTING SCIENCE |
Synopsis of Module:
A
brief overview of aims, contents, methods and assessment
By use of
lectures and practical seminars, focussing on practical implementations of
advanced DBMS features the unit teaches the extended theory of relational
databases and a physical implementation of one such database management system
in a distributed environment. The students will also be introduced to Object
Orientation in Databases. The main focus of the unit will be the constructs of
Transactions, Distribution and Object Orientation. This will lead to an
assignment which will draw upon comparative skills to evaluate the
appropriateness of using the technologies in a given environment.
Prerequisite(s):
Any
Module which must already have been taken at a lower level, or any stipulated
level of prior knowledge required.
Working experience of a
relational database management system.
Corequisite(s):
Module at
the same level which must taken with this Module.
None
Implications for Choice:
Possible follow-on Modules, or exclusions, or Modules which require this
one as a prerequisite.
None
Aims of Module:
Specified
in terms of general aim of the teaching in its relation to the
subject.
- To introduce the concepts behind and the implementation
of Object Oriented Databases
- To extend the concepts and practical
implementation of the Relation model
- To provide a criteria by which to
evaluate the Object and relational models
- To provide a conceptual model of
Distribution and map the relation model onto it.
Learning Outcomes:
Specified in terms of performance capability to be shown on completion
of the Module.
On completion of the unit the student should be able
to:-
- Compare and contrast the relative merits of both the relational
and object models
- To critically appraise the implementation of the Object
Model in databases
- To understand the implementation of Relational Theory in
a DBMS and its extensions
- To be able to compare and contrast the Object and
relational models to other data models
- To be able to compare and contrast
different distribution techniques in databases and the
effect on the basic
Relational Model.
Outline Syllabus:
The content
of the Module, identified in a component listing.
Classical RDBMS
(10%)
- Review of current technologies
- Outstanding problems
- Need
for Advanced Databases
Extending Relational Databases (10%)
- Support
for SQL programming
- Extending SQL with programming constructs (PL/SQL);
- Embedding SQL in programming languages (Embedded SQL, OCI, SQLJ)
-
External Connectivity (ODBC, JDBC);
- Procedural programming support from
RDBMS
- stored procedures
- packages
- triggers
- Extending the
Relational Data Model
- Object-Relational Data Model
- Nested-Relational
Data Model
Object-Oriented Databases (20%)
- Object-oriented data
models;
- Supporting object modelling in database systems;
- Database
programming and querying in object-oriented databases;
- ODMG standard,
including ODL, OQL, and the Java binding.
Parallel and Distributed
databases (20%)
- Architectures
- Design considerations
-
Interoperability
Transactions, Concurrency, and Recovery (20%)
-
Centralised
- Distributed
- Parallel
Query Processing and
Optimisation (20%)
- Centralised relational
- Object Oriented
-
Parallel and Distributed
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.
Distance Learning students will
receive the lecture and seminar material in an appropriate format, which allows
them to study at a distance with minimal tutor support. The format could be
paper based, textbook, CD-ROM, or Web based. Each unit will contain several
pieces of formative assessment which delegates will submit on a regular basis.
These pieces of assessment will be designed in such a way so that while covering
the main topics being currently studied they do not require a significant time
investment on behalf of the delegates. The design is such that once submitted
these pieces of assessment can be marked quickly and high quality feedback
returned promptly. Support for the unit will be provided by a mix of supplied
material, e-contact and periodic campus/work-based tutorials.
Distance Learning Delivery:
None
Indicative Reading List or Other Learning
Resources:
(Note: all references to be given as per Harvard
System)
Ramez E. Elmasri, Shamkant B. Navathe, (1999) ‘Fundamentals
of Database Systems’, Addison-Wesley, 3rd Edition
Date C J (1995) ‘An
Introduction to Database Systems’, Addison-Wesley, 6th Edition.
M. Tamer
Ozsu, Patrick Valduriez (1999), ‘Principles of Distributed Database Systems’ 2nd
Edition
| Mode and Location | Lectures | Seminars | Tutorials | Lab Work | Directed Learning | Independent Learning | Formal Assessment | Other | Total |
| Full Time at City Campus (The duration is 15 weeks) |
24 | 0 | 0 | 12 | 62 | 41 | 11 | 0 | 150 |
| Part Time at City Campus (The duration is 15 weeks) |
24 | 0 | 0 | 12 | 62 | 41 | 11 | 0 | 150 |
| Distance Learning at City Campus
(The duration is 15 weeks) |
0 | 0 | 0 | 12 | 86 | 41 | 11 | 0 | 150 |
| Distance Delivery at In Company (The duration is 15 weeks) |
24 | 0 | 0 | 12 | 62 | 41 | 11 | 0 | 150 |
|
Assessment A |
This assessment is Open Book Examination (2 hours) The weighting of this assessment is 60% It does have an examination The week(s) due are 14 |
|
Assessment B |
This assessment is Assignment The weighting of this assessment is 40% It does not have an examination The week(s) due are 9, 10, 11, 12 |
| Programme Code and Title | Stage | Semester | C = Core O = Option |
| CGA17CT - MSC APPLIED COMPUTING TECHNOLOGIES | 1 | 1 |
O |
| CGE17CT - MSC APPLIED COMPUTING TECHNOLOGIES | 1 | 1 |
O |
| CGE17CT - MSC APPLIED COMPUTING TECHNOLOGIES | 2 | 1 |
O |
| CGE17IT - MSC INFORMATION TECHNOLOGY PRACTICE (DD/FEB/PROCT) | 1 | 2 |
O |
| CGE17IT - MSC INFORMATION TECHNOLOGY PRACTICE (DD/FEB/PROCT) | 2 | 1 |
O |
| CGE17PF - MSC PROFESSIONAL PRACTICE IN IT (DIST DELIV/FEB/PROCT) | 1 | 2 |
O |
| CGE17PF - MSC PROFESSIONAL PRACTICE IN IT (DIST DELIV/FEB/PROCT) | 2 | 1 |
O |
| CGE17PF - MSC PROFESSIONAL PRACTICE IN IT (DIST DELIV/FEB/PROCT) | 3 | 2 |
O |
| CGE17PF - MSC PROFESSIONAL PRACTICE IN IT (DIST DELIV/FEB/PROCT) | 4 | 1 |
O |
| CGE17PF - MSC PROFESSIONAL PRACTICE IN IT (DIST DELIV/FEB/PROCT) | 5 | 2 |
O |
| CGJ17IP - MSC INFORMATION TECHNOLOGY PRACTICE (DL/SEPT/PROCT) | 1 | 1 |
O |
| CGJ17IP - MSC INFORMATION TECHNOLOGY PRACTICE (DL/SEPT/PROCT) | 1 | 2 |
O |
| CGJ17IP - MSC INFORMATION TECHNOLOGY PRACTICE (DL/SEPT/PROCT) | 2 | 1 |
O |
| CGJ17IP - MSC INFORMATION TECHNOLOGY PRACTICE (DL/SEPT/PROCT) | 2 | 2 |
O |
| CGJ17IQ - MSC INFORMATION TECHNOLOGY PRACTICE (DL/SEPT) | 1 | 1 |
O |
| CGJ17IQ - MSC INFORMATION TECHNOLOGY PRACTICE (DL/SEPT) | 1 | 2 |
O |
| CGJ17IQ - MSC INFORMATION TECHNOLOGY PRACTICE (DL/SEPT) | 2 | 1 |
O |
| CGJ17IQ - MSC INFORMATION TECHNOLOGY PRACTICE (DL/SEPT) | 2 | 2 |
O |
| CGJ17IS - MSC INFORMATION TECHNOLOGY PRACTICE (DL/JAN) | 1 | 1 |
O |
| CGJ17IS - MSC INFORMATION TECHNOLOGY PRACTICE (DL/JAN) | 1 | 2 |
O |
| CGJ17IS - MSC INFORMATION TECHNOLOGY PRACTICE (DL/JAN) | 2 | 1 |
O |
| CGJ17IS - MSC INFORMATION TECHNOLOGY PRACTICE (DL/JAN) | 2 | 2 |
O |
| CGJ17IT - MSC INFORMATION TECHNOLOGY PRACTICE (DL/FEB/PROCT) | 1 | 1 |
O |
| CGJ17IT - MSC INFORMATION TECHNOLOGY PRACTICE (DL/FEB/PROCT) | 1 | 2 |
O |
| CGJ17IT - MSC INFORMATION TECHNOLOGY PRACTICE (DL/FEB/PROCT) | 2 | 1 |
O |
| CGJ17IT - MSC INFORMATION TECHNOLOGY PRACTICE (DL/FEB/PROCT) | 2 | 2 |
O |
| CGJ17PF - MSC PROFESSIONAL PRACTICE IN IT (DL/FEB/PROCT) | 1 | 2 |
O |
| CGJ17PF - MSC PROFESSIONAL PRACTICE IN IT (DL/FEB/PROCT) | 1 | X |
O |
| CGJ17PF - MSC PROFESSIONAL PRACTICE IN IT (DL/FEB/PROCT) | 2 | 1 |
O |
| CGJ17PT - MSC PROFESSIONAL PRACTICE IN IT (DL/SEPT/PROCT) | 2 | 1 |
O |
| CGJ17PT - MSC PROFESSIONAL PRACTICE IN IT (DL/SEPT/PROCT) | 2 | 2 |
O |
| CHA17ET - MSC (ENGINEERING, INFORMATICS, SCIENCE AND TECHNOLOGY) | 1 | 1 |
O |
| CHA17ET - MSC (ENGINEERING, INFORMATICS, SCIENCE AND TECHNOLOGY) | 1 | 2 |
O |
| CHF17ET - MSC (ENGINEERING, INFORMATICS, SCIENCE AND TECHNOLOGY) | 1 | 1 |
O |
| CHF17ET - MSC (ENGINEERING, INFORMATICS, SCIENCE AND TECHNOLOGY) | 1 | 2 |
O |
| CHF17ET - MSC (ENGINEERING, INFORMATICS, SCIENCE AND TECHNOLOGY) | 2 | 1 |
O |
| CHF17ET - MSC (ENGINEERING, INFORMATICS, SCIENCE AND TECHNOLOGY) | 2 | 2 |
O |
| CHF17ET - MSC (ENGINEERING, INFORMATICS, SCIENCE AND TECHNOLOGY) | 3 | 1 |
O |
| CHF17ET - MSC (ENGINEERING, INFORMATICS, SCIENCE AND TECHNOLOGY) | 3 | 2 |
O |
| CMA17CP - MSC COMPUTING | 1 | 2 |
O |
| CMA17SI - MSC SOFTWARE & INFORMATION SYSTEMS DESIGN | 1 | 2 |
O |
| CME17CP - MSC COMPUTING (PT) | 2 | 1 |
O |
| CME17CP - MSC COMPUTING (PT) | 2 | 2 |
O |
| CMF17SI - MSC SOFTWARE & INFORMATION SYSTEMS DESIGN | 2 | 1 |
O |
| CMF17SI - MSC SOFTWARE & INFORMATION SYSTEMS DESIGN | 2 | 2 |
O |