Other Great Sites
MorningValley.com All the Best Christmas stuff, from all over the net!
SpaceWeekly.com The latest Space News!
BinChat.com Learn all about Blogging!
CompuHype.com The latest Technology News!
Computer Hunter Internet Advice and Fun!
Free Monkey Search Get a free monkey with every search!
TruthIsFalse.com Every thing you know is a lie!
SciFiStar.com Your link to the Stars on the net!
[an error occurred while processing this directive]
e0s.com Who caused Sept 11 The answer is here!
CapitalDomains.com Get your own Dot Com Name!
WhoHe Do you know these Male Celebrities?
WhoShe Do you know these Female Celebrities?
Hero or Zero Vote for your favorite Hero or against a Zero!
Tips Point FREE tips and hints about everything.
UnFind Find anything related to the United Nations!
SnackSite.com Chocolate at its Best!
NextNest.com Interior Design
VibeFanClub.com Everything Automotive!
CashRoundUp.com Home Equity Resources
ClickJets.com All about Travel
HikingBin.com Recreation Resources
Computer Hunter .org Articles about almost everything!
BeyondTheBedroom.com All the Best Bed Room stuff, from all over the net!
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.
This article was posted on February 13, 2006