COMP60002 (CO572) Advanced Databases
Lecturer(s): Dr Peter McBrien; Dr Holger Pirk
For up to date information, please see course page on Computing web:
To provide students with a detailed theoretical and practical knowledge of how database management systems (DBMS) are implemented, how efficient applications are designed and implemented to work on DBMS, and DBMS may be linked to form `distributed' DBMS (DDB).
Learning Outcomes By the end of the course, student will understand:
How SQL programs are implemented as series of primitive operations
How series of those primitive operations are executed as atomic units of work called transactions, and how those transactions may be executed concurrently
How to write SQL programs (and design DBMS schemas) to make the programs run efficiently
How DDB are implemented, and how applications can be designed for those DDB.
How to integrate existing databases to form a DDB.
Database Management System Architecture main components of a DBMS buffers, caches, and optimisation high level query languages and low level primitive operations
Concurrency Control and Recovery ACID properties of transactions recoverability serialisability Transaction histories as a method for analysing database execution Two-phase locking (2PL) ANSI SQL concurrency control levels
Distributed Databases (DDB) A general distributed database architecture Fragmentation: horizontal, vertical, hybrid Replication Top-up design of DDB: the allocation problem Bottom-down design of DDB: the schema integration problem Tasks in schema integration and strategies to follow Reverse engineering relational database schemas Schema integration transformations Concurrency control in DDB Replication of locks Distributed deadlock detection Atomic commitment of transactions.
Building Advanced (Distributed) Database Applications Distributed query processing and optimisation Programmer's interface Data migration: data warehousing OLAP XML and Relational Databases.
Alternatives to the Relational Database Model Object-oriented databases Object-relational databases
Exam Duration: 2:00hrs
Coursework contribution: 15%
Closed or Open Book (end of year exam): Closed
To be announced
Oral Exam Required (as final assessment): N/A
Prerequisite module(s): None required
Course Homepage: http://www.doc.ic.ac.uk/~jnm