Handout following the ECPGR Workshop ‘Central Crop Databases on-line’, Bonn, June 8-10, 1997
Downloadable databases on the Internet

Theo van Hintum
Centre for Genetic Resources the Netherlands (CGN), Centre for Plant Breeding and Reproduction Research, P.O. Box 16, 6700 AA Wageningen, The Netherlands
 

The easiest way of providing access to a database via the Internet is by creating a downloadable version of the database, or parts of it, and putting it ‘on the net’. It allows any user connected to the Internet to download it and use it the way (s)he likes.

Pros and cons
Providing downloadable databases should be considered a complementary service to providing on-line searchable databases. Both approaches have their pros and cons.
Some advantages of downloadable databases are:

Some disadvantages: Requirements of downloadable databases
Downloadable databases should be as accessible and as up-to-date as possible.
The accessibility can be improved by using The data sets should not be too large and have a relevant coverage.
Providing the user with a tool to browse or query the data might be helpful, though most users can be expected to have access to some database or other software that is able to provide this functionality.
It is advisable to bundle and compress all relevant file in one ZIP file. Relevant files include: To keep the files as up-to-date as possible, automatic procedures can be developed that refresh the files when appropriate. One might even consider automatic distribution of updated versions to important users via Email.

Final steps
Once the ZIP files are available they have to be put on the net, and referenced in HTML documents on the net. If no local server is available and/or knowledge of HTML is lacking, a member of the ‘Internet Advisory Group’ (e.g. CGN,IPGRI, NGB, ZADI) should be approached. They will provide you with a simple solution within minutes.
 
Conclusion
Downloadable databases, accompanied by information for their interpretation and compressed in ZIP files, provide an attractive way of providing access to databases. They should be considered as a option in addition to providing access via on-line searchable databases. Since the technology needed is available in any genebank, the databases can be ‘on the net’ within weeks.