Overview

Background

The current Oracle database infrastructure for PUBS has reached an age where it is no longer satisfying the demands made of it. ITS100 Implement New Database Tier project has delivered the new infrastructure that can offer better performance, sustainability and resilience. To realise those benefits, IS Applications are now undertaking a series of projects to migrate existing   databases   from the old database infrastructure to the new one established under project ITS100. This project covers the migration of the PUBS (Publications)   database that is the database used by the Records Management Section to monitor information requests and manage the University's publication scheme.  

Scope

The scope of this project includes the following:

1. Establishing the parameters of what needs to be done for the migrations using the guidance available here.
2. Setting up versions of the PUBS database in DEV, TEST and LIVE that will replace those on the old infrastructure.
3. Undertaking any relevant testing on the DEV version.
4. Carrying out user testing on the TEST version to ensure the test versions of the related applications can access the migrated database
5. Resolving any problems reported during user testing
6. Deploying the migrated version to LIVE
7. Updating the TAD and any other relevant documentation

No changes that would affect the functionality of the database or related applications will be made. The decommissioning of older versions of migrated databases has not been included in the scope of migration projects so far but should be considered as far as possible, within the time & cost limits of the project.

Objectives

1. To move all PUBS Database environments to the new Database tier to deliver a more stable, better performing, feature-rich and supported infrastructure for all applications utilised by Records Management Section.
2. To update supporting technical documentation for the migrated databases & related applications.

Deliverables

The deliverables for the project are:

1. A migrated version of the PUBS database in DEV, TEST and LIVE
2. Updated technical and support documentation

Benefits

The benefits below will be realised once the PUBS database is made live in the new infrastructure:

1. The cost to the university will be reduced due to theincreased reliability and minimal support time.
2. Customer experience will be improved due to higher security level and reduced loss of service.
3. Patching and proactive management will be streamlined.

Success Criteria

1. Underlying PUBS databases are migrated to the new Oracle database tier with minimal impact to the operations.
2. PUBS databases continue to function as normal using the new database tier.
3. Service levels of applications using PUBS LIVE are maintained or improved.
4. Any existing BOXI reporting continues to function as normal.