COMP60002 Advanced DatabasesLecturer(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 Exam Duration: 2:00hrs Exam contribution: 85% 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:
|