IDEAS home Printed from https://ideas.repec.org/a/ags/aolpei/231867.html
   My bibliography  Save this article

Transformation Econometric Model to Multidimensional Databases to Support the Analytical Systems in Agriculture

Author

Listed:
  • Tyrychtr, Jan
  • Vasilenko, Alexandr

Abstract

Econometric model application in farms is a very complex process requiring knowledge not only the economy but also statistical and mathematical methods in agriculture workers themselves. The solution may be an application of econometric problems in analytical decision support systems for farms managers. For such a solution is necessary to design a multidimensional database for support online analytical data processing (OLAP). This paper proposes a new method (called TEM-CM) for formal transformation of econometric model to the conceptual data model for creating multidimensional schemes. This new method allows to formalize the process of transferring production function in agriculture to multidimensional data model and thus contribute to a more efficient design of data warehouses and OLAP databases for decision support in the agricultural analytics systems.

Suggested Citation

  • Tyrychtr, Jan & Vasilenko, Alexandr, 2015. "Transformation Econometric Model to Multidimensional Databases to Support the Analytical Systems in Agriculture," AGRIS on-line Papers in Economics and Informatics, Czech University of Life Sciences Prague, Faculty of Economics and Management, vol. 7(3), pages 1-7, September.
  • Handle: RePEc:ags:aolpei:231867
    DOI: 10.22004/ag.econ.231867
    as

    Download full text from publisher

    File URL: https://ageconsearch.umn.edu/record/231867/files/agris_on-line_2015_3_tyrychtr_vasilenko.pdf
    Download Restriction: no

    File URL: https://libkey.io/10.22004/ag.econ.231867?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    References listed on IDEAS

    as
    1. Jesus Felipe & F. Gerard Adams, 2005. ""A Theory of Production" The Estimation of the Cobb-Douglas Function: A Retrospective View," Eastern Economic Journal, Eastern Economic Association, vol. 31(3), pages 427-445, Summer.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Jan Tyrychtr & Martin Pelikán & Hana Štiková & Ivan Vrana, 2018. "EM-OLAP Framework," Business & Information Systems Engineering: The International Journal of WIRTSCHAFTSINFORMATIK, Springer;Gesellschaft für Informatik e.V. (GI), vol. 60(6), pages 543-562, December.
    2. Hassan, Samir Ul & Khanday, Shafi Ahmad & Ahmad, Masroor & Mishra, Biswambhara & Rymbai, Motika Sinha, 2022. "A Historical Cum Empirical Overview of Agriculture Spending and Output Nexus in India," AGRIS on-line Papers in Economics and Informatics, Czech University of Life Sciences Prague, Faculty of Economics and Management, vol. 14(3), September.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Frédéric Reynès, 2011. "The cobb-douglas function as an approximation of other functions," SciencePo Working papers Main hal-01069515, HAL.
    2. Jael, Paul, 2019. "Does Marginal Productivity Mean Anything in Real Economic Life ?," MPRA Paper 97968, University Library of Munich, Germany, revised Jan 2020.
    3. T. Gerasimos S. & V. Erotokritos & Т. Герасимос С. & В. Эротокритос, 2017. "Предварительный поведенческий подход в таргетированию реальных доходов // A Tentative Behavioral Approach to Real Income Targeting," Review of Business and Economics Studies // Review of Business and Economics Studies, Финансовый Университет // Financial University, vol. 5(1), pages 17-31.
    4. Frédéric Reynès, 2017. "The Cobb-Douglas function as a flexible function. Analysing the substitution between capital, labor and energy," Documents de Travail de l'OFCE 2017-12, Observatoire Francais des Conjonctures Economiques (OFCE).
    5. Roman G. Smirnov & Kunpeng Wang, 2019. "The Cobb-Douglas production function revisited," Papers 1910.06739, arXiv.org, revised Oct 2019.
    6. Elahi, Ehsan & Zhang, Zhixin & Khalid, Zainab & Xu, Haiyun, 2022. "Application of an artificial neural network to optimise energy inputs: An energy- and cost-saving strategy for commercial poultry farms," Energy, Elsevier, vol. 244(PB).
    7. Frédéric Reynès, 2011. "The cobb-douglas function as an approximation of other functions," Working Papers hal-01069515, HAL.
    8. Gustavsson Tingvall, Patrik & Videnord, Josefin, 2017. "Regional Effects of Publicly Sponsored R&D Grants on SME Performance," Ratio Working Papers 289, The Ratio Institute.
    9. Hans Frost & Peder Andersen & Ayoe Hoff, 2013. "Management of Complex Fisheries: Lessons Learned from a Simulation Model," Canadian Journal of Agricultural Economics/Revue canadienne d'agroeconomie, Canadian Agricultural Economics Society/Societe canadienne d'agroeconomie, vol. 61(2), pages 283-307, June.
    10. Harris, Patrick, 2020. "Causal Factors of Australian Beef Exports," MPRA Paper 98766, University Library of Munich, Germany.
    11. repec:hal:spmain:info:hdl:2441/1cpd872l2j8lb968d53pu5f30q is not listed on IDEAS
    12. Bilel Jarraya & Hatem Afi & Anis Omri, 2023. "Analyzing the Profitability and Efficiency in European Non-Life Insurance Industry," Methodology and Computing in Applied Probability, Springer, vol. 25(2), pages 1-25, June.
    13. Lina Isabel Brand Correa, 2014. "Resena: The economic growth engine. How energy and work drive material prosperity, de Robert U. Ayres y Benjamin Warr. Cheltenham, Uk: Edward Elgar, 2009," Revista Cuadernos de Economia, Universidad Nacional de Colombia, FCE, CID, June.
    14. Chivu, Luminita & Andrei, Jean Vasile & Zaharia, Marian & Gogonea, Rodica-Manuela, 2020. "A regional agricultural efficiency convergence assessment in Romania – Appraising differences and understanding potentials," Land Use Policy, Elsevier, vol. 99(C).
    15. Yu. D. Grigoriev & V. B. Melas & P. V. Shpilev, 2018. "Excess of locally D-optimal designs for Cobb–Douglas model," Statistical Papers, Springer, vol. 59(4), pages 1425-1439, December.
    16. repec:hal:wpspec:info:hdl:2441/eu4vqp9ompqllr09i29kgilc0 is not listed on IDEAS
    17. Zhao, Xiaobing & Du, Ding & Xiong, Jun & Springer, Abraham & Masek Lopez, Sharon R. & Winkler, Blake & Hubler, Kenedy, 2019. "The impact of forest restoration on agriculture in the Verde River watershed, Arizona, USA," Forest Policy and Economics, Elsevier, vol. 109(C).
    18. Faruq-Uz-Zaman, Muhammad, 2021. "Contribution of Factors Affecting Crop Production in Bangladesh: An Empirical Analysis with Production Function Approach," OSF Preprints kxaym, Center for Open Science.
    19. Besa Xhaferi, 2015. "Production Function of Companies - The Case of Macedonia and Albania," International Journal of Management Sciences, Research Academy of Social Sciences, vol. 5(3), pages 213-221.
    20. repec:hal:spmain:info:hdl:2441/62drs526639gbqbrni9v9kvsv5 is not listed on IDEAS
    21. Keen, Steve & Ayres, Robert U. & Standish, Russell, 2019. "A Note on the Role of Energy in Production," Ecological Economics, Elsevier, vol. 157(C), pages 40-46.
    22. Reynès, Frédéric, 2019. "The Cobb–Douglas function as a flexible function," Mathematical Social Sciences, Elsevier, vol. 97(C), pages 11-17.
    23. Thanh Tam Nguyen-Huu & Khac Minh Nguyen & Quoc Tran-Nam, 2022. "The role of environmental practices and innovation in total factor productivity convergence -Evidence from small-and medium-sized manufacturing enterprises in Vietnam," Post-Print hal-04248191, HAL.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:ags:aolpei:231867. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: AgEcon Search (email available below). General contact details of provider: https://edirc.repec.org/data/fevszcz.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.