EE Department Intranet - intranet.ee.ic.ac.uk
Close window CTRL+W

COMP60002 (CO572) Advanced Databases


Lecturer(s): Dr Peter McBrien; Dr Holger Pirk

Aims

For up to date information, please see course page on Computing web:
https://teachdb.doc.ic.ac.uk/db/1112/viewrec?table=Course&id=8020029

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

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.

Syllabus

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

Query optimisation

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
Assessment
Exam Duration: 2:00hrs
Coursework contribution: 15%

Term: Spring

Closed or Open Book (end of year exam): Closed

Coursework Requirement:
         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

Book List: