Agric. Econ. - Czech, 2015, 61(2):63-71 | DOI: 10.17221/108/2014-AGRICECON

Evaluation of the state of the Business Intelligence among small Czech farmsOriginal Paper

Jan TYRYCHTR1, Miloš ULMAN1, Václav VOSTROVSKÝ2
1 Department of Information Technology, Faculty of Economic and Management, Czech University of Life Sciences in Prague, Prague, Czech Republic
2 Department of Software Engineering, Faculty of Economic and Management, Czech University of Life Sciences in Prague, Prague, Czech Republic

Business Intelligence (BI) can assist in agricultural enterprises to strengthen their production potential and technical efficiency due to its effective support to the managerial, analytical, planning, and decision-making activities of managers and specialists. However, the state of the BI in the Czech Republic is not still completely understood. In this context, this paper aims at the evaluation of the current state of the art of the BI among small Czech farms. The focus of the research was put on the evaluation of both the state of the BI, and the relevant business information systems and software for agriculture. There was a survey among 135 agricultural entrepreneurs from various regions in the Czech Republic. The survey results are presented by the descriptive statistics and frequency tables. There is an examination of the relationship between the agricultural enterprise structure and the use of the BI. Dependencies among the examined characteristics were sought by the means of the analysis of qualitative variables. With 95% probability, it could be claimed that the type of production, the size of farmed land, the number of employees and the level of financial subsidies have no significant impact on using the BI, the expert and analytical systems in agricultural enterprises. .

Keywords: agriculture, information systems, multidimensional database, OLAP, precision agriculture

Published: February 28, 2015  Show citation

ACS AIP APA ASA Harvard Chicago IEEE ISO690 MLA NLM Turabian Vancouver
TYRYCHTR J, ULMAN M, VOSTROVSKÝ V. Evaluation of the state of the Business Intelligence among small Czech farms. Agric. Econ. - Czech. 2015;61(2):63-71. doi: 10.17221/108/2014-AGRICECON.
Download citation

