A software for an ‘universal grapevine database’ have been developed to support the activity of characterization of grapevine biodiversity. In this database the registered users have the possibility of submitting and managing his own data at any time. The introduced data have three different levels of visualisation: private level (the data are visible only to his submitter), middle level (the data are visible to all other submitters), public level (the data are visible to all public users). Only the data approved by a specific scientific committee could be elevated to the public level. When a submitter introduce the microsatellites data in the database, the application allows a specific standardization procedure based on some specific selected accessions called ‘system accessions’. The main classes of data represented in the database are the ‘grapevine variety’, the ‘ampelographic-ampelometric and phenological-productive descriptors’ (as reported in the second edition of the OIV descriptor list for grape varieties and Vitis species), the ‘microsatellite profile’, agronomical descriptors, true-to-type information, polyphenols and aroma profiles. Several search options have been implemented: a search by variety and other general parameter, a search by ampelographic and ampelometric parameters, a search by microsatellite profile. About microsatellite profile it is also possible a search by range and by a particular standardization procedure. The application has been implemented using the most recent database software and languages, so it is flexible and dynamics especially as concern the addition of other classes of data, like new type of descriptors and molecular markers. Nowadays, the application have been adopted for the ‘Italian Vitis Database’ managed by the ‘Vitis Database Working Group’ (www.vitisdb.it) and it is as accessible as open source software for the creation of other national or local grape database (grapedb.org). In addition we are working for a further application that can connect all these possible databases in order to create an ‘Universal Grape Database’.
The software for an ‘Universal Grapevine Database’
D'ONOFRIO, CLAUDIO
2012-01-01
Abstract
A software for an ‘universal grapevine database’ have been developed to support the activity of characterization of grapevine biodiversity. In this database the registered users have the possibility of submitting and managing his own data at any time. The introduced data have three different levels of visualisation: private level (the data are visible only to his submitter), middle level (the data are visible to all other submitters), public level (the data are visible to all public users). Only the data approved by a specific scientific committee could be elevated to the public level. When a submitter introduce the microsatellites data in the database, the application allows a specific standardization procedure based on some specific selected accessions called ‘system accessions’. The main classes of data represented in the database are the ‘grapevine variety’, the ‘ampelographic-ampelometric and phenological-productive descriptors’ (as reported in the second edition of the OIV descriptor list for grape varieties and Vitis species), the ‘microsatellite profile’, agronomical descriptors, true-to-type information, polyphenols and aroma profiles. Several search options have been implemented: a search by variety and other general parameter, a search by ampelographic and ampelometric parameters, a search by microsatellite profile. About microsatellite profile it is also possible a search by range and by a particular standardization procedure. The application has been implemented using the most recent database software and languages, so it is flexible and dynamics especially as concern the addition of other classes of data, like new type of descriptors and molecular markers. Nowadays, the application have been adopted for the ‘Italian Vitis Database’ managed by the ‘Vitis Database Working Group’ (www.vitisdb.it) and it is as accessible as open source software for the creation of other national or local grape database (grapedb.org). In addition we are working for a further application that can connect all these possible databases in order to create an ‘Universal Grape Database’.I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.
