One of the main aims of ResistVir project is to create an on-line database about the research activities on plant genetic resistances to pathogenic viruses and their vectors in European crops. Methods, technologies and resources used to control plant viruses and their vectors are also recorded in that database. This database informs of the latest developments related to the control of plant pathogenic viruses and their vectors. This project will contribute to improve the cooperation between European researchers and between research organizations and enterprises including SMEs.
During ResistVir meetings, the general orientation and the progress of the database project are discussed by ResistVir members; therefore the Consortium may control and define the frame of its development.
A database steering committee has been created. The members of this committee discuss and validate the main decisions concerning the design and the development of the database and its dedicated web site.
Both the database and the dedicated web site are designed and built by INRA. This task is located at the INRA Research Centre of Avignon and performed by GAFL research unit.
The database and the dedicated web site are settled on a Linux server managed by the INRA Avignon Centre Networks and Systems Group.
ISO codes are used for countries and languages.
Some external structured and controlled vocabularies are used:
- The Indicative Crop Classification developed by FAO is used to identify crops.
- Virus taxonomy: all plant viruses species are recorded. The origin of data is the ICTVDB web site.
- Host plants and vectors taxonomy: only studied plants and vectors are recorded. The origin of data is the NCBI taxonomy database.
- Some specific lists of values were created and updated as necessary.
The origin of most data recorded in the database is the filling up of questionnaires by scientists directly involved in the European researchs on plant pathogenic viruses and their vectors.
These questionnaires have been designed to enable research teams to publicise their activities in the database. They can be used to describe new data or to amend recorded data (update or delete). The persons who fill in the questionnaires are considered to be responsible for the accuracy of the data.
The database and the dedicated web site are physically hosted on a Linux server managed by INRA and built mostly with open or free softwares. Among those:
- RDBMS: PostgreSQL
- UML modeling tool: Poseidon for UML developed by Gentleware
- Programming language: Python
- HTTP server: Apache
- February 2005 (Roma meeting): database project short presentation and discussion
- July 2005 (Ankara meeting): presentation and discussion about the project and the questionnaire (version 0.4)
- February 2006 (Alicante meeting): presentation and discussion about the questionnaire (version 0.7) and the web draft site
- March 2006: validation of the questionnaire (version 1.0) and distribution to all Consortium members
- April 2006: database creation and first loading of data
- July 2006 (Helsinki meeting): presentation and discussion about the questionnaires receipt and the database situation
- September 2006: opening of the web site dedicated to the database (initial version with first results)
- December 2006: expected delivery of the general interactive query interface (delayed)
- February 2007: expected delivery of some extra query functions (delayed)