J. Felföldi, Szilvia Botos, L. Bálint, D. Sulyok, Sándor Csenki, Viktor László Takács
{"title":"一个面向过程的数据仓库,支持作物生产中的决策过程","authors":"J. Felföldi, Szilvia Botos, L. Bálint, D. Sulyok, Sándor Csenki, Viktor László Takács","doi":"10.17700/jai.2023.14.1.697","DOIUrl":null,"url":null,"abstract":"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. \nIt 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. \nIn our article, we present the structure of a process-oriented data warehouse created according to the OLAP (online analytical processing) principle, which is suitable for displaying immediate results and creating analytical queries, as well as for displaying different combinations of variables for making economic decisions.","PeriodicalId":37272,"journal":{"name":"International Journal of Sustainable Agricultural Management and Informatics","volume":"63 1","pages":""},"PeriodicalIF":1.2000,"publicationDate":"2023-07-06","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"A process-oriented data warehouse to support decision making process in crop production\",\"authors\":\"J. Felföldi, Szilvia Botos, L. Bálint, D. Sulyok, Sándor Csenki, Viktor László Takács\",\"doi\":\"10.17700/jai.2023.14.1.697\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"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. \\nIt 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. \\nIn our article, we present the structure of a process-oriented data warehouse created according to the OLAP (online analytical processing) principle, which is suitable for displaying immediate results and creating analytical queries, as well as for displaying different combinations of variables for making economic decisions.\",\"PeriodicalId\":37272,\"journal\":{\"name\":\"International Journal of Sustainable Agricultural Management and Informatics\",\"volume\":\"63 1\",\"pages\":\"\"},\"PeriodicalIF\":1.2000,\"publicationDate\":\"2023-07-06\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"International Journal of Sustainable Agricultural Management and Informatics\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.17700/jai.2023.14.1.697\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"Q2\",\"JCRName\":\"AGRICULTURE, MULTIDISCIPLINARY\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"International Journal of Sustainable Agricultural Management and Informatics","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.17700/jai.2023.14.1.697","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"Q2","JCRName":"AGRICULTURE, MULTIDISCIPLINARY","Score":null,"Total":0}
A process-oriented data warehouse to support decision making process in crop production
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.
In our article, we present the structure of a process-oriented data warehouse created according to the OLAP (online analytical processing) principle, which is suitable for displaying immediate results and creating analytical queries, as well as for displaying different combinations of variables for making economic decisions.