Features of recording of meteorological conditions in the data warehouse of qualification examination of plant varieties

Purpose. To develop a multidimensional model of the data storage for the qualification examination of plant varieties for fixing meteorological conditions in conjunction with the phenological stages of development of varieties that undergo DUS and SVD expertise.

Methods. To conduct research with the establishment of the main structural ele­ments of a multidimensional data warehouse, methods of induction, deduction, analysis and synthesis were used. In the design process of the storage facility, W. H. Inmon’s concept was applied, adapted for the agricultural and agricultural business.

Results. The stages of qualification examination of plant varieties were analyzed and methodolo­gical approaches to the creation of a multidimensional data warehouse model were considered. The features of the use of data storages for storing the results of qualification exa­mination of plant varieties for distinctness, uniformity and stability (DUS) and suitability of a variety for dissemination in Ukraine (SVD) were highlighted. Particular attention was paid to the implementation of the interconnection between the results of the qualification examination of plant varie­ties with the data of meteorological observations at various phenological stages of plant growth and development, according to the records in the electronic field journal. The logical data model of the data warehouse was designed and implemented in the MS SQL Server environment.

Conclusions. Sources of data entry into data warehouses were determined and a multidimensional data warehouse model was implemented according to the “snowflake” scheme. The diagram of the data warehouse was presented, which provided a link between the meteorological conditions of the field experiments and the initial data of the qualification examination, and had four tables of measurements. For each dimension table and fact table, an attribute composition of the data was defined. The data warehouse was practically used to analyze the influence of weather conditions on the indicators of DUS and SVD examinations.