This module builds on the introduction to database concepts and technologies provided in Database Systems by presenting advanced implementation aspects of the relational database model. It also presents the concept of dimensional models from a technical perspective and introduces emerging database models such NoSQL systems and technologies such as data mining.
- Beyond Database Normalization
- Dimensional modelling: star schema, snowflake schema
- The ETL process overview
- Data Mining, Data Warehousing and OLAP
- Distributed Databases and the CAP theorem
- Introduction to NoSQL database systems
- NoSQL document-based databases
This module can be delivered either through standard delivery or blended delivery.
In standard delivery this module is delivered through a series of lectures with associated practical assignments.
In blended delivery this module is delivered through a series of live or recorded lectures with associated laboratory work and practical assignments.
Both blended and standard delivery have the same overall number of teaching and self-directed learning hours.
| Module Content & Assessment | |
|---|---|
| Assessment Breakdown | % |
| Formal Examination | 70 |
| Other Assessment(s) | 30 |