COMP0022 Database and Information Management Systems

This database contains the 2018-19 versions of syllabuses.

Note: Whilst every effort is made to keep the syllabus and assessment records correct, the precise details must be checked with the lecturer(s).

Academic session

2018-19

Module

Database and Information Management Systems

Code

COMP0022

Module delivery

1819/A6U/T2/COMP0022 Undergraduate

Related deliveries

1819/A7P/T2/COMP0022 Postgraduate

Prior deliveries

COMP3013

Level

Undergraduate

FHEQ Level

L6

FHEQ credits

15

Term/s

Term 2

Module leader

Dowell, John

Contributors

Dowell, John

Roberts, Graham

Module administrator

Ball, Louisa

Aims

This module builds on the introduction to relational databases course Logic and Database Theory (COMP0009). It covers fundamental techniques used by the database management systems for managing transactions with the database, for optimising queries on the database, and for managing distributed data. It then covers contemporary strategies in databases at scale including data warehousing, data mining and online analytic processing. It also covers recent and emerging trends in database technologies relating to semi-structured and un-structured data. Technologies for building web-facing databases are a particular focus for the module. The coursework is an interesting group project lasting the duration of the term and building an operational database system using very current technologies.

Learning outcomes

On successful completion of the module, a student will be able to:

  1. understand the methods and technologies involved in database and information management systems
  2. have competence with creating web facing database systems;
  3. understand application issues and current trends in database technologies.

Availability and prerequisites

This module delivery is available for selection on the below-listed programmes. The relevant programme structure will specify whether the module is core, optional, or elective.

In order to be eligible to select this module as optional or elective, where available, students must meet all prerequisite conditions to the satisfaction of the module leader. Places for students taking the module as optional or elective are limited and will be allocated according to the department’s module selection policy.

Programmes on which available:

  • BSc Computer Science (Year 3)
  • MEng Computer Science (Year 3)
  • MEng Mathematical Computation (Year 3)

Prerequisites:

In order to be eligible to select this module, student must have passed BSc/ MEng Computer Science (Years 1 and 2) at UCL.

Content

  • The database management system
  • Transaction Management
  • Query processing
  • Distributed databases
  • Database implementation
  • Data warehousing
  • OLAP and Data mining
  • Semi structured data and new data models

An indicative reading list is available via http://readinglists.ucl.ac.uk/departments/comps_eng.html.

Delivery

The module is delivered through a combination of pre-recorded lectures, face to face lectures, and lab sessions supporting an extended group programming project.

Assessment

This module delivery is assessed as below:

#

Title

Weight (%)

Notes

1

Written examination (2hrs)

70

 

2

Group project

30

Late summer assessment would be by an individual assignment.

In order to pass this module delivery, students must:

  • achieve an overall weighted module mark of at least 40%; and
  • achieve a mark of at least 30% in any components of assessment weighed ≥ 30% of the module.

Where a component comprises multiple assessments, the minimum mark applies to the overall component.