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. 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.
    4. Elahi, Ehsan & Khalid, Zainab & Weijun, Cui & Zhang, Huiming, 2020. "The public policy of agricultural land allotment to agrarians and its impact on crop productivity in Punjab province of Pakistan," Land Use Policy, Elsevier, vol. 90(C).
    5. Assa, Hirbod & Sharifi, Hossein & Lyons, Andrew, 2021. "An examination of the role of price insurance products in stimulating investment in agriculture supply chains for sustained productivity," European Journal of Operational Research, Elsevier, vol. 288(3), pages 918-934.
    6. 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.
    7. 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.
    8. repec:spo:wpecon:info:hdl:2441/eu4vqp9ompqllr09i29kgilc0 is not listed on IDEAS
    9. Patrik Gustavsson Tingvall & Josefin Videnord, 2020. "Regional differences in effects of publicly sponsored R&D grants on SME performance," Small Business Economics, Springer, vol. 54(4), pages 951-969, April.
    10. repec:spo:wpmain:info:hdl:2441/62drs526639gbqbrni9v9kvsv5 is not listed on IDEAS
    11. repec:hal:wpspec:info:hdl:2441/eu4vqp9ompqllr09i29kgilc0 is not listed on IDEAS
    12. Ronny Mazzocchi, 2013. "Investment-Saving Imbalances with Endogenous Capital Stock," DEM Discussion Papers 2013/14, Department of Economics and Management.
    13. Elahi, Ehsan & Khalid, Zainab, 2022. "Estimating smart energy inputs packages using hybrid optimisation technique to mitigate environmental emissions of commercial fish farms," Applied Energy, Elsevier, vol. 326(C).
    14. repec:spo:wpmain:info:hdl:2441/1cpd872l2j8lb968d53pu5f30q is not listed on IDEAS
    15. 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).
    16. 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).
    17. Jesus Felipe & J. S. L. Mccombie, 2007. "On the Rental Price of Capital and the Profit Rate: The Perils and Pitfalls of Total Factor Productivity Growth," Review of Political Economy, Taylor & Francis Journals, vol. 19(3), pages 317-345.
    18. Jesus Felipe, 2005. "Aggregate Investment In The People'S Republic Of China: A Comment," CAMA Working Papers 2005-17, Centre for Applied Macroeconomic Analysis, Crawford School of Public Policy, The Australian National University.
    19. 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.
    20. Joseph I. Amuka & Fredrick O. Asogwa & Collins C. Ugwu & Kelvin C. Ugwu, 2018. "Testing the Fit of Cobb-Douglass Production Function Within Unrestricted Least Squares," International Journal of Economics and Financial Issues, Econjournals, vol. 8(3), pages 142-147.
    21. Gilberto Gonz'alez-Parra & Benito Chen-Charpentier & Abraham J. Arenas & Miguel Diaz-Rodriguez, 2015. "Mathematical modeling of physical capital using the spatial Solow model," Papers 1504.04388, arXiv.org.
    22. Roman G. Smirnov & Kunpeng Wang, 2019. "The Cobb-Douglas production function revisited," Papers 1910.06739, arXiv.org, revised Oct 2019.
    23. 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).
    24. Jael, Paul, 2019. "Sommes-nous payés selon la productivité marginale ? [Does Marginal Productivity Mean Anything in Real Economic Life ?]," MPRA Paper 93814, University Library of Munich, Germany.

    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.