Course overview
This course will introduce techniques used in web data management and databases, including XML, distributed databases, data warehouses, data mining and other special databases. Topics in this course include: Semi-structured/XML data management and retrieval, data organisation, hash, indexes, query optimisation, active databases, and procedures; distributed database design, distributed transaction; NoSQL databases, operations, and data retrieval; 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 design, query and modify specialist databases.
- Implement data warehouses and noSQL databases.
- Design queries to retrieve data from data management systems for integration.
- Design queries to interact with unstructured datasets to retrieve sensible data.
- Design transformation tools to communicate data among different data management systems.