Databases have become far more than simple repositories of data. They are now complex mechanisms for distributing information.
A recent project that we completed enables advisors using laptops all over the UK, to capture client information off line, then link to our server via VPN (Virtual Private Network) and synchronise the new data with the master database held on our SQL 2000 server.
This has speeded the throughput of information, removed the need for time consuming and error prone re-keying, and opened up the opportunity for new services that were not even dreamed of in the original project specification.
We also have practical experience of delivering these systems with complex (but easy to use) content management systems that removes the need for any programming skills from the process of adding the content.
Our most sophisticated online version is Graham Bishop, an internationally recognised commentator on the Financial Markets and the impact of the Euro. His staff add information to the site from offices all over Europe.
In many businesses an efficient and reliable database is now second only to staff as the companys' most valuable resource. The problem is that in many cases a companys' database is neither efficient nor reliable. Nearly all our work in this area comes from customers who have been struggling through using a less-then-perfect database or from customers who have a good working database that needs to be expanded in its capabilities. The three major advantages that computers and the Internet have over the traditional paper and ink are:-
Search engines: You can find the information that you want from within a massive encyclopaedia even if you have no idea where to start looking. In a book format you have to learn how the index has been designed and then laboriously check each reference for relevance.
Collaboration: The data can be compiled by large numbers of people who may be working in different locations, and enable them to add their material in a structured form and under central editorial control.
Timely: The whole process can be immediate. Any business activity that is time critical (and that applies to any information driven business) will recognise the need to work fast to distribute information.
We are also commercially aware of the opportunities that can arise by being able to deploy/sell the content to other websites and the technical issues that arise from such a split of control.