such as "Introduction", "Conclusion"..etc
AppleBreed DB is built on a relational model. The structureof its conceptual model allows for the flexible addition ofnew entities. In other words, the AppleBreed DB structure allowsdata with new characteristics to be easily and quickly integratedinto the database, at least as long as the database integrityrules are respected. The ability to encode new data into thedatabase is checked by the database structure itself.
Due to the relational structure of the database, users’queries are easily handled through SQL requests. Other potentialreal-time query tools can be easily added, such as specificmultiple-choice questionnaires for different views of the requestedinformation. Modules to export data in ‘à la carte’output formats are also under development, making data directlycompatible for a wide range of software packages, includingpackages for QTL mapping. An interesting point for geneticistsand breeders is that it is possible to manage traceability ofplant material, a genotype or a family and to follow the parentsand their descendants. In addition, the flexibility of the datamodel makes it possible to adapt this system for other multi-annualbotanical species. Unfortunately, one characteristic of relationaldatabases might represent an inconvenience. Direct encodingof results is not allowed, for example, for new genotypes ormarkers. It is always necessary to insert new data in a particularand logical order and according to a specific and defined format.
AppleBreed DB can store phenotypic data at the level on whichthey were originally assessed, including at the level of individualsamples. In addition, the position of trees in the orchard andthe genetic relationships among genotypes are documented. Together,this allows in-depth analysis of the data because experimentaldesign, position effects, genetic relationships and experimentalvariation can be taken into account.
This not only allows in-depth classical analysis of the phenotypicdata itself, such as heritability estimates and the effect ofdifferent cultivation practices and environments, but also ensuresa high-power detection of marker-trait associations. As it standsAppleBreed DB will be a powerful tool for resolving the geneticbase of horticulturally important traits. In addition, it hasthe potential to support valorization of EST and genome sequencingprojects, since its phenotypic and genetic data can be helpfulin the identification of the candidate genes validated by geneticists.
Enter the code exactly as it appears. All letters are case insensitive, there is no zero.