Skip to content Search
Search our website:

Advances in Data Management

Short name: ADM
SITS code: COIY025H7
Credits: 15 credits
Level: 7
Module leader: Alexandra Poulovassilis

Module outline

This module examines the technologies underlying modern data management systems. It studies advanced aspects of query processing, transaction management, distributed data management, and recent developments in web data, "big data" and alternative database architectures.

Aims

To study advanced aspects of databases and recent advances in data management technologies in three major directions: performance, distribution of data, and heterogeneity of data.

Syllabus

  • Review of the fundamental principles of database management systems, relational databases and SQL.
  • Query processing and query optimisation.
  • Transaction management: ACID properties, concurrency control, recovery.
  • Beyond records and objects: stored procedures and functions, triggers, semantic technologies.
  • Distributed databases: data fragmentation and replication, distributed query processing, distributed transaction management.
  • Heterogeneous data integration.
  • XML data management.
  • Linked Open Data.
  • Parallel databases.
  • Big data and NoSQL/NewSQL stores.
  • Graph databases.

Prerequisites

A first module in Database Systems (e.g. as taught in a typical U.K. undergraduate degree in computer science).

Timetable

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

Coursework

Several pieces of coursework will be set during the module.

Assessment

By 2-hour written examination and coursework. The final module mark will be the exam mark attained. A minimum mark of 40% on the coursework component will be necessary in order to pass the module overall.

Recommended reading

  • R.Ramakrishnan and J.Gehrke, Database Management Systems, McGraw-Hill 2003 (3rd Edition)
  • A.Silberschatz, H.F.Korth and S.Sudarshan, Database System Concepts, McGraw-Hill 2011 (6th Edition)
  • M.T.Oszu and P.Valduriez, Principles of Distributed Database Systems, Springer, 2011 (3rd Edition)
  • A.Elmagarmid, M.Rusinkiewicz and A.Sheth (eds), Management of Heterogeneous and Autonomous Database Systems, Morgan Kaufmann, 1999
  • Research papers will be distributed to students; students will also be directed to Web resources on the subject.