Report of the Workshop on new specification for the Regional Database (WKRDB-SPEC) [report]

ICES
2022
The WKRDB-SPEC was held the 3rd-6th April 2018 and chaired by Henrik Kjems Nielsen from ICES Secretariat. There was a total of 5 participants from Denmark, Ireland, Netherlands and Sweden. The participants of the WKRDB-SPEC was subset of the RDBES Development Support Core Group, shortly referred to as the Core Group, which is a subgroup under the Steering Committee of the RDB. The Core Group is open to any person, who can and will contribute in the specifications of the RDBES. The workshop
more » ... -SPEC was intended to focus on writing the specifications of the new Regional DataBase and Estimation System, RDBES to support the technical development of the RDBES. But to be able to write the specifications the data model must be at a level where all larger changes are discussed and decisions are taken. It was the intention that the countries should give feedback on the data model and the Core Group should discuss and give feedback before the WKRDB-SPEC. But the coun-tries needed more time to give feedback, and the countries feedback is crucial for the RDBES's data model. Therefore the feedback from the countries and the issues found after the WKRDB-MODEL (Jan. 2018) had to be worked on and cleared before focusing on the specifications of the RDBES. That meant the focus and the work of the WKRDB-SPEC changed to focus on the countries feedback and discussing large issues like if the RDBES data model should include clustering sampling and what implications it would have. It was also discussed that the RDBES would not only contain statistical sampling information, but also traditional sampling data. Some traditional sampling will change to design based statistical sampling but it could be that some sampling schemes will stay traditional and flagging of this was introduced in the data model. It was also realised that for fish like tuna weight frequencies would be needed, that meant we re-named the length frequencies table to frequency measure and added a unit. The unique fields in the data model was determined. The field na [...]
doi:10.17895/ices.pub.19291133 fatcat:rlu2y6kcw5aahegy4lx6f3rdfu