Advanced and Modern Databases

Introduction

Part of the reason for the undeniable success of databases has been their solid theoretical underpinning. This course looks at the common data models and DBMS architectures. As well as examining traditional approaches, the course looks at recent developments such as the extended relational model and the object model, and at architectural developments such as distributed databases.

Duration and Construction

The course lasts two days. Each day will start at 09.30 and finish at 16.30. The delivery is via lecture, exercise and discussion.

The days consist of two morning sessions and three, shorter afternoon sessions, with one hour for lunch. Time will be available after 16.30 for extended discussions or related issues.

Intended Audience

The course is for advanced users, designers and administrators of database management systems. Participants should already have a basic understanding of databases, perhaps having attended the Introduction to Databases course.

Aims

To introduce database architectures
To explain the power of a standard data model and to cover the common data models in depth
To show in detail how databases are analysed, designed and managed
To present recent developments in databases such as object databases, distributed databases, very large databases and XML

Deliverables

Lectures
Facilitation of discussions
Direction, assistance and feedback on exercises
Proposed solutions to the exercises
Copies of lecture slides, plus explanatory text and summaries
Reference list of books and sources

Numbers

We recommend that there are no more than 12 participants, with the best results usually obtained when there are at least 8 participants. It is possible, by negotiation and mutual agreement, for more than 12 participants to be present.

The standard DBMS architecture
The data models compared
Analysis techniques
Relational model in detail
Keys
Design techniques for relational databases
The extended relational model
The object model
Interfacing to databases
Advanced database management
Distributed databases
Federated databases
XML
Strengths and weaknesses

Site Requirements

Data projector of at least 1024 x 768 resolution, and suitable screen
White-board, preferably not doubling up as the OHP's screen; blackboard and chalk are acceptable
Flip-chart and easel, with additional flip-chart paper
It is best if the seating is not fixed. Auditorium style seating, for example, makes it difficult to switch from lecture to group work.

Contacting

Please contact Matrice by telephone on +44 7010 704705; by fax on +44 7010 704706; by emailing bookings@matrice.co.uk; or by visiting http://www.matrice.co.uk