20 credits at level HE7
Databases are fundamental building blocks of most IT systems, and there are a range of advanced developments in the database area. Undergraduate courses cover database concepts and the use of relational database systems. This module by contrast emphasises implementation issues of relational database systems, and provides an insight into some of the recent developments in database technology, such as distributed databases, object-oriented databases and data-warehousing.
Who can benefit?
This module is of benefit to students who are competent in database design and implementation, and wish to extend their skills and broaden their knowledge in the area.
To compare and contrast emerging architectures for database management systems.
To understand how relational database systems are implemented, and the implications for database performance.
To appreciate the impact of emerging database standards on the facilities which future database management systems will provide.
To develop database design and implementation techniques in the context of a realistic case study.
The relational model
Conformity to model
Distributed relational systems
Emerging DBMS Technologies
Database Applications and Environments
Database and Related Standards
Object Data Management Group standard
Standards for interoperability and integration e.g. CORBA
Database Design and Development Tools
SQLForms or similar forms interface
The module will be taught by a combination of lectures, a case study, tutorials/seminars, practical work and directed reading. The students will be expected to enhance an existing database, used as a case study through out the module, in various ways. The theoretical aspects will be covered in outline in the lectures and tutorials/seminars with the students expected to supply background research and analysis.Their research skills will be developed in this activity, and their ability to summarise fidings orally and in writing will be enhanced. They will also develop their critical skills in evaluating the paper they base their seminar upon.
Assessment will be a practical case study with demonstration and report, and an examination based on advanced concepts.
NB Where this module is offered online (via BoltOnline) lectures and seminars delivered by Elluminate.
Formal Lectures 14 hours
Tutorials/seminars 12 hours
Supervised practicals 14 hours
Unsupervised Practical 40 hours
Coursework 50 hours
Directed reading 40 hours
ExamInation preparation 30 hours
when you have successfully completed this module you will:
to demonstrate that you have achieved the learning outcome you will:
|1.||Critically assess new developments in database technology||Research a selection of new developments in database technology and present the findings orally and in writing with a critical assessment of their impact and importance.|
|2.||Interpret and discuss the impact of emerging database standards .
||Give an overview of the development of a standard to its present state and analyse its impact on the technology and the industry|
|3.||Analyse the contribution of database theory to practical implementations of database management systems.
||Explain the theoretical underpinning of an aspect of the practical implementation of a database management system, such as query optimisation or concurrency control to a selected audience|
|4.||Design and implement part of a database application and evaluate the solution||
Design and implement an application (or part) such as a data-warehouse from an existing operational database, justify the design, and analyse its implementation
Your achievement of the learning outcomes for this module will be tested as follows:
|Description||Assignment with demo/presentation/seminar||Examination|
There are no prerequisites for this module.
No restrictions apply.
Connolly and Begg Database Systems 4th Edition
2004 Addison Wesley
Date C.J. An Introduction to Database Systems 8th ed.
Addison Wesley 2004
Ward and Dafoulas Database Management Systems
William Smith Systems Building with Oracle
Hellerstein and Stonebraker Readings in Database Systems 4th edition
MIT Press 2005
Journal of Database Management
Indicative Web Sites
http://gwynne.cs.ualberta.ca/~oracle oracle resources
|Host Subject Group:|
|User Name||Date Accessed||Action|