UO Database for the Enterprise

Undergraduate | 2026

Course page banner
area/catalogue icon
Area/Catalogue
INFO 2030
Course ID icon
Course ID
203910
Level of study
Level of study
Undergraduate
Unit value icon
Unit value
6
Course level icon
Course level
2
Study abroad and student exchange icon
Inbound study abroad and exchange
Inbound study abroad and exchange
The fee you pay will depend on the number and type of courses you study.
Yes
University-wide elective icon
University-wide elective course
Yes
Single course enrollment
Single course enrolment
Yes
alt
Note:
Course data is interim and subject to change

Course overview

The aim of this course is to provide the skills to interact with existing large sets that are structured or unstructured. The aim of this course is topics in this course include: concurrency and transaction management; data organisation, hash, indexes, query optimisation, active databases, and procedures; distributed database design, fragmentation, and replication; distributed transaction; data warehouse architecture and components; data warehouse modelling: star and snow flake; analysis: multidimensional Online Analytical Processing (OLAP) and relational OLAP; warehouse design, data uploading, updating and integration.

Course learning outcomes

  • Use advanced tools to query and modify structured databases.
  • Contrast the different types and uses of specialised databases.
  • Design and use a data warehouses, and select appropriate data processing techniques on the data warehouses.
  • Design queries to interact with unstructured datasets to retrieve sensible data.
  • Compare and use data warehousing architectures.

Prerequisite(s)

N/A

Corequisite(s)

N/A

Antirequisite(s)

N/A