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.
Degree list
The following degrees include this course