access keys text only skip to navigation skip to content

Module Description

Module Name, Abbreviated Name, Code

Data and Knowledge Management, DKM, COIY061H7

Credits, Level

15 credits, level 7

Lecturer

Nigel Martin

Online Material

Module web pages

Aims

To study the principles and application of data and knowledge management technology.

Syllabus

  • Database management software: origins and objectives.
  • The relational model: algebraic and logical foundations.
  • Relational algebra and calculus.
  • SQL: data manipulation, host language support for SQL.
  • Transaction management, recovery, concurrency.
  • Relational database theory: dependencies, normal forms.
  • SQL data definition, other features.
  • DBMS architectures and implementations.
  • DBMS storage and indexing.
  • Query optimisation.
  • Enhanced database capabilities: procedural extensions to SQL, database triggers, deductive databases, object DBMS.
  • Distributed databases, distributed architectures and connectivity.
  • Databases and the Web, Java database programming - JDBC, SQLJ, databases and XML.
  • Database research topics.

Prerequisites

none

Timetable

All dates and timetables are now listed in the programme booklets of the individual programmes.

Assessment

By 2-hour written examination and in-class written test, weighting 90% and 10% respectively.

Recommended Reading

Raghu Ramakrishnan and Johannes Gehrke, Database Management Systems Third Edition, McGraw Hill, 2003, ISBN 0072465638