Servicio de Información Comunitario sobre Investigación y Desarrollo - CORDIS


ASIARESIST Informe resumido

Project ID: ICA4-CT-2001-10028
Financiado con arreglo a: FP5-INCO 2
País: Italy

Relational database with data on strain

The project database has been designed to host all project data and it is accessible by all partners from the page 'Data Base' of the restricted access project web site. It is protected by a different password from the one necessary to enter the web site, resulting in two passwords required to access the DB.

The general structure of the project DB proposed is a relational one. It is based on the main entity strain, which can be connected with many other entities containing various features of the strain itself. Data insertion and queries on this database have been standardised with a consequent creation of a standard data interchange format based on a common protocol for data sharing and a standardised user interface.

The implementation has been performed in Microsoft SQL-Sever 2000 and is recorded at the Medinfo server at Department of Communication Computer and System Science - University of Genova.

All the information described in the enclosed entity-relation diagram (in the document section), is stored in the relational database, together with the strain code. In order to avoid excessive manipulation of data, it was decided by all partners that each partner has the right of inserting data only into the database related to his/her country but once inserted, they can only be deleted by the database administrators.

To implement this and to avoid external access to data, the first page of the web site is a login page asking for a USER ID and a PASSWORD. The user is allowed to enter only if the inserted data matches with the ones in the USER table of the database. This method allows the server to recognise a user and to give him/her certain rights over data, for example the administrator can access data deletion pages, while the other users can only access data insertion pages with country restrictions. At the first release the User database contained only the responsible of each country, so that they were the only authorised persons to access the database. Afterwards they authorised other persons of their own staff, but only for manipulating data related to their country.

Each bacterial strain stored in the DB is given a code, on the basis of data insertion and according to a Standard Operating Procedure for sampling agreed among all partners. The strain code contains information about:
- Resistance / Non resistance to a certain concentration of chloramphenicol antibiotic
- Country of origin
- Sampling Site
- Fish farm pond
- Sampling period
- Sample type
- Colony number

Reported by

Via Guerrazzi 24/12 B
16146 GENOVA
See on map
Síganos en: RSS Facebook Twitter YouTube Gestionado por la Oficina de Publicaciones de la UE Arriba