The final version of the metadata database has now an “Access” format. Each possible category of data column in the catalogue (with related information) is now an independent database table. There are 10 tables used for common information obtained from the inventory sheets: Activities, Country, Descriptor, Monitoring Type, Organization, Parameter, RSC, Spatial Coverage, Species, Stations, while many similar parameters with different names where unified and fixed (e.g. unified/fixed all shipping, shipping activity – > to Shipping Activity). “Data” table is a combination of each of these tables represented by the row ID of each selection from their own table. The relation between information tables and the Data table is organized by special ID’s. Each information table holds the information only one time, and is associated with a single ID in its own table. Then in the Data table only the ID of this specific field is used to identify the information.
You could download the Access file by login in below. When use available information existing on the meta database use the following copywrite: © IRIS-SES project funded by DG Environment.