Obtaining and Implementing Software Solutions
Why Reinvent The Wheel?
For software, be it a database, operating system or any other application, whatever you need, chances are something very similar has already been written. Having located something similar it is usually very easy to adapt it to your own needs. This is a process that works with both commercial software and with open source software, and provides many benefits including reduced cost, time and risk.
The standard life cycle of a typical software development project can be summarised as perception of need, systems analysis, requirements definition, design, implementation, testing, installation, maintenance. Variations on this are possible, such as prototyping and rapid application development. However all variations go through each of these stages in some form.
By interrupting the process after the requirements definition stage it is possible to short-circuit much of the rest of the process. Given the requirements it is often possible to find some existing software that provides most of the desired functionality. To do this it is necessary to have a wide appreciation of contemporary software in many fields. Target systems for re-use are often found in unexpected places.
Re-purposing existing software will usually take less time, cost and risk compared to writing new software from scratch. Provided that a software application can be found that meets most of the requirements for the new system, then adding the extra functionality will involve less time, cost and risk. If a business case can be made for developing a new software system, then a stronger business case can be made for re-purposing existing software.
Here are two examples from my own experience. The first was a conference billing and booking system for Warwick University, the second a database to track and gather statistics at a disability advocacy service.
Conference Billing and Booking
In the mid 1980’s Warwick University wanted to computerise its conference booking and billing system, which up until that time had been paper based. As a consultant, having analysed their requirements, I concluded that what they were looking for was very similar to a hotel management system. After a search for suitable suppliers, Innsite (now RedSky IT) were selected. Innsite had a modular suite of programmes that would do everything that Warwick required except for booking facilities such as meeting rooms and AV equipment. They were happy to write a module especially for Warwick’s needs. This solution turned out to be more cost effective for Warwick than having their own system written.
Recently I was approached to fix problems with a database used to track complaints in a disability advocacy service. The database had been written in house several years previously, the developer had left and the documentation was missing. It quickly became apparent that replacing the database was going to be easier that trying to fix a database that was running under an unsupported database system.
After a workflow analysis and requirements definition for the database it became apparent that what was required was very similar to a Customer Relationship Management (CRM) database. A search on Sourceforge, the home of many open source software projects, turned up several CRM systems. The solution chosen most closely matched the requirements, was most mature and was easiest to adapt to the clients needs. The solution is based on a MySQL database with an interface written in PHP, both of which are also free software. The simplest way of providing the necessary platform to run the solution on was to install XAMPP, a single package that provides an integrated set of Apache web server, MySQL database and PHP web programming interface.
Interrupting the standard life cycle of a software development project after the requirements have been defined, to locate existing software that meets most of the desired functionality, can reduce the time, cost and risk involved in delivering a working product.