Project

Migration of WOT Shellfish database

Wageningen Marine Research has a large database in which shellfish data are stored (the CSO database). This current database has almost reached its maximum storage capacity. In order to guarantee data preservation and availability the data needs to be stored in another type of database. At Wageningen Marine Research there is already another database available  that meets these criteria: FRISBE. Incorporating the shellfish data into this existing database is the logical step forward. Although both databases contain similar types of survey data,  several steps are needed before the shellfish data can be successfully migrated to FRISBE, ensuring all relevant data is indeed stored and accessible. The first of these is to adapt database tables and import procedures in such a way that they become usable for the shellfish data. The next step is to try and import a test-dataset into the FRISBE database structure. this will be done in a test environment where it is possible to check whether everything that needs to be imported can be imported. Once this has been tested, the next step (starting 2018) will be to migrate all CSO datasets to FRISBE.

Wageningen Marine Research has a large database in which shellfish data are stored (the CSO database). This current database has almost reached its maximum storage capacity. In order to guarantee data preservation and availability the data needs to be stored in another type of database. At Wageningen Marine Research there is already another database available  that meets these criteria: FRISBE. Incorporating the shellfish data into this existing database is the logical step forward. Although both databases contain similar types of survey data,  several steps are needed before the shellfish data can be successfully migrated to FRISBE, ensuring all relevant data is indeed stored and accessible. The first of these is to adapt database tables and import procedures in such a way that they become usable for the shellfish data. The next step is to try and import a test-dataset into the FRISBE database structure. this will be done in a test environment where it is possible to check whether everything that needs to be imported can be imported. Once this has been tested, the next step (starting 2018) will be to migrate all CSO datasets to FRISBE.

Publications