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

J. TyrychtrA. Vasilenko


No 3/2015, September
pp. 71-77

Tyrychtr J., Vasilenko A. (2015) "Transformation Econometric Model to Multidimensional Databases to Support the Analytical Systems in Agriculture“, AGRIS on-line Papers in Economics and Informatics, Vol. 7, No. 3, pp. 71 – 77. ISSN 1804-1930

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.

Keywords

Multidimensional database, OLAP, econometric model, production function, conceptual design, agriculture.

References

  1. Abelló, A., Romero, O. Encyclopedia of Database Systems. Ling L., Özsu, T. M. USA: Springer US, On-Line Analytical Processing. 2008, p. 1949-1954. ISBN 978-0-387-35544-3.
  2. Boulil, K., Le Ber, F., Bimonte, S., Grac, C., Cernesson, F. Multidimensional Modeling and Analysis of Large and Complex Watercourse Data: An OLAP-Based Solution. Ecological Informatics. 2014, vol. 24, p. 90-106. ISSN 1574-9541. DOI 10.1016/j.ecoinf.2014.07.001.
  3. Burstein, F., Holsapple, C. Handbook on decision support systems. 2008, Springer. ISBN 978-3-540-48712-8.
  4. García, S. C., Tamayo, J. E. I., Carbonell-Olivares, J., Cabrera, Y. P. Application of the Game Theory with Perfect Information to an Agricultural Company. Agricultural Economics. 2013, Vol. 59, No. 1. ISSN 0139-570X. DOI 10.17221/1/2012-AGRICECON.
  5. Čechura, L. Estimation of Technical Efficiency in Czech Agriculture with Respect to Firm Heterogeneity. Agricultural Economics. 2010, Vol. 56, p. 183-191. ISSN 0139-570X. DOI 10.17221/23/2010-AGRICECON.
  6. Čechura, L., Taussigová, T. Avian Influenza and Structural Change in the Czech Poultry Industry. Agricultural Economics. 2013, Vol. 59, No. 1. ISSN 0139-570X. DOI 10.17221/63/2012-AGRICECON.
  7. Codd, E. F., Codd, S. B., Salley, C. T. Providing OLAP (on-Line Analytical Processing) to UserAnalysts: An IT Mandate. 1993, Codd and Date, Vol. 32.
  8. Datta, A., Thomas, H. The Cube Data Model: A Conceptual Model and Algebra for on-Line Analytical Processing in Data Warehouses. Decision Support Systems. 1999, Vol. 27, No. 3, p. 289-301. ISSN 0975-8887. DOI 10.1016/S0167-9236(99)00052-4.
  9. Fahrner, Ch. Vossen, G. A Survey of Database Design Transformations Based on the EntityRelationship Model. Data & Knowledge Engineering. 1995, Vol. 15, No. 3, p. 213-250. ISSN 0169-023X. DOI 10.1016/0169-023X(95)00006-E.
  10. Felipe, J., Adams, F. G. "A Theory of Production" the Estimation of the Cobb-Douglas Function: A Retrospective View. Eastern Economic Journal. 2005, Vol. 31, No. 3, p. 427-445. ISSN 0094-5056.
  11. Kimball, R. The data warehouse lifecycle toolkit: expert methods for designing, developing, and deploying data warehouses. 1998, John Wiley & Sons. ISBN 978-0-471-25547-5.
  12. Kroupová, Z. Technická efektivnost ekologického zemědělství České republiky. Ekonomická Revue. 2010, Vol. 2, p. 61-73. ISSN 1212-3951. DOI 10.7327/cerei.2010.06.01.
  13. Lips, M., Schmid, D., Jan, P. Labour-use Pattern on Swiss Dairy Farms. Agricultural Economics. 2013, Vol. 59, No. 4. ISSN 0139-570X. DOI 10.17221/121/2012-AGRICECON.
  14. Mylopoulos, J. Database design. 2009, Ling L., Özsu, T. M., Springer US, p. 708-710. ISBN 978-0-387-35544-3.
  15. Novotný, O., Pour, J., Slánský, D. Business Intelligence: Jak využít bohatství ve vašich datech. Prague: Grada Publishing, 2005. ISBN 80-247-1094-3.
  16. Pardillo, J., Mazón, J.-N., Trujillo, J. Extending OCL for OLAP Querying on Conceptual Multidimensional Models of Data Warehouses. Information Sciences. 2010, Vol. 180, No. 5, p. 584-601. ISSN 0020-0255. DOI 10.1016/j.ins.2009.11.006.
  17. Pedersen, T. B. Encyclopedia of Database Systems. Ling L., Özsu, T. M. USA: Springer US, 2009a, Multidimensional Modeling, p. 1777-1784. ISBN 978-0-387-35544-3.
  18. Pedersen, T. B. Encyclopedia of Database Systems. Ling L., Özsu, T. M. USA: Springer US, 2009b, Cube, p. 538-539. ISBN 978-0-387-35544-3.
  19. Pedersen, T. B. Encyclopedia of Database Systems. Ling L., Özsu, T. M. USA: Springer US, 2009c, Dimension, p. 836-836. ISBN 978-0-387-35544-3.
  20. Rai, A., Dubey, V., Chaturvedi, K. K., Malhotra, P. K. Design and Development of Data Mart for Animal Resources. Computers and Electronics in Agriculture. 2008, vol. 64, No. 2, p. 111-119. ISSN 0168-1699. DOI 10.1016/j.compag.2008.04.009.
  21. Schulze, Ch., Spilke, J., Lehner, W. Data Modeling for Precision Dairy Farming within the Competitive Field of Operational and Analytical Tasks. Computers and Electronics in Agriculture. 2007, Vol. 59, No. 1, p. 39-55. ISSN 0168-1699. DOI 10.1016/j.compag.2007.05.001.
  22. Tvrdoň, J. Ekonometrie (Econometric). 2006, Prague. Czech University of Life Sciences Prague. ISBN 80-213-0819-2.
  23. Tyrychtr, J., Ulman, M., Vostrovský, V. Evaluation of the State of the Business Intelligence among Small Czech Farms. Agricultural Economics. 2015, Vol. 61, No. 2, p. 63-71. ISSN 0139-570X. DOI 10.17221/108/2014-AGRICECON.
  24. Vassiliadis, P., Sellis, T. A Survey of Logical Models for OLAP Databases. ACM Sigmod Record. 1999, Vol. 28, No. 4, p. 64-69. ISSN 0163-5808. DOI 10.1145/344816.344869.

Full paper

  Full paper (.pdf, 660.31 KB).