1 / 42

TREEBREEDEX DATA BASE

The Third Annual Meeting of the Tree Breeding Database initiative held in Arezzo from May 25-29, 2009, focused on collaborative advancements in database specifications and data management. Key discussions included the integration of datasets from all partners, progress on technical roles, and the necessity of inputting various species data. Notable deadlines concerning Scots Pine and Wild Cherry datasets were emphasized, alongside enhancing database functionalities for more sophisticated queries and analyses. The meeting aimed to ensure the database remains updated and useful for researchers.

yehudi
Télécharger la présentation

TREEBREEDEX DATA BASE

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. TREEBREEDEX DATA BASE Third annual meeting Arezzo, 25-29/05/2009

  2. Agenda • 17-18/04/07 (Zaragoza): Definition of DB specifications (all partners) – decision to have only 1 database • 28-30/05/07 (Järvenpää):amendments of specifications (all partners) • 24-25/09/07 (Vantaa): technical workshop: agreement on INRA (Medias) & METLA roles • 12/07/07: data input templates sent to partners (METLA) • 21/12/07: data-base structure provided by METLA • 15/02/08: test data (INRA, METLA, SKOGFORSK, LFRI) • 18/03/08: ‘final’ input files + queries examples on web • 12/05/08: database model + SQL-script sent to Medias • 22/05/08 (Vantaa): discussion on input files (INRA-Metla) • 4/06/08 (Wageningen): • Discussion on data-input (last decisions to be taken) • Discussion on editing and queries (1st priority: basic queries agreed on, then open to more sophisticated ones) • Agenda for data preparation and transfer to INRA

  3. Agenda • Fall 2008: Medias-France developed the web-interface for data input (file + on-line), editing and correction • End 2008: Preparation of datasets for Scots pine and wild cherry (all partners) • Introduction of datasets by INRA, control, tuning • INRA/Medias: preparation of statistics/requests/editing – development of interface • Dec.2008: end-of-contract with Medias-France / transfer of database on INRA-server • Partners invited to input their datasets themselves / test the database • INRA starts to input climatic (Worldclim) and soil (pedological map of Europe) data • End of April: V.Pignot hired by INRA on contract for 4 months to achieve requests interface

  4. What is next ? • Deadline : Get missing datasets for Scots Pine and Wild cherry !!!! • Deadline : Input datasets for all other species (Picea, Pseudotsuga, Larix, Med-firs, Acer, Fraxinus, Populus) • Deadline : tables of synonymous • Deadline : Database content analysis • Does it fit what we look for? • Combining information • Deadline : show-case for internet

  5. Statistics • 119 files inserted (FT, GU, TM + synonymous + climate + soil) • 1502 field trials • 50676 genetic units76455 test material922 climate data920 soil data

  6. Scots pine Is missing:

  7. Scots pine

  8. Wild cherry

  9. Input of datasets • Through Excel sheets (3: FT – GU – TM) • Or on-line • Start in the order: FT > GU > TM • Respect all sheet headlines, columns order, etc • Fullfill all mandatory fields ! • But other fields are useful too !!! • Respect codes !! • Use -9999 exceptionally !!! • An « extra»- « automatic » service : access to some climatic and soil consolidated/standardised information But…if no geographic coordinates… no information possible

  10. Each line in each file must be unique ! • In FT: one national_code/ trial • In GU: one national_code/ gu • In TM: one national_code for site x one Entry_id code • Specific pb. of TM file: link betw. FT & GU files

  11. The less information you will provide, the less interesting will be the data base • Nobody can say: « I do know what is the relevant information »

  12. Policy: to let it open for other species

  13. Policy: to let it open for other institutes

  14. Please enter file in following format: P15-Pa-Data20050518-GU-LT.xls Partner-species-Datadate-file-country.xls Validate - insert Error messages + e-mail

  15. Can extract tables in xls or cv The « owner » is the one who has entered the data. He/she will be the only one who can delete and correct his/her dataset + administrator Files can be read by everybody

  16. General statistics

  17. Genetic Unit type: Added field !! NAT SYN HSP FSP CLO VAR OTH

  18. Experimental data Ecological data Measurement data

  19. Search for gu present in different tests sites through the synonymous search

  20. Synonymous issue • This new table allows connecting the sameGU recoded differently by several partners (e.g. IUFRO trials / EU-trials, etc) • Interest: find out which genotypes have been commonly tested, by who, where and when ; find out shared gu in collections, etc • Need • to identify shared material (susceptible to be used by others) • to find out correspondance betw. material, • to prepare Excel file

  21. Synonymous issue • Synonym group/description • Synonym head: national GU code of the donor • Synonyms: national GU codes of receivers How to organise all this ?

  22. Synonymous issue

  23. -9999 issue • Mandatory fields

  24. Show-case issue • Objective: • Inform about existence of DB • Draw attention of potential users • Some attractive pages needed • What is in? • What can be done with it? Can I find relevant information for my research? • Good examples needed.

  25. Up-dating issue • To be of interest a database must be kept alive: • Regularly up-dated • Completed when too many missing information • Think about new developments (link with GIS tools ?)

  26. Prunus avium – genetic trials across Europe Euforgen

  27. Deadlines: • Input of data for other species? • Synonymous tables • DB content analysis • Show-case for internet

More Related