Fareham College

Solution: MySQL Database Management

Fareham College - MySQL Database Management


Fareham College has a reputation for academic excellence and a long historical tradition of academic success. The College strives to develop and deploy a wide variety of processing systems and IT infrastructure applications: to this end, they worked with DSP to utilise MySQL with the aim of reducing the costs of accessing historical reporting data.

The Challenge

Fareham College invests hugely in its facilities and teaching resources, but is under constant budget pressure. While state of the art at the time of implementation, their accounting system was straining to support the complexity and functionality required as a critical business application.

Seen as a high priority project, a cost-effective replacement solution was sourced and time was devoted to ensuring a smooth transition into the new system. In any instance, taking an old system and replacing it with a new one presents significant risks and requires an extremely careful transition.

The college held masses of historical data, so decided to migrate only the balances from the old system to the new system to simplify the process and meet time constraints. Further complicating matters, for audit and reporting purposes they needed to keep historical data that resided in the old system for 5 years. This incurred a substantial cost from the application vendor of £20,000 for a view-only licence for the old system and an additional £4,000 for ongoing support for the Oracle database.

The Solution

Fareham College realised they needed help with finding a way to reduce the large costs associated with keeping the historical data for reporting purposes. They approached DSP, a local database integration and management specialist, who were able to offer a simple solution that would reduce the cost. DSP proposed to:

  • Move the historical data from the existing Oracle database to MySQL. Being open source, this would remove 100% of the cost from Oracle.
  • Pair the MySQL database with a custom built PHP web interface to enable easy access to the data and ease of reporting.

DSP arranged a workshop with Fareham College to discuss their requirements in more depth. An appropriate program with project management, technical resources and regular communications was put in place to ensure a smooth delivery of the project, without incurring any additional and unnecessary expense to Fareham College.

Emma Baxter, Director of Finance and Funding at Fareham College, attests that, “DSP have provided the College with the ability to successfully manage its legacy data at a hugely reduced cost.”

The Result

Fareham College continues to invest in its facilities and teaching resources for supporting strategic growth. The system for historical reporting built by DSP is now owned outright by Fareham College, and cost them less than fifty percent of one year’s view only licence from the application vendor. DSP are on hand for any ongoing support should it be required.

“DSP are a pleasure to work with and have been very flexible in their approach. I can highly recommend DSP to other Colleges who are experiencing similar challenges” - Emma Baxter

Fareham College MySQL Server

Profile: 

Fareham College has a reputation for academic excellence, an innovative curriculum and a long historical tradition of academic success. As a popular choice for school leavers, the College strives to develop and deploy a wide variety of processing systems and IT infrastructure applications.
 
 
Customer:
Fareham College

Industry:
Education 
 

Solution:

  • Moved the historical data from the existing Oracle database to MySQL
  • Pairing the MySQL database with a custom built PHP web interface
 

“DSP are a pleasure to work with and have been very flexible in their approach. I can highly recommend DSP to other Colleges who are experiencing similar challenges”.

Emma Baxter, Director of Finance and Funding at Fareham College

 

logo-mysql-white