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

Authors

DOI:

https://doi.org/10.21498/2518-1017.17.3.2021.242980

Keywords:

meteorological data, phenological stages, dimensions, facts, attributes, growing season, interphase period

Abstract

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.

Downloads

Download data is not yet available.

References

Anderson, P. K., Cunningham, A. A., Patel, N. G., Morales, F. J., Epstein, P. R., & Daszak, P. (2004). Emerging infectious di­seases of plants: pathogen pollution, climate change and agrotechnology drivers. Trends Ecol. Evol., 19(10), 535–544. doi: 10.1016/j.tree.2004.07.021

Audsley, E., Pearn, K. R., Simota, C., Cojocaru, G., Koutsidou, E., Rounsevell, M. D. A., Trnka, M., & Alexandrov, V. (2006). What can scenario modelling tell us about future European scale agricultural and use, and what not? Environ. Sci. Pol., 9(2), 148–168. doi: 10.1016/j.envsci.2005.11.008

Baker, R. H. A., Sansford, C. E., Jarvis, C. H., Cannon, R. J., Mac­Leod, A., & Walters, K. F. A. (2000). The role of climatic mapping in predicting the potential distribution of non-indigenous­pests under current and future climates. Agric. Ecosyst. Environ., 82(1–3), 57–71. doi: 10.1016/s0167-8809(00)00216-4

Bale, J. S., Masters, G. J., Hodkinson, I. D., Awmack, C., Bezemer, M. T., Brown, V. K, … Whittaker, J. B. (2002). Herbivory in global climate change research: direct effects of rising temperature on insect herbivores. Global Change Biol., 8(1), 1–16. doi: 10.1046/j.1365-2486.2002.00451.x

Chloupek, O., Hrstkova, P., & Schweigert, P. (2004). Yield and its stability, crop diversity, adaptability and response to climate change, weather and fertilisation over 75 years in the Czech Republic in comparison to some European countries. Field Crops Res., 85(2–3), 167–190. doi: 10.1016/S0378-4290(03)00162-X

Leschuk, N. V., Orlenko, N. S., Khareba, O. V., & Dydiv, O. J. (2020). The use of grouping morphological characteristics of Lettuce varieties L. var. capitata for the difference test in Ukraine. Int. J. Bot. Stud., 5(6), 516–522.

Leschuk, N. V., Mazhuha, K. M., Orlenko, N. S., Starychenko, Ye. M., & Shkapenko, Y. A. (2017). Comparative analysis of statistical software products for the qualification examination of plant varieties for suitability for distribution. Plant Var. Stud. Prot., 13(4), 429–435. doi: 10.21498/2518-1017.13.4.2017.117757 [in Ukrainian]

Inmon, W. H. (2002). Building the Data Warehouse (3rd ed.). New York, NY : John Wiley & Sons.

Kimball, R., & Ross, M. (2002). The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling. New York, NY : John Wiley & Sons.

Shakhovska, N. B., & Pasichnyk, V. V. (2009). Skhovyshcha ta prostory danykh [Data warehouses and spaces]. Lviv: Lvivska politekhnika. [in Ukrainian]

Cooper, B. L., Watson, H. J., Wixom, B. H., & Goodhue, D. L. (2000). Data Warehousing supports corporate strategy at First American Corporation. MIS Quarterly, 24(4), 547–567. doi: 10.2307/3250947

Tumanov, V. E. (2016). Proektirovanie khranilishch dannykh dlya prilozheniy sistem delovoy osvedomlennosti (Business Intelligence Systems) [Designing Data Warehouses for Business Intelligence Systems Applications (Business Intelligence Systems)] (2nd ed.). Moscow: Natsional’nyy Otkrytyy Universitet “INTUIT” [in Russian]

Abdullah, A., Brobst, S., Pervaiz, I., Umer, M., & Nisar, A. (2003). Agri Data Mining/Warehousing: Innovative tools for analysis of integrated agricultural and meteorological data: to appear in proceedings of International Workshop on Frontiers of Information Technology, COMSATS (CIIT), Islamabad, Pakistan. Retrieved from https://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.115.9159&rep=rep1&type=pdf

Jindal, R., & Taneja, S. (2011). Comparative study of data warehouse design approaches: A survey. Int. J. Database Manag. Syst., 4(1), 205–210. doi: 10.5121/ijdms.2012.4104

Agrawal, R. R., Gupta, A., & Sarawagi, S. (1997). Modelling Multidimensional Databases. Proc. 13th Int. Conf. on Data Engineering (pp. 232–243). doi: 10.1109/ICDE.1997.581777

Sharma, L., & Mehta, N. (2012). Data Mining Techniques: A Tool for Knowledge Management System in Agriculture. Int. J. Sci. Technol. Res., 1(5), 67–73.

Gupta, A. K., Mazumdar, B. D. (2013). Multidimensional schema for agricultural. Int. J. Res. Eng. Technol., 2(3), 245–253. doi: 10.15623/IJRET.2013.0203006

Yost, M., & Nealon, J. (1999). Using a dimensional data warehouse to standardize survey and census metadata. National Agricultural Statistics Service, U.S. Department of Agriculture. Retrieved from https://nces.ed.gov/FCSM/pdf/II_B_Yost_FCSM1999.pdf

Sharma, S. D., Singh, R., & Rai A. (2000). Integrated National Agricultural Resources Information System (INARIS). New Delhi: Indian Agricultural Statistics Research Institute. Retrieved from https://www.geospatialworld.net/article/integrated-national-agricultural-resources-information-system-inaris/

Abdullah, A., Brobst, S., Pervaiz, I., Umer, M., & Nisar, A. (2003). Agri Data Mining/Warehousing: Innovative tools for analysis of integrated agricultural and meteorological data: to appear in proceedings of International Workshop on Frontiers of Information Technology, COMSATS (CIIT). Islamabad, Pakistan. Retrieved from https://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.115.9159&rep=rep1&type=pdf

Nilakanta, S., Scheibe, K., & Rai, A. (2008). Dimensional issues in agricultural data warehouse designs. Comput. Electron. Agric., 60(2), 263–278. doi: 10.1016/j.compag.2007.09.009

Published

2021-09-30

How to Cite

Melnyk, S. I., Leschuk, N. V., Orlenko, N. S., Starychenko, E. M., Mazhuha, K. M., & Shkapenko, Y. A. (2021). Features of recording of meteorological conditions in the data warehouse of qualification examination of plant varieties. Plant Varieties Studying and Protection, 17(3), 254–261. https://doi.org/10.21498/2518-1017.17.3.2021.242980

Issue

Section

ЦИФРОВІ ТЕХНОЛОГІЇ В АГРОНОМІЇ ТА БІОЛОГІЇ