Problem

The client had been processing this range of examinations for many years using a batch based system on an in house mainframe system. Over the years this had been "developed" into a complex system, holding large amounts of data, which more than adequately satisfied all the in-house and governmental requirements.

However, as with most long-term development cycles, the systems documentation did not always reflect the latest operational state/requirements.

Most of the clients other computer systems were now run on a large NT Server network using SQL Server and the management were keen to bring this system in line.

 The problems faced were twofold: -

                                        · The costs and timescales of redevelopment were prohibitive.

                                        · Lack of formal documentation was a significant cause for concern.

Solution

The legacy code of the existing programs were converted to run on the company's network.

The opportunity this conversion presented meant that the existing flat files were converted into an SQL Server Data Base and a Windows graphical interface replaced the "green screens". A further refinement saw the introduction of an online interrogation system of all candidates' historical information for authorised users.

Benefits

The conversion was completed well within the original timescales with reduced processing times. This allowed the mainframe to be decommissioned and on-going maintenance costs to be significantly reduced.

All the existing business logic was retained and parallel processing was reduced to a minimum.

The system sits happily and unobtrusibly on the users desktops and has been readily accepted by them.

N.B. As a result of this development a further requirement has been identified which addresses the problem of timeliness and accuracy in processing examination results. With the aid of European funding Steeple have developed a system which links the examiner's vital input into the process via the internet.

This is marketed under the name of REMIT.