Jump straight to content - Accessibility Information and Accesskeys.

The ResistVir database project
Genetic resistances to plant viruses and their vectors
The model design and the database schema

The data model design:

The design of the database model and the design of the questionnaires used to describe the research groups have been conducted together to assure the correspondance between these two data structures.

Object oriented technology with UML ® notation has been used to design the database model.

The model has been split up in eight packages:
Basis package : Class, Object, Language, Person ...
Reference package : Crop, Keyword, Plant, Resistance, Vector, Virus ...
Group package : Group, Resistance gene ...
Research package : Research project, Research result, Technology ...
Publication package : Author, Document, Image, Patent, Source, Thesis...
Tools package : Diagnostic, Resources, Collection, Screening, Marker...
Link package : Link, Site...
Traceability package : Operation, Questionnaire...

The Generalization diagram shows how some classes share structure or behavior defined in one or more other classes.

The database schema:

A classical mapping has been applied to convert the object-oriented model to the relational database schema expressed in DDL/SQL:
- Each table corresponds to one persistent class or one N-N relationship
- The uniqueness of objects is ensured by object identifiers given by sequences and defined as primary keys
- To obey inheritance rules, each subclass table shares the primary key of the parent class table

The database has been built with the RDBMS PostgreSQL and contains the following objects:
- 203 tables
- 21 sequences
- 27 check value constraints
- 203 primary key constraints
- 162 unique constraints
- 365 indexes
- 345 referential integrity constraints