Testing data analysis system for the technology of harmful substances forecasting
DOI:
https://doi.org/10.34121/1028-9763-2021-3-113-120Keywords:
information management, data warehouse, real-time data analysis, data mining, OLAP and Data Mining technologies, mycotoxins, управління інформацією, сховище даних, аналіз даних у режимі реального часу, інтелектуальний аналіз даних, технології OLAP і Data Minin, мікотоксиниAbstract
The issue of product safety is acute in many countries and companies. Indeed, every year a large number of people catch various diseases after using products contaminated with harmful substances. To increase food safety, there should be implemented some technologies which would enable quick testing of products and, using the obtained knowledge, to prevent appearance of harmful substances. Biosensor technologies which are utilized for conducting quick tests for agricultural purposes are being nowadays actively developed in the world. The use of data mining technologies can provide the identification of new knowledge about the nature and dependence of various harmful substances on external factors. The article considers the issues of construction and testing of forecasting technology, including analysis of existing solutions, search for forecasting models, usage of Data Mining methods to find qualitatively new knowledge and hypotheses, and hypothesis testing as well. The first section of the article provides an overview of existing models and methods, formulas for calculating the risk of aflatoxin. The second section contains a brief description of the data collection system which consists of a data warehouse, sensors and a mobile application as a data source. The results of data mining obtained after the use of Data Mining methods are presented in the third section of the paper. As a result, there was obtained a hypothesis of the effect on the appearance of mycotoxins in crops. Confirmation or refutation of the hypothesis was performed by testing it using OLAP-technologies. The results of the hypothesis test are presented in the last section. The main result of the work was obtaining a data analysis system ready for testing in real conditions. However, it should be noted that there is a need for more extensive testing on large amounts of data which can be accumulated over several years of observations.References
1. Зінченко О.І., Салатенко В.Н., Білоножко М.A. Рослинництво: підручник. К.: Аграрна освіта, 2001. 591 с.
2. Скляр В.Г. Екологічна фізіологія рослин: підручник / під заг. ред. Ю.А. Злобіна. Суми: ВТД «Університетська книга», 2015 . 271 с. ISBN 978-966-680-759-8.
3. Klem K., Váňová M., Hajšlová J., Lancová K., Sehnalová M. A neural network model for prediction of deoxynivalenol content in wheat grain based on weather data and preceding crop. Plant Soil and Environment. 2007. Vol. 53 (10). P. 421–429. DOI:10.17221/2200-PSE.
4. Chauhan Ya., Tatnell J., Krosch S., Karanja J., Gnonlonfin B., Wanjuki I., Wainaina J., Harvey J. An improved simulation model to predict pre-harvest aflatoxin risk in maize. Fields Crops Research. 2015. Vol. 178. P. 91–99. DOI: 10.1016/j.fcr.2015.03.024.
5. Battilani P., Camardo L.M., Rossi V., Giorni P. AFLA-maize, a mechanistic model for Aspergillus flavus infection and aflatoxin B1 contamination in maize. Comput. Electron. Agric. 2013. Vol. 94. P. 38–46.
6. Chauhan Y.S., Wright G.C., Rachaputi N.C. 2008. Modelling climatic risk of aflatoxin contamination in maize. Aust. J. Exp. Agric. 2008. Vol. 48. P. 358–366.
7. Golub B.L., Gudz A.V., Bushma A.V. Decision support information system in the process of growing biotechnical objects. Mathematical machines and systems. 2018. N 4. P. 26–35.
8. Hudz O.V., Karpiuk A.D., Holub B.L., Dudnyk A.O., Bushma A.V. Optical sensor for the detection of mycotoxins. Semiconductor Physics, Quantum Electronics & Optoelectronics, 2021. Vol. 24, N 2. P. 227–233.
Published
Issue
Section
License
Copyright (c) 2021 Mathematical Machines and Systems

This work is licensed under a Creative Commons Attribution 4.0 International License.
