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-Explorer to utilise MySQL with the aim of reducing the costs of accessing historical reporting data.
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.
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-Explorer, a local database integration and management specialist, who was able to offer a simple solution that would reduce the cost. DSP-Explorer 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-Explorer 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 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-Explorer have provided the College with the ability to successfully manage its legacy data at a hugely reduced cost.”
Fareham College continues to invest in its facilities and teaching resources for supporting strategic growth. The system for historical reporting built by DSP-Explorer is now owned outright by Fareham College and cost them less than fifty per cent of one year’s view only licence from the application vendor. DSP-Explorer is on hand for any ongoing support should it be required.
Solution:Moved the historical data from the existing Oracle database to MySQL
Pairing the MySQL database with a custom-built PHP web interface
“DSP-Explorer are a pleasure to work with and have been very flexible in their approach. I can highly recommend DSP-Explorer to other Colleges who are experiencing similar challenges”
Director of Finance and Funding | Fareham College