Back to Search Start Over

A process-oriented data warehouse to support decision making process in crop production.

Authors :
Felföldi, János
Botos, Szilvia
Bálint, Levente P.
Sulyok, Dénes
Csenki, Sándor
László Takács, Viktor
Source :
Journal of Agricultural Informatics / Agrárinformatika Folyóirat. 2023, Vol. 14 Issue 1, p33-43. 11p.
Publication Year :
2023

Abstract

In our article, we present the structure of a process-oriented data warehouse created according to the OLAP (online analytical processing) principle that enables simple process controlling in crop production with 1 hectare process cost and time. To identify the sequence of operations and parallelism of the processes, we used interval ranking theory, which was implemented in the Power Query M formula language. The data available at the right time and in the right way and the economic calculations that can be produced from them, as well as the presentation of the produced information to managers, are crucial in the decision-making process for the organizations. Wide range of digital solutions has an important role to support the business activities and the decision making in the case of farm management as well. It is important to determine the structure of the data required to base the economic calculations, build a data model and create a multidimensional database, this lays the foundation for the calculation of economic and financial indicators, which can help in making economic decisions. [ABSTRACT FROM AUTHOR]

Details

Language :
English
ISSN :
2061862X
Volume :
14
Issue :
1
Database :
Academic Search Index
Journal :
Journal of Agricultural Informatics / Agrárinformatika Folyóirat
Publication Type :
Academic Journal
Accession number :
164825198
Full Text :
https://doi.org/10.17700/jai.2023.14.1.697