WorldFish Carp Genetic Improvement Program Data Management System (Version 3): Data input

Abstract

The WorldFish Carp Genetic Improvement Program (CGIP) is comprised of three species: catla (Catla catla), rohu (Labeo rohita) and silver carp (Hypophthalmichthys molitrix) and generates substantial volumes of data each year. Core CGIP genetic and measurement data are retained in a SQLite relational database (‘the CGIP Database’) – a separate system is used to store CGIP pond environment and pond management data. The CGIP Database aims to store data in an accurate and consistent manner, to allow complete or partial automation of error-checking, data validation, data analysis and data reporting procedures via the CGIP Data Management System or tailored R scripts. This report details the process of data input to the CGIP Database through the CGIP Data Management System Graphical User Interface. Outputs of the CGIP Data Management System are not described. Access to the CGIP Data Management System and GCIP Database is available to authorised WorldFish staff only. WorldFish CGIP data is loaded to the GCIP Database as soon as possible after collection. This allows any errors to be captured quickly and minimises the possibility of data loss. Load (i.e. data input) procedures within the CGIP Data Management System are deliberately rigid in terms of the order in which data can be loaded and the format of load files.