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 analyzed, 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.

Contents

• 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 John Deacon by telephone on +44 20 7498 3773; by fax on +44 20 7498 3747; by emailing  jdeacon@jdl.co.uk; or by visiting http://www.jdl.co.uk

[ Home page | Courses List ]

Last modified: Thursday, 08-Feb-2007.
Copyright © 2007 John Deacon. All rights reserved.