References

  1. Abdelhédi F., Zurfluh G. (2013): User Support System for Designing Decisional Database. In: Sixth International Conference on Advances in Computer-Human Interactions, Nice: 377-382.
  2. Abelló A., Romero O. (2009): On-Line Analytical Processing (OLAP). In: Ozsu T., Ling Liu (eds): Encyclopedia of Database Systems: 1949-1954. Springer. Go to original source...
  3. Ballard C. et al. (1998): Data modeling techniques for data warehousing. IBM Redbooks.
  4. Boehnlein M., Ulbrich-vom Ende A. (1999): Deriving initial Data Warehouse Structures from the Conceptual Data Models of the Underlying Operational Information Systems. ACM, New York. Go to original source...
  5. Bolboacă S.D., Jäntschi L., Sestraş A.F., Sestraş R.E., Pamfil D.C. (2011): Pearson-Fisher Chi-Square Statistic Revisited. Information, 2: 528-545. Go to original source...
  6. Cabrera García S., Imbert Tamayo J.E., Carbonell-Olivares J., Pacheco Cabrera Y. (2013): Application of the Game Theory with Perfect Information to an agricultural company. Agricultural Economics - Czech, 59: 1-7. Go to original source...
  7. Canal L., Micciolo R. (2012): The Chi-square controversy: what if Pearson had R? Journal of Statistical Computation and Simulation, 84: 1015-1021. Go to original source...
  8. Čechura L. (2010): Estimation of Technical Efficiency in Czech agriculture with respect to firm heterogeneity. Agricultural Economics - Czech, 56: 183-191. Go to original source...
  9. Čechura L., Taussigová T. (2013): Avian influenza and structural change in the Czech poultry industry. Agricultural Economics - Czech, 59: 38-47. Go to original source...
  10. Chaudhuri S., Dayal U. (1997): An overview of data warehousing and OLAP technology. ACM Sigmod Record, 26: 65-74. Go to original source...
  11. Choudhary K., Pandey U., Nayak M.K., Mishra D.K. (2011): Electronic data interchange: A review. IEEE Conference Publication: 323-327; doi: 10.1109/CICSyN.2011.74 Go to original source...
  12. Datta A., Thomas H. (1999): The Cube data model: a conceptual model and algebra for on-line analytical processing in data warehouses. Decision Support Systems, 27: 289-301. Go to original source...
  13. Gupta A.K., Mazumdar B.D. (2013): Computational model for agricultural decision support system. International Journal of Computer Applications, 66, (15).
  14. Heinrich L.J., Riedl R. (2013): Understanding the dominance and advocacy of the design-oriented research approach in the business informatics community: A history-based examination. Journal of Information Technology, 28: 34-49. Go to original source...
  15. Janová J. (2014): Crop plan optimization under risk on a farm level in the Czech Republic. Agricultural Economics - Czech, 60: 123-132. Go to original source...
  16. Jarke M., Jeusfeld M.A., Quix C.J., Vassiliadis P., Vassiliou Y. (2013): Data warehouse architecture and quality: impact and open challenges. In: Seminal Contributions to Information Systems Engineering. Springer: 183-189. Go to original source...
  17. Khan A. (2005): SAP and BW Data Warehousing: How to Plan and Implement. iUniverse, Inc.
  18. Kroupová Z. (2010): Technická efektivnost ekologického zemědělství České republiky. (Technical efficiency of organic farming in the Czech Republic.) Ekonomická Revue, 2: 61-73. Go to original source...
  19. Kubata K., Tyrychtr J., Ulman M., Vostrovský V. (2014): Business informatics and its role in agriculture in the Czech Republic. AGRIS on-Line Papers in Economics and Informatics, 6: 59-66.
  20. Kumar V. (2010): Customer Relationship Management. Published Online, Wiley Online Library. Go to original source...
  21. Levene M., Loizou G. (2003): Why is the Snowflake Schema a Good Data Warehouse Design? Information Systems, 28: 225-240. Go to original source...
  22. Lips M., Schmid D., Jan P. (2013): Labour-use pattern on Swiss dairy farms. Agricultural Economics - Czech, 2013, 59, 149-159. Go to original source...
  23. Lososová J., Zdeněk R. (2013): Development of farms according to the LFA classification. Agricultural Economics - Czech, 2013, 59: 563-577. Go to original source...
  24. Maryska M., Novotny O. (2013): The reference model for managing business informatics economics based on the corporate performance management - proposal and implementation. Technology Analysis & Strategic Management, 25: 129-146. Go to original source...
  25. McGuff F. (1998): Designing the Perfect Data Warehouse. Available at http://members.aol.com/fmcguff/dwmodel/index.htm (accessed 30.09.1999).
  26. MZe (2013): Zpráva o stavu zemědělství ČR za rok 2012. (Report on the Czech Agriculture for 2012.) Available at http://eagri.cz/public/web/file/291876/Zprava_o_stavu_zemedelstvi_CR_za_rok_2012.pdf
  27. Novotný O., Pour J., Slánský D. (2005): Business Intelligence: Jak využít bohatství ve vašich datech. Grada Publishing, Praha.
  28. Pedersen T.B. (2009a): Multidimensional Modeling. In: Lui L., Ôzsu M.T. (eds): Encyclopedia of Database Systems: 1777-1784. Springer, Berlin/Heidelberg. Go to original source...
  29. Pedersen T.B. (2009b): Cube. In: Lui L., Ôzsu M.T. (eds): Encyclopedia of Database Systems: 538-539. Springer, Berlin/Heidelberg. Go to original source...
  30. Pedersen T.B. (2009c): Dimension. In: Lui L., Ôzsu M.T. (eds): Encyclopedia of Database Systems: 836-836. Springer, Berlin/Heidelberg. Go to original source...
  31. Pour J., Maryška M., Novotný O. (2012): Business Intelligence v podnikové praxi. Professional Publishing, Praha.
  32. Rai A., Dubey V., Chaturvedi KK., Malhotra P.K. (2008): Design and development of data mart for animal resources. Computers and Electronics in Agriculture, 64: 111-119. Go to original source...
  33. Schulze C.,Spilke J., Lehner W. (2007): Data modeling for precision dairy farming within the competitive field of operational and analytical tasks. Computers and Electronics in Agriculture, 59: 39-55. Go to original source...
  34. Sheskin D.J. (2003): Handbook of Parametric and Nonparametric Statistical Procedures. CRC Press. Go to original source...
  35. Sørensen C.G., Fountas S., Nash E., Personen L., Bochtis D., Pedersen S.M., Basso B., Blackmore S.B. (2010): Conceptual model of a future farm management information system. Computers and Electronics in Agriculture, 72: 37-47. Go to original source...
  36. Vassiliadis P., Sellis T. (1999): A survey of logical models for OLAP databases. ACM Sigmod Record, 28: 64-69. Go to original source...
  37. Wu M.-C., Buchmann A.P. (1997): Research issues in data warehousing. In: Dittrich K.R., Geppert A. (eds): Datenbanksysteme in Büro, Technik und Wissenschaft: 61-82. Springer. Go to original source...
  38. Zádová V. (2009): Multidimenzionální modelování v rámci analýzy a návrhu IS/ICT. (Multidimensional modelling in analysis and design of IS/ICT.) Systémová integrace, 4: 66-76.

This is an open access article distributed under the terms of the Creative Commons Attribution-NonCommercial 4.0 International (CC BY NC 4.0), which permits non-comercial use, distribution, and reproduction in any medium, provided the original publication is properly cited. No use, distribution or reproduction is permitted which does not comply with these terms.