Module Name, Abbreviated Name, Code
Data and Knowledge Management, DKM, COIY061H7
15 credits, level 7
Module web pages
To study the principles and application of data and knowledge management technology.
- 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.
- 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.
All dates and timetables are now listed in the programme booklets of the individual programmes.
By 2-hour written examination and in-class written test, weighting 90% and 10% respectively.
Raghu Ramakrishnan and Johannes Gehrke, Database Management Systems Third Edition, McGraw Hill, 2003, ISBN 0072465638