This module will focus on topics of:

Distributed Computing

Storage/Access Mechanisms
Reliability/Availability
Security of the data – in transit and at rest
Compliance requirements onsite and external processors
Communications to any stored information
Global Data Sources
Distributed Processing
Visualisation of data

Data Section

Database design, schemas and domains
Data modelling and design issues
Introduction to Databases – Oracle, SQLserver
Introduction to Database Languages – for example SQLplus
Data replication, client server and distributed databases
Concurrency, integrity and deadlock
ACID v CAP v BASE etc
Databases and Cloud infrastructure
Database security
Backup and disaster recovery
Data Interchange

Written Report – Documentation of an individual practical assignment to create a database artefact which is supported by a management style report. The case study which will be looked at as a part of this module will be based on real world scenarios. The student will be presented with a company problem and this will need to be researched, analysed, and evaluated to produce a suitable solution to the problems which are defined (Learning Outcomes 1 to 2).

Written Report - An individual written assignment which will be based upon a commercial scenario. The student will be analysing the information provided in order to produce a management style report (Learning Outcomes 3 and 4).

1. ANALYSE SITUATIONS AND/OR ENVIRONMENTS FOR THE APPLICATION OF A DATABASE SOLUTION WITH RESPECT TO DISTRIBUTED DATA

Analysis,
Problem Solving

2. DEFINE THE CENTRAL CONCEPTS OF DATABASES, INCLUDING CONSTRAINTS IN THE DESIGN OF A DISTRIBUTED DATABASE DUE TO ISSUES OF CONCURRENCY, INTEGRITY, AND SECURITY

Communication,
Knowledge and Understanding

3. UNDERSTAND THE LEGAL REQUIREMENTS OF THE DATA WHICH IS STORED AND TRANSFERRED CONSIDERING INTERNATIONAL PRIVACY REQUIREMENTS

Learning,
Knowledge and Understanding

4. ANALYSE THE DIFFERENT OPTIONS WHICH ARE AVAILABLE FOR THE STORAGE, PROCESSING AND AVAILABILTY OF COMMERCIAL DATA

Analysis,
Problem Solving

All teaching sessions will blend theory and practical learning. Students will be introduced to curriculum concepts and ideas and will then be able to apply theory to practical examples within the same sessions. In addition, students will be provided with a range of resources for independent study such as case studies, academic papers and industry stories. There will be a mixture of practical and theoretical formative (mock or practice) exercises which will help students build knowledge and confidence in preparation for summative (formal) assessment.

Oracle

QSEE

AWS Academy environment

All texts and electronic resources will be updated and refreshed on an annual basis and available for students via the online Study Links resource platform. All reference materials will be collated and curated and aligned to Equality, Diversity & Inclusion indicators.

Palicio, (2021), Distributed Data Systems with Azure Databricks: Create, deploy, and manage enterprise data pipelines,¿Kindle Edition

Vittilo, (2022), Understanding Distributed Systems, Second Edition: What every developer should know about large distributed applications, Roberto Vitillo¿

Khononov, (2021), Learning Domain-Driven Design: Aligning Software Architecture and Business Strategy, O’Reilly Media,

Connolly, Begg, 2015, Database Systems, Pearson Education

Partner, 2021, Designing Cloud Data Platforms, Zburivsky, Manning Publications

Akidau, 2018, Streaming Systems: The What, Where, When, and How of Large-Scale Data Processing, O'Reilly

Room, 2021, Data Protection and Compliance, BCS

Relational databases are extremely common in the IT industry. This module will teach students how to manage a relational database and will provide and discuss issues relating to the management and control of replicated and distributed databases. This module will take both a theoretical and practical focus with assessment requiring you to work on two case studies to explore problems and identify solutions.