The module aims to cover a range of Advanced Database topics. The module assumes that the students will have studied databases at an undergraduate level and will build upon those skills to look at how databases are used in IT architectures in commercial organisations. The module will have a industry focus looking at techniques, databases, tools and areas of application regularly used in industry.
The module will be 100% continuous assessment and this allows the module to evolve as new database and data management techniques come available. The module will be divided into 4 core areas.
- Core Database Features
- Internals of a Database
- Implementation of Complex Database Architectures
- Latest Developments in Databases
Core Database Features
- Traditional Database architectures
- Understanding of role of the three schema architecture
- Detailed understanding of database internals and how they relate to the three schema architecture
- Database design, consisting of the ER diagram, domains, business logic, etc
- The Thick Database Paradigm
- Relational and NoSQL Databases, features, applications and when to use
Internals of a Database
- Expansion of the Thick Database Paradigm and its implications
- Database Security
- Database Encryption, Masking, Redaction, etc
- SQL Query Optimization
- Database Optimization features
- Advanced performance features of databases
Implementation of Complex Database Architectures
- Database Replication, real-time and near-real-time
- Distributed Database architecutres
- Distributed data management
- Database Sharding
Latest Developments in Databases
- The evolving SQL language
- Advanced SQL for analytics and data processing
- Advanced data and database architectures
- Recent developments in Hadoop and distributed data/database management
- Review of latest products and features.
- Comparison of newly released produced to more traditional approaches
- Evaluation of new tools, databases, and data processing techniques
- Data management and Governance
Managing data in an ever increasing data management environment.
The module is designed to be delivered within a blended learning model, employing mixed modes (online and face to face) of learning, teaching and assessment.
TU059 will be delivered primarily in a face-to-face mode while TU060 will be delivered in a blended mode.
Combination of lectures, lab work and flipped classroom
| Module Content & Assessment | |
|---|---|
| Assessment Breakdown | % |
| Other Assessment(s) | 100 |