Skip to main content

Advances in Data Management

Overview

  • Credit value: 15 credits at Level 7
  • Convenor and tutor: Professor Peter Wood
  • PrerequisitesData and Knowledge Management or a similar module in database systems; knowledge of computer programming
  • Assessment: online quizzes (20%) and a two-hour examination (80%)

Module description

In this module we examine the technologies underlying modern data management systems. We will study advanced aspects of query processing, transaction management, distributed data management, and recent developments in web data, big data and alternative database architectures.

Indicative 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
  • Linked data
  • Parallel databases
  • NoSQL/NewSQL stores
  • Graph databases

Learning objectives

By the end of this module, you should be able to demonstrate knowledge of advanced aspects of databases and recent advances in data management technologies in three major directions:

  • performance
  • distribution of data
  • heterogeneity of data